PO Vs Non PO Invoice

Hi Sudip,

This should be fairly simple as long as you have a business logic defined.

For example, if your criterion to identify non PO invoices are invoices where the Purchase Order Number is empty and the PO invoices are the ones the field are populated, you could achieve it doing the following:

Formulae for counting Non PO Invoices:

SUM(

CASE WHEN INVOICETABLE.PurchaseOrderNumber IS NULL THEN

THEN 1.0 ELSE 0.0 END)

Formulae for counting PO Invoices:

SUM(

CASE WHEN INVOICETABLE.PurchaseOrderNumber IS NOT NULL THEN

THEN 1.0 ELSE 0.0 END)

For SAP Source Systems many customers use BKPF.AWTYP = 'RMRP' as an indicator if an invoice was with a PO or not. Maybe this helps in case you are not able to identify an indicator.

Best,

Kevin