Table of Contents

Payables

The central cockpit for monitoring open and overdue vendor payables based on Dynamics 365 Business Central data.

Payables report

One screen to see how much you owe vendors, how much is overdue, and how the obligation spreads across ageing groups and vendors - so you can manage payment timing and protect supplier relationships.

At a glance

Generated from the report definition (Payables / Payables).

  • Key visuals: matrix, scatter chart, table

What this report helps you do

  • See total open and overdue payables at a glance
  • Break the payable balance down by ageing group and vendor
  • Spot the vendors and documents that drive overdue obligations
  • Plan payment runs by amount and days overdue

Filters & slicers

Filter What it does
Client Selection Focus on a single company or compare legal entities in multi-tenant scenarios.
Period Selection Analyze a rolling time frame or zoom into specific months, quarters or fiscal years.
Reference Date Evaluate open and overdue balances as of a chosen reference (posting) date.

Using these filters consistently ensures that all balances and ageing reflect the exact scope and as-of date you want to analyse.

Visuals on this page

Payables KPI Card

Management-level view of the payable position.

  • AP Amount Open and AP #Documents Open size the total open payables.
  • AP Amount Overdue, AP #Documents Overdue and AP Amount Overdue % quantify the overdue portion.

Ageing Matrix

A matrix contrasts open payables per ageing group and vendor.

  • Read open amounts per vendor across ageing buckets
  • Identify which vendors concentrate the overdue balance

Overdue Scatter

A scatter chart relates average days overdue to open amount per document.

  • Spot documents that are both large and severely overdue
  • Prioritise which payables to settle in the next run

Typical use cases

  • Payment-Run Planning — Decide which payables to settle based on due date, discount and overdue status.
  • Supplier-Risk Review — Track total payables and overdue share to protect key supplier relationships.
  • AP Amount Payable
  • AP Amount Open
  • AP Amount Overdue
  • AP Amount Overdue %
  • AP #Documents Overdue

See the full KPI & measure catalog for definitions and formats.

Back to all Cash standard reports · Semantic model · Key business questions

Edit this page