Skip to main content
DD-ARC-002 Two Companies, Lump Payments and Cash Nobody Can Place — Accounts Receivable & Collections Get the data →
DD-ARC-002-Q018 Medium Time series

Overdue today

Append FactARLedgerLatest to FactARLedger first. An invoice is open at a date if no receipt row with that InvoiceNumber is dated on or before it, and overdue if it is open and its DueDate is before the date. What share of the group's amount owed on 30 September 2026 was overdue? 2 decimals.
Expected
One percentage, 2 decimals · KPI card
Tables
FactARLedger, FactARLedgerLatest · columns
  • FactARLedger
  • FactARLedgerLatest
  • DocType
  • Amount
  • DocumentDate
  • EntityCode
  • InvoiceNumber
  • DueDate

Discussion

No one has posted here yet. Ask something, compare your result, or share how you solved it.

A free account takes a minute. Your draft is kept while you sign in. Need help? Message us

Create a free account Sign in