Skip to main content
DD-APY-003 Mizan Group: The Life of a Supplier Invoice — Accounts Payable & Payments Get the data →
DD-APY-003-Q039 Hard Time series

The worst month-end backlog

An invoice's received time is the EventTimestamp of its "Received" event, its posted time that of "Posted", and its paid time that of "Paid" or "Manual payment". At which month-end of 2025 was the Amount received on or before the month-end but posted (PostingDate) after it the largest? Give it as yyyymm.
Expected
One month as yyyymm · KPI card
Tables
FactInvoiceEvent, FactInvoice · columns
  • FactInvoiceEvent
  • FactInvoice
  • InvoiceID
  • Activity
  • EventTimestamp
  • UserID
  • PostingDate
  • Amount

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