Skip to main content
DD-PRC-003 Mizan Group: From Requisition to Payment, and the Fuel Cards — Procurement & Spend Get the data →
DD-PRC-003-Q043 Very Hard Time series

Goods received not invoiced on 31 December 2025

GRNI: for each goods PO line, (quantity accepted by 31 December 2025 23:59 - quantity on invoices posted by 31 December 2025 matched to that line), not below zero, x POUnitPrice. What is the group GRNI accrual at 31 December 2025, in USD?
Expected
One amount in USD, 2 decimals · KPI card
Tables
FactPOLine, FactGRN, FactInvoiceLine, DimItem · columns
  • FactPOLine
  • FactGRN
  • FactInvoiceLine
  • DimItem
  • ReceivedOn
  • ReceivedQty
  • RejectedQty
  • PostingDate
  • InvoiceQty
  • POLineID
  • POUnitPrice

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

Create a free account Sign in