Skip to main content
DD-APY-001 Mizan Retail: Who We Owe and When We Pay — Accounts Payable & Payments Get the data →
DD-APY-001-Q019 Medium Time series

Overdue at the end of 2025

An invoice is due on InvoiceDate + the supplier's PaymentTermsDays. At a date, an invoice is unpaid if no payment with its LedgerJournalID is dated on or before that date, and overdue if it is unpaid and its due date is before that date. What was overdue to suppliers on 31 December 2025, in USD?
Expected
One amount in USD, 2 decimals · KPI card
Tables
FactSupplierInvoices, FactPayments, DimSupplier · columns
  • FactSupplierInvoices
  • FactPayments
  • DimSupplier
  • Amount
  • InvoiceDate
  • PaymentTermsDays
  • LedgerJournalID
  • PaymentDate

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