Finance | Project Operations, Human Resources, ...

Data Export/Report of information of Supplier and Vendor

(3) Share

Report

Posted on by AX Fanatic

Hi Community, is it possible for me to get an export or report of payments of Supplier and Vendor per Legal Entity in each month? If yes, how?

Also an export or report of NEW Supplier and NEW Vendor per Legal Entity in each month - just want to know who are being onboarded and how many are being onboarded in each month and wanted to track..

I tried to explore in D365 but i cannot find any useful functions to get this report

Would really appreciate your insights!

Categories:

Dynamics 365 Finance

I have the same question (0)

All responses (4)

Answers (0)

Suggested answer

Syed Amir Ali 205 on at

Like (2)

Report
Copy link

Link copied!
Hey,

Yes, you requirement is not available out-of-the-box as a single report. You will need to either:

Use built-in reports and inquiries in combination with Excel exports and/or

Create a custom SSRS report, Power BI report, or Electronic Reporting (ER) format

I would suggest you to create a new report for you.

Was this reply helpful? Yes No
Suggested answer

Yng Lih 1,612 Super User 2026 Season 1 on at

Like (4)

Report
Copy link

Link copied!

Hi,

You can consider using General Ledger > Enquiries and Reports > Voucher Transaction with the following filter:

Transaction Type: Payment and Posting Type: "Customer Balance, Vendor Balance".

Personalize to add in "Created date/ time" to customer/ vendor grid and filter for the month:

If this information was helpful, kindly mark it as 'Verified'. Thank you. :)

Was this reply helpful? Yes No
Suggested answer

Ramit Paul 22,803 Most Valuable Professional on at

Like (1)

Report
Copy link

Link copied!

Hi,

I think you have a requirement of two reports,

1. New vendor per LE per month, this is not available striaght way, however you can check the vendor master form and see the "Created time" this will give you the data of how many vendors were created and which month.

2. Supplier payments per month, I think the workaround shared by Yng Lih will work and also this can be done by BPA framework.

I hope this helps.

Was this reply helpful? Yes No
Suggested answer

Alireza Eshaghzadeh 14,839 Super User 2026 Season 1 on at

Like (3)

Report
Copy link

Link copied!

Hi,
The reports you're looking for are not directly available in D365FO. However, you can retrieve this data by leveraging existing reports and applying appropriate filters — for example:
Vendor posted payment journal filtered by Legal Entity and Payment Date (grouped by month).
Vendor master data reports via Excel add-in filtered by Creation Date, to identify newly onboarded vendors per month.

For a more automated and scalable approach, I recommend building a custom reporting solution — for instance, using Power BI connected to the D365 data entities and tables such as:
VendTrans (need custom entity), VendTable (Vendors V2), and Vendor payment journal line for payment history.
Vendors V2 with filtering on the CreatedDateTime field for onboarding tracking.

This way, you can create dashboards that show monthly trends per legal entity, including total payments and number of new suppliers.
Let me know if you'd like help identifying the right entities or building a data model for Power BI.

Was this reply helpful? Yes No