Dynamics Community Forum Thread Details

Net balances on ledger/dimension statement report

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

Hi,

You have a few options to consider:

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

Quick Links