cancel
Showing results for 
Search instead for 
Did you mean: 

How to extract Spend Summary of all vendors?

0 Kudos

Please tell me how to extract Spend summary ($ total invoiced) by vendor for the period 1st October 2016 until 24th Aug 2018.

Required:
Vendor Number
Vendor Name
Vendor ABN
Total $ invoiced

Accepted Solutions (0)

Answers (1)

Answers (1)

daniel_marlen
Active Participant
0 Kudos

Dear Sawan,

There aren't any standard reports to achieve this requirement, but you can write a custom report using FM BBP_PD_INV_GETLIST. Even it is a not released function module, I would suggest to test, if it can fulfill your requirement. You can populate the export parameters with the desired time frame and this FM will gather all Invoices and the corresponding vendor in importing table E_PDLIST. Then you can calculate the Invoice values for each Supplier in a LOOP.

Best regards,

Daniel