Skip to main content
Metrics type: Supporting MetricsCategory: Ecommerce Platform

At a glance

Total dollar value of posted Sales Invoices past their Due Date and not yet paid. The pure overdue subset of AR.

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. 40% of 11.42MtotalARisoverdue.The90+portion(11.42M total AR is overdue. The 90+ portion (360K) is at risk of bad-debt provision.

Sibling cards merchants should reference together

Reconciling against the vendor’s own dashboard

Where to look in Business Central:
Reports > Finance > Customer > Customer Aging Statistics Aged Accounts Receivable filtered to past Due Date
Why may differ: Cross-connector reconciliation: No commerce-side counterpart.

Known limitations / merchant FAQs

Healthy overdue %? < 25% of total AR is healthy for B2B. > 40% indicates collection or credit policy issues. Bad debt provision threshold? Most policies require 100% provision on AR > 180 days, 50% on 121-180, 10% on 91-120. Sales Credit Memos applied? Net Customer Ledger Entry remaining amount used. Disputed invoices? Excluded if BC has a Dispute flag set on the Customer Ledger Entry. Configure if your AL Extension uses different field. Multi-Company aggregation? Yes.

Tracked live in Vortex IQ Nerve Centre

Overdue Invoice Value 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.