Hi experts out there,

hope that everybody is fine, healthy and stay at home? :-)

Again we are developing a BI solution for a german customer.
These weeks we’ve done a POC (proof of concept) with Purchase Data.
No problem to create a FACT_Purchase_Order_Lines(POLs) conected to the 3 different (aggregated) RECEIPT tables. We build the STAR Schema and now we see all the POLs with detailled information from Supplier and Purchasepart.

Now we want to see - say PO 1000, Pos 1, Part A, orderd for QTY 100, Amount 1000€ -
what kind of Supplierinvoices are there on the “incoming” side.

It is no problem to create a standalone FACT_Purchase_Invoice_Lines based on INVOICE_TAB (PARTY_TYPE = ‘SUPPLIER’) and INVOICE_ITEM_TAB.

In the manual supllier invoice are some interesting fields, we checked out in the INVOICE_ITEM_TAB

PARTY_TYPE
PO_LINE_NUMBER
PO_REF_NUMBER    Alias PO Ref:
PO_RELEASE_NUMBER

and see the purchase order number in PO Ref.

What we miss:
The 1:1 granularity from PurchaseInvoiceLine (PIL) to POL.
The testdata on customer site do not have one INVOICE_ITEM_TAB record with a PO_LINE_NUMBER.

So, do you think there is a change to see:

POL Info  + SupplierInvoiceInfo say invoicedqty and invoidedamount in one line?

All the best to you all.

Michael