Skip to main content
DD-WCP-003-Q031 Hard

Count-back DSO

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. Count-back DSO: take Mizan Manufacturing's open "Customer invoice" Amount at 31 December 2025; subtract each month's "Customer invoice" Amount (by DocumentDate) going back from December, counting all the days of each month fully used and, for the month only partly used, its days x the share used. What is the count-back DSO? 2 decimals.
Expected
Days, 2 decimals · KPI card
Tables
FactWCDocument · columns
  • FactWCDocument
  • DocumentType
  • EntityCode
  • Amount
  • DocumentDate
  • PostingDate
  • SettledDate

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