Skip to main content
Card class: Non-HeroCategory: 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.
What it countsOpen Customer Ledger Entries where Due Date < TODAY, Document Type = 'Invoice', Open = TRUE.
Tax treatmentGross (includes VAT).
CurrencyReporting Currency.
Time windowRT
Alert trigger>$50k overdue >60 days
Sentiment keyoverdue
Rolesowner, finance

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.
AgingOverdue value (USD)
1-30 days past due$2,420,000
31-60 days past due$1,180,000
61-90 days past due$620,000
90+ days past due$360,000
Total Overdue$4,580,000
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

CardWhy pair
DSOHigher overdue = higher DSO.
AR Aging BucketsPer-customer detail.
Invoice Aging SummaryAll AR not just overdue.
High-Value Overdue InvoicesAlert.

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:
ReasonDirectionWhy
OData freshnessCard 15 min behind
Multi-Company aggregationCard sums
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.