The worst month-end for overdue debt
An invoice is due on InvoiceDate + the customer's PaymentTermsDays. At a date, an invoice is open if it has no receipt dated on or before that date, and overdue if it is open and its due date is before that date. For every month-end from January 2024 to September 2026, work out the share of the amount owed that was overdue. Which month-end had the highest share? Give it as yyyymm.
- Expected
- One month as yyyymm · Line chart of overdue share by month-end
- Tables
-
FactInvoices, FactReceipts, DimCustomer, DimDate · columns