Skip to main content
DD-PRC-001 Mizan Manufacturing: Orders, Deliveries and Invoices — Procurement & Spend Get the data →
DD-PRC-001-Q021 Medium

Spend without a purchase order, 2025

Items with PORequired = "Y" should always be bought on a purchase order. What was the 2025 spend on invoice lines for such items that have no POLineID, in USD?
Expected
One amount in USD, 2 decimals · KPI card
Tables
FactInvoiceLine, DimItem · columns
  • FactInvoiceLine
  • DimItem
  • POLineID
  • PORequired
  • LineAmount
  • InvoiceDate

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