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-Q004 Easy Time series

What the group is owed today

Append FactARLedgerLatest to FactARLedger first. Owed at a date = the sum of Amount (invoices positive, receipts negative) of the ledger rows with DocumentDate on or before it. What did customers owe the two companies together on 30 September 2026, in USD?
Expected
One amount in USD, 2 decimals · KPI card
Tables
FactARLedger, FactARLedgerLatest · columns
  • FactARLedger
  • FactARLedgerLatest
  • DocType
  • Amount
  • DocumentDate
  • EntityCode

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