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

Supplier finance at the year-end

Programme invoices = Mizan Retail "Supplier invoice" documents of the suppliers with a SupplierFinanceFrom date in DimCounterparty, posted on or after that date. 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. What is the Amount of open programme invoices at 31 December 2025, in USD (the carrying amount to disclose)?
Expected
One amount in USD, 2 decimals · KPI card
Tables
FactWCDocument, DimCounterparty · columns
  • FactWCDocument
  • DimCounterparty
  • DocumentType
  • EntityCode
  • CounterpartyCode
  • SupplierFinanceFrom
  • Amount
  • 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