Looking for a Report in F&O for Vendor Account Closing Balances with Financial Dimensions

(1) Share

Report

Posted on by Olafsonn

Hello everyone,

I’m currently working on a project where we’re manually transferring closing balances as of the end of last year in Dynamics 365. We’re encountering an issue when trying to obtain a single report that includes the Vendor Account number, Business Unit, Project, Service type, and the respective vendor’s closing balance amount.

We’ve tried using the Trial Balance, but it doesn’t seem to provide the vendor account number.

Could anyone advise which report we should use to get the closing balances of individual vendor accounts as per the financial dimensions? Any guidance would be greatly appreciated.

Thank you very much for the support!

I have the same question (0)

All responses (3)

Answers (1)

Sort by

BillurSamdancioglu 21,395 Most Valuable Professional on at

Like (1)

Report
Copy link

Link copied!

Hi,

There is no OOB report for to provide all these information.

Was this reply helpful? Yes No
Olafsonn 36 on at

Like (0)

Report
Copy link

Link copied!

Hi Billur,

Thanks a lot for the answer.

You mentioned that development would be required to solve this issue (OOB is not sufficient). Could you please provide some guidance on how and where to start this development process? Are there any specific areas in F&O that we should focus on or any resources you would recommend for this task? What kind of report is on your mind?

Thank you!

Was this reply helpful? Yes No
Verified answer

André Arnaud de Cal... 306,815 Super User 2026 Season 2 on at

Like (1)

Report
Copy link

Link copied!

Hi Olafson,

Like mentioned, there is no standard report for your requirement. You can go for a custom report option by developing a report using the Visual Studio development tools or Power BI. Which technology to use will depend on performance requirements, preferences, and available skills. A Dynamics 365 F&O developer will be able to help you or you would need to have a Poweer BI expert.

Was this reply helpful? Yes No