Manufacturing's fastest paying month
A document is open at a date when its PostingDate is on or before that date and its SettledDate is empty or later than that date. Receivables = open "Customer invoice" and "Card takings" documents; payables = open "Supplier invoice" documents; stock = ClosingValue in FactStockMonthEnd at that month-end. DSO = receivables / Revenue of the three calendar months ending that month (FactMonthlyPL) x the days in those months; DIO = stock / CostOfSales of the same months x days; DPO = payables / SupplierInvoices of the same months x days; CCC = DSO + DIO - DPO. Across all month-ends from January 2024 to September 2026, at which month-end was Mizan Manufacturing's DPO lowest? Give it as yyyymm.
- Expected
- One month as yyyymm · KPI card
- Tables
-
FactWCDocument, FactMonthlyPL · columns