> ## Documentation Index
> Fetch the complete documentation index at: https://docs.vortexiq.ai/llms.txt
> Use this file to discover all available pages before exploring further.

# Overdue Invoice Value, Microsoft Dynamics 365

> Overdue Invoice Value for Microsoft Dynamics 365 stores. Tracked live in Vortex IQ Nerve Centre. How to read it, why it matters, and how to act on it.

**Metrics type:** [Supporting Metrics](/nerve-centre/overview#metrics-types-explained)  •  **Category:** [Ecommerce Platform](/nerve-centre/connectors#connectors-by-type)

## 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 counts** | Open Customer Ledger Entries where `Due Date < TODAY`, `Document Type = 'Invoice'`, `Open = TRUE`. |
| **Tax treatment**  | Gross (includes VAT).                                                                              |
| **Currency**       | Reporting Currency.                                                                                |
| **Time window**    | `RT`                                                                                               |
| **Alert trigger**  | `>$50k overdue >60 days`                                                                           |
| **Sentiment key**  | `overdue`                                                                                          |
| **Roles**          | owner, 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.

| Aging               | Overdue 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.42M total AR is overdue. The 90+ portion ($360K) is at risk of bad-debt provision.

## Sibling cards merchants should reference together

| Card                                                                                                  | Why pair                     |
| ----------------------------------------------------------------------------------------------------- | ---------------------------- |
| [DSO](/nerve-centre/kpi-cards/microsoft-dynamics/days-sales-outstanding)                              | Higher overdue = higher DSO. |
| [AR Aging Buckets](/nerve-centre/kpi-cards/microsoft-dynamics/a-r-aging-detail)                       | Per-customer detail.         |
| [Invoice Aging Summary](/nerve-centre/kpi-cards/microsoft-dynamics/invoice-aging-summary)             | All AR not just overdue.     |
| [High-Value Overdue Invoices](/nerve-centre/kpi-cards/microsoft-dynamics/high-value-overdue-invoices) | Alert.                       |

## 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:**

| Reason                        | Direction          | Why |
| ----------------------------- | ------------------ | --- |
| **OData freshness**           | Card 15 min behind |     |
| **Multi-Company aggregation** | Card 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](https://app.vortexiq.ai/login) or [book a demo](https://www.vortexiq.ai/contact-us) to see this metric running on your own data.