Skip to main content
Card class: Card

At a glance

Count of open Customer Ledger Entries (Document Type = Invoice, Open = TRUE). Volume metric to pair with Overdue Invoice Value.
What it countsDistinct count of open Sales Invoices in Customer Ledger Entries.
Tax treatmentn/a (count metric).
Time windowRT
Alert trigger-
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, 14 Apr 26: 1,284 unpaid invoices. Average $8,894 per invoice. Volume vs value tells the collection team where to focus: high-volume + low-value = process automation needed; low-volume + high-value = high-touch escalation.

Sibling cards merchants should reference together

CardWhy pair
Overdue Invoice ValueDollar value.
DSOVelocity.
Cash Application RateOperations efficiency.

Reconciling against the vendor’s own dashboard

Where to look in Business Central:
Customer Ledger Entries filtered to Open = TRUE, Document Type = Invoice Power BI > Receivables Insights
Why may differ:
ReasonDirectionWhy
OData freshnessCard 15 min behind
Cross-connector reconciliation: No commerce-side counterpart.

Known limitations / merchant FAQs

High count + low avg value: action? Process automation: lockbox, auto-apply rules, customer self-service portals. Multi-Company aggregation? Yes. Sales Credit Memos count? Excluded.

Tracked live in Vortex IQ Nerve Centre

Unpaid Invoice Count 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.