> ## 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, Oracle ERP Cloud

> Overdue Invoice Value for Oracle ERP Cloud 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 past-due Receivables across all open Invoices. The collection-pressure target. Rising overdue value drives DSO and signals collection slippage.

|                         |                                                                                                                                                                   |
| ----------------------- | ----------------------------------------------------------------------------------------------------------------------------------------------------------------- |
| **What it counts**      | `SUM(amount_due_remaining)` for transactions where `due_date < today` and `status = OPEN`. Excludes Credit Memos as overdue (a CM is a credit, not a receivable). |
| **Tax treatment**       | Gross.                                                                                                                                                            |
| **Currency**            | Reporting ledger.                                                                                                                                                 |
| **Business Unit scope** | Respects dashboard filter.                                                                                                                                        |
| **Time window**         | Real-time snapshot.                                                                                                                                               |
| **Alert trigger**       | `>$50k overdue >60 days`                                                                                                                                          |
| **Sentiment key**       | `overdue`                                                                                                                                                         |
| **Roles**               | owner, finance                                                                                                                                                    |

## Calculation

Calculated automatically from your Oracle ERP Cloud data. See the At a glance summary above for what the metric tracks and the worked example below for a typical reading.

## Worked example

A US Fortune 500 distributor on Oracle ERP Cloud. Snapshot 14 Apr 26.

| Bucket            | Overdue value    |
| ----------------- | ---------------- |
| 0-30 PD           | \$32,400,000     |
| 31-60 PD          | \$14,800,000     |
| 61-90 PD          | \$8,400,000      |
| 91-120 PD         | \$4,800,000      |
| 120+ PD           | \$3,600,000      |
| **Total Overdue** | **\$64,000,000** |

Five things to notice:

1. **$64M overdue out of $148M total open AR (43%).** This sounds high but reflects healthy Net-30 terms where most "overdue" is \< 30 days late.
2. **\$16.8M in 61+ buckets is the collection target.** Above the alert threshold; collections team needs to actively work.
3. **120+ (\$3.6M) is the write-off conversation.** These are 4+ months unpaid.
4. **Overdue trend matters:** rising overdue is a leading indicator for DSO movement.
5. **Action playbook:** Collections call routine on 61-120 customers; legal / write-off review for 120+.

## Sibling cards merchants should reference together

| Card                                                                                          | Why pair it with Overdue Invoice Value |
| --------------------------------------------------------------------------------------------- | -------------------------------------- |
| [A/R Aging Detail](/nerve-centre/kpi-cards/oracle-erp/a-r-aging-detail)                       | Bucket detail.                         |
| [DSO](/nerve-centre/kpi-cards/oracle-erp/days-sales-outstanding)                              | Long-run consequence of overdue.       |
| [High-Value Overdue Invoices](/nerve-centre/kpi-cards/oracle-erp/high-value-overdue-invoices) | Per-invoice drill-down.                |
| [Cash Collected](/nerve-centre/kpi-cards/oracle-erp/cash-collected)                           | What is reducing overdue.              |

## Reconciling against the vendor's own dashboard

**Where to look in Oracle ERP Cloud:**

> **Receivables → Reports → AR Aging Report** filter past-due
> **Customer Account Inquiry → Past Due** for per-customer drill

**Why our number may legitimately differ:**

| Reason                | Direction    | Why                                           |
| --------------------- | ------------ | --------------------------------------------- |
| **As-of-date**        | Either       | Card uses today; some reports use period-end. |
| **Disputed invoices** | Configurable | Default includes; can exclude via field map.  |

**Cross-connector reconciliation:**

Oracle-internal AR metric.

## Known limitations / merchant FAQs

**Why does this differ from total open AR?**
Open AR includes current (not yet due) plus past-due. Overdue is past-due only.

**Disputed invoices, included?**
Configurable. Default: included with dispute flag visible.

**Multi-currency, FX impact?**
Each translated to reporting currency at corporate rate.

***

### Tracked live in Vortex IQ Nerve Centre

*Overdue Invoice Value* is one of hundreds of KPI pulses Vortex IQ tracks across Oracle ERP Cloud 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.