Finance powerbi App - GL Account Hierarchy

[GCapron1]

I have configured the finance report app but the G/Account  Hierarchy in the app is pulling the beginning totals Name of the COA instead of the End Totals. is there a way to change this?

[GCapron1]

Im using the Finance Powerbi App for Business central so im limited with option ie. accessing the data & Relationships. i would have like for it to look like this,  showing the end total account number and name, instead its showing the begin total account number & name. 

[v-saisrao-msft]

Hi @GCapron1,

We haven’t heard back from you regarding your issue. If it has been resolved, please mark the helpful response as the solution and give a ‘Kudos’ to assist others. If you still need support, let us know.

Thank you.

[v-saisrao-msft]

Hi @GCapron1,

May I ask if you have resolved this issue? If so, please mark the helpful reply and accept it as the solution. This will be helpful for other community members who have similar problems to solve it faster.

Thank you.

[v-saisrao-msft]

Hi @GCapron1,

I wanted to check if you had the opportunity to review the information provided. Please feel free to contact us if you have any further questions. If my response has addressed your query, please accept it as a solution and give a 'Kudos' so other members can easily find it.

Thank you.

[v-saisrao-msft · Accepted solution]

Hi @GCapron1,

Thank you for your response. I understand that you are using the Finance Power BI App for Business Central and that the G/L Account Hierarchy is showing Beginning Total accounts instead of the expected End Total accounts. Given that this is a pre-configured app, customization options are limited. However, here are some steps you can try to resolve the issue: 

• Please navigate to the G/L Account Hierarchy visual. Expand the hierarchy levels and verify if drilling down enables the display of End-Totals instead of Begin-Totals. If feasible, adjust the hierarchy view to emphasize summary totals. 
• Please review the Chart of Accounts (COA) setup. Ensure that the End-Totals are accurately structured and appropriately linked in the hierarchy. If modifications are permitted, adjust the COA setup to correctly display End-Totals in the reports. 
• If the issue continues and app changes aren't feasible, your organization might need to create a custom Power BI report with Business Central data to ensure correct End-Totals display. 
• In Power BI, please open the Filters Pane and check for an Account Type filter. If available, filter the data to display only End-Total accounts instead of Begin-Total. Apply the filter and verify whether the hierarchy updates as expected.  

If this post helps, then please give us ‘Kudos’ and consider Accept it as a solution to help the other members find it more quickly.

Thank you. 

[v-saisrao-msft]

Hi @GCapron1,

Thank you for contacting the Microsoft Fabric Community.

I understand that your Finance report shows the beginning total names in the G/L Account Hierarchy rather than the end totals from the Chart of Accounts (COA). Follow the steps to troubleshoot and resolve this issue: 

• Please ensure that your fact table is correctly linked to the dimension table. In Model View, verify that the relationship is set to one-to-many. 
• If your totals are calculated using a DAX measure, please ensure it aggregates end-of-period balances rather than summing from the start. 
• Please ensure that your report filters, such as fiscal year, quarter, or month-end, are correctly applied. If you notice any issues with the hierarchy filtering, verify whether an unintended slicer or filter might be affecting your totals. 
• In the Hierarchy Table or Matrix Visual, please ensure the correct measure is selected and that totals are displayed correctly. Review both the subtotal and grand total settings for accuracy. 

If this post helps, then please give us ‘Kudos’ and consider Accept it as a solution to help the other members find it more quickly.     

Thank you. 

[GilbertQ]

Hi @GCapron1 

Could you please give an example of what you are looking as the end result?