Forecast receipts
The forecast made on 1 January 2026: forecast week k = days 7(k-1) to 7k-1 counted from 1 January (DimDate ForecastWeek), 13 weeks. Receipts: each customer invoice open at the close of 31 December is expected on DueDate + that customer's delay = the average of (SettledDate - DueDate) in days over its customer invoices settled in the previous calendar year, rounded to whole days (half away from zero), 0 if it has none; anything expected on or before 31 December counts in week 1. Payments: each supplier invoice open at the close of 31 December is paid on the first Monday on or after its DueDate, earlier ones in week 1. Plus the FactCashCalendar rows dated in the 13 weeks. What total customer receipts does the forecast expect in the 13 weeks, in USD?
- Expected
- One amount in USD, 2 decimals · KPI card
- Tables
-
FactInvoices, DimDate · columns