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

End to end by channel

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". For invoices with a PostingDate in 2025 that were paid, compare the median days from received to paid (hours / 24) of "Paper" with "EDI" invoices. What is Paper's median minus EDI's median, in days? 2 decimals (negative = Paper faster).
Expected
Days, 2 decimals · KPI card
Tables
FactInvoiceEvent, FactInvoice · columns
  • FactInvoiceEvent
  • FactInvoice
  • InvoiceID
  • Activity
  • EventTimestamp
  • UserID
  • Detail

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