Skip to Content
0
Former Member
Apr 17, 2008 at 10:25 PM

Procure to Pay Report

621 Views

Is there a standard R/3 report that lists purchases in the last one year? It needs information from Purchasing and AP.

The information I need is Vendor#, Name, PO No, Item, Po Date, Material Group/No/Description, GL Account, WBSE, Company Code, PO Qty, Amount, Currency, GR status, IR status, Invoice No, Invoice Date, Invoice Qty, Invoice Amount, Payment Date, Payment Amount etc.

Of course it must filter out deleted lines and there may be PO’s with no invoices or invoices with no payments etc.

Is there a standard report or any other easy way to get it (apart from table joins) or am I asking too much? I wouldl ike to then export it to Excel for further analysis?

Thanks in advance

Jayshree