Share
ReportHello All, Microsoft Dynamics 365 Operation and Finance - Vendor Transactions - I am looking for away to extract a list with the summation of all transactions made to the vendor(s) between two dates. Payment History is nice but this did not a wholistic / extractable excel list for all vendors, something like would be helpful,
|Vendor name| |Vendor Account | Summation of Transactions | Date|
| Vendor A| |XXXX-XXXX1| |$$$$$$$$$$| |Nov 1 - Jan 31|
|Vendor B| |XXXX-XXXX2| |$$$$$$$$$$| |Nov 1 - Jan 31|
| Vendor C| |XXXX-XXXX3| |$$$$$$$$$$| |Nov 1 - Jan 31 |
The goal from the report to have excel list will all supplier and the summation of all the transactions happened for each one of those suppliers (rows) between two dates. To know how much was the aggregate spent with this supplier per quarter. It is also helpful if i can add the cost center to aggregate spent per department who was the suppliers.
Thanks, Mahmoud Al Robiai - Operations Manager - HP Inc.
All responses (
Answers (
46,226
