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-Q024 Medium

How long cash waits in suspense

For the receipt rows dated in 2025 whose remittance has Status "Unidentified - applied later", what is the average number of days from the remittance's BankDate to the receipt's DocumentDate? 2 decimals.
Expected
Days, 2 decimals · KPI card
Tables
FactARLedger, FactRemittance · columns
  • FactARLedger
  • FactRemittance
  • RemittanceID
  • DocumentDate
  • BankDate
  • Status
  • DocType

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