web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Finance | Project Operations, Human Resources, ...
Suggested Answer

Vendors Transaction Aggregate report -- All Suppliers

(1) ShareShare
ReportReport
Posted on by

Hello 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.

I have the same question (0)
  • Suggested answer
    Frank Hamelly | MVP, MCP, CSA Profile Picture
    46,625 Moderator on at
    Have you looked at the Purchase Spend Analysis Power BI in Procurement?
     

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Stars!

Congratulations to our 2025 Community Spotlights

Thanks to all of our 2025 Community Spotlight stars!

Leaderboard > Finance | Project Operations, Human Resources, AX, GP, SL

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 590 Super User 2026 Season 1

#2
Giorgio Bonacorsi Profile Picture

Giorgio Bonacorsi 349

#3
Diego Mancassola Profile Picture

Diego Mancassola 263

Last 30 days Overall leaderboard

Product updates

Dynamics 365 release plans