Skip to main content
Metrics type: Supporting Metrics • Category: Ecommerce Platform
Detailed A/R aging across 0-30, 31-60, 61-90, 91-120, 120+ buckets.

​
At a glance

Per-customer AR aging detail. Each row: Customer Name, total open AR, breakdown across 0-30 / 31-60 / 61-90 / 91-120 / 120+ buckets, oldest invoice age. The collections team’s daily worklist.

​
Calculation

Calculated automatically from your Microsoft Dynamics 365 data. See the At a glance summary above for what the metric tracks and the worked example below for a typical reading.

​
Worked example

US distributor on BC, snapshot 14 Apr 26. Acme has $320K in 90+ buckets, oldest 145 days. Collection conversation overdue.

​
Sibling cards merchants should reference together

​
Reconciling against the vendor’s own dashboard

Where to look in Business Central:
Reports > Finance > Customer > Aged Accounts Receivable (definitive) Customer List > Statistics
Why may differ: Cross-connector reconciliation: No commerce-side counterpart. AR is BC-internal.

​
Known limitations / merchant FAQs

Concentration risk? If 3 customers carry 60% of 90+ AR, focus collection effort there first. Aging by Due Date or Posting Date? Due Date by default; configurable. Privacy: customer name visibility? Privacy Blocked customers shown as “[Privacy Blocked]”. Multi-Company: same customer? Aggregated by Customer No. across Companies. Auto-export to Excel for collection calls? Yes, CSV export by default.

​
Tracked live in Vortex IQ Nerve Centre

A/R Aging Detail is one of hundreds of KPI pulses Vortex IQ tracks across Microsoft Dynamics 365 and 70+ other ecommerce connectors. Nerve Centre runs the detection layer; Vortex Mind investigates the cause when something moves; Ask Viq lets you interrogate any number in plain English. Start for free or book a demo to see this metric running on your own data.