How to extract Spend Summary of all vendors?

[Former Member]

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

[daniel_marlen]

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