How to Quickly View Chart of Accounts Balances by Dimension as of a Specific Date (in Dynamics 365 Business Central)

Dynamics 365 Business Central

Even out of the box, Microsoft Dynamics 365 Business Central is intuitive and easy to use. Setting up and keeping an eye on your chart of accounts has never been easier. But it gets better: you can customize the way the chart of accounts is displayed using dimensions and filters.

From the chart of accounts list, you can easily view the net change and current balance for a specific GL account, as seen below.

Account Balances by Dimensions in Dynamics 365 BC

But it’s also helpful to be able to see the balance in different ways, like as of a certain date or by a dimension value.

How to Change the View of the COA

First, select your Settings wheel, and click on Personalize to personalize the chart of accounts list page:

Account Balances by Dimensions in Dynamics 365 BC

Choose the + field:

Account Balances by Dimensions in Dynamics 365 BC

Select the “Balance at Date” field and drag it onto the list, click Done.

Account Balances by Dimensions in Dynamics 365 BC

Click the filter option:

Account Balances by Dimensions in Dynamics 365 BC

In the “Filter totals by:” section, choose Date Filter and set your dimension field (in this case the dimension is Department, which we pulled over earlier).

Account Balances by Dimensions in Dynamics 365 BC

As I change my Department filter, I can quickly view the chart of accounts balances as of 12/31/20 for that department.

Account Balances by Dimensions in Dynamics 365 BC

I can even quickly see the net income for that department and specific date.

Account Balances by Dimensions in Dynamics 365 BC

Click the save icon to save this as a custom filter so it can quickly be used in the future!

Account Balances by Dimensions in Dynamics 365 BC

Account Balances by Dimensions in Dynamics 365 BC

And there it is! Business Central makes it easy to customize your workflows exactly how you need them. Subscribe to our blog for more tips like this!

Leave a Reply