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 POs 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