Byd - Report - PO utilization

[jeroenpar]

Hi All,

I have the following quest. I need a report where I can see the PO with the amounts purchased per item and I would like to see the invoiced amount on the PO. This gives me insight into the utilization of the PO.

Therefore I created a report on data source “Purchase Order Items with Extended Tracking Details” (SRMPO_U01). See screenshot below.

This works fine, till there are two invoices (document ID) booked on 1 PO Item. In this case I get an additional value limit.

Please see screenshot below for this example. PO Item 1 is an PO of 380 euro. Though, because we booked two invoices on this PO Item I get two times 380 euro. So this gives a wrong amount of value ordered and I can not calculate the total utilization of this PO.

Same occurs on PO Item 8 with 57 euro.

Is there a way how I can avoid this additional values in the report?

Is there another way to see the utilization of PO's?

Thank you so much!

KR,

Jeroen