Skip to main content

Notifications

Finance | Project Operations, Human Resources, ...
Suggested answer

Net balances on ledger/dimension statement report

(0) ShareShare
ReportReport
Posted on by
Hello, 

I would like some feedback as to how you would have handled following request.

I have a dimension statement with primary dimension Project, and secondary dimension Main account as per the image below. In it the three columns Debit, Credit, and Accumulated are showing, as per usual. I have a request to be able to see this information but to also to include another column for Net balance on a Project+Main account (this column would be the same as the difference in Debit - Credit columns). The user wants acces to this information in the system, not having to export to excel and manuallu create a new column, add the formula etc.

How would you approach this? Make changes to the dimension statement report (would that be modifying the report or are there perhaps report options to help with a simple request like this)? Create a financial report for this purpose? Still refer to excel but use a Power query? 

Seems like an easy request but I'm not sure what should be the approach here, and if it is worth commiting to.

Any feedback is greatly appreciated.

Kind regards,
O

  • Suggested answer
    Kevin Xia Profile Picture
    Kevin Xia Microsoft Employee on at
    Net balances on ledger/dimension statement report
    Hi,

    You have a few options to consider:

    1. Modify the dimension statement report: You can make changes to the existing report by adding a new column for the Net balance calculation. This would involve modifying the report's design and adding the necessary formula or expression to calculate the difference between the Debit and Credit columns.

    2. Create a financial report: Another approach is to create a new financial report specifically for this purpose. This report can be designed to include the desired columns, including the Net balance column, without affecting the existing dimension statement report.

    3. Utilize Power Query in Excel: If exporting to Excel is still an option, you can use Power Query to automate the process of creating the Net balance column. Power Query provides a range of data transformation and manipulation capabilities that can help you perform calculations and add new columns based on existing data.

    Best regards,
    Kevin

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

Announcing Our 2025 Season 1 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Vahid Ghafarpour – Community Spotlight

We are excited to recognize Vahid Ghafarpour as our February 2025 Community…

Congratulations to the January Top 10 leaders!

Check out the January community rock stars...

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 292,160 Super User 2025 Season 1

#2
Martin Dráb Profile Picture

Martin Dráb 230,962 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Product updates

Dynamics 365 release plans