Hello,

I am trying to come up with a report that shows a comparison of purchase order line item quantity/ amount, the quantity received/ amount to date and financial invoiced quantity/ amount to date.

I am unable to find table that is related to all these three quantities.

Any ideas? Thank you.

Regards,

wp :(

I don't think there is a standard report with all of that detail. Print Variance Analysis (tfacp1460m000) may be the closest but that will only include PO lines that have had receipts and doesn't include the PO line qty.

I also don't think there is one table that has all of that detail but you can see it in the PO Lines session (tdpur4100m900) by viewing the information in the Order Lines, Receipts and Payables Receipts tabs, so it should be possible to build a report that consolidates the quantities and amounts from the tables as used in tdpur4100m900. Check to see if you can build your report from the following tables:

tdpur401 (Purchase Order Lines)
tdpur406 (Purchase Actual Receipts)
tdpur430 (Purchase Payable Receipts for Orders and Schedules)

If you need any detail from the PO header to tidy up the report, add tdpur400 to the list.


Alternately, you may be able to use the history tables:

tdpur451 (Purchase Order Lines History)
tdpur456 (Purchase Actual Receipts History)
tdpur460 (Purchase Payables Receipts History)



Scott

Dear Scott,

Thanks for the info.

We will try uisng the tables mentioned to build the report.

Regards,

WP