> ## 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.

# AR Aging ≥ 60+ Days, Microsoft Dynamics 365

> AR Aging ≥ 60+ Days: detailed A/R aging across 0-30, 31-60, 61-90, 91-120, 120+ buckets. 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)

> Detailed A/R aging across 0-30, 31-60, 61-90, 91-120, 120+ buckets.

## At a glance

> Per-customer AR aging detail. Each row: Customer Name, total open AR, breakdown across 0-30 / 31-60 / 61-90 / 91-120 / 120+ buckets, oldest invoice age. The collections team's daily worklist.

|                    |                                                                                   |
| ------------------ | --------------------------------------------------------------------------------- |
| **What it counts** | Open Customer Ledger Entries grouped by Customer No., bucketed by `Due Date` age. |
| **Tax treatment**  | Gross (includes VAT).                                                             |
| **Currency**       | Reporting Currency.                                                               |
| **Time window**    | `RT`                                                                              |
| **Alert trigger**  | `>25% in 90+ bucket`                                                              |
| **Sentiment key**  | `ar_aging`                                                                        |
| **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.

| Customer  | Total AR | 0-30   | 31-60  | 61-90  | 91-120 | 120+   | Oldest |
| --------- | -------- | ------ | ------ | ------ | ------ | ------ | ------ |
| Acme Tech | \$1,840K | \$620K | \$480K | \$420K | \$200K | \$120K | 145d   |
| NorthEast | \$740K   | \$480K | \$180K | \$80K  | -      | -      | 88d    |
| TechHub   | \$620K   | \$620K | -      | -      | -      | -      | 22d    |

Acme has \$320K in 90+ buckets, oldest 145 days. Collection conversation overdue.

## Sibling cards merchants should reference together

| Card                                                                                                  | Why pair                  |
| ----------------------------------------------------------------------------------------------------- | ------------------------- |
| [Invoice Aging Summary](/nerve-centre/kpi-cards/microsoft-dynamics/invoice-aging-summary)             | Headline aggregation.     |
| [DSO](/nerve-centre/kpi-cards/microsoft-dynamics/days-sales-outstanding)                              | The summary KPI.          |
| [Overdue Invoice Value](/nerve-centre/kpi-cards/microsoft-dynamics/overdue-invoice-value)             | Past-due subset.          |
| [Customer Credit Utilisation](/nerve-centre/kpi-cards/microsoft-dynamics/customer-credit-utilisation) | Credit risk per customer. |
| [High-Value Overdue Invoices](/nerve-centre/kpi-cards/microsoft-dynamics/high-value-overdue-invoices) | Alert on worst rows.      |

## Reconciling against the vendor's own dashboard

**Where to look in Business Central:**

> **Reports > Finance > Customer > Aged Accounts Receivable** (definitive)
> **Customer List > Statistics**

**Why may differ:**

| Reason                | Direction          | Why                                    |
| --------------------- | ------------------ | -------------------------------------- |
| **OData freshness**   | Card 15 min behind |                                        |
| **Bucket boundaries** | Either             | Card 30/60/90/120; BC defaults monthly |

**Cross-connector reconciliation:**

No commerce-side counterpart. AR is BC-internal.

## Known limitations / merchant FAQs

**Concentration risk?**
If 3 customers carry 60% of 90+ AR, focus collection effort there first.

**Aging by Due Date or Posting Date?**
Due Date by default; configurable.

**Privacy: customer name visibility?**
Privacy Blocked customers shown as "\[Privacy Blocked]".

**Multi-Company: same customer?**
Aggregated by Customer No. across Companies.

**Auto-export to Excel for collection calls?**
Yes, CSV export by default.

***

### Tracked live in Vortex IQ Nerve Centre

*A/R Aging Detail* 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.