11 Jul’19

UncategorizedHow to Create Balance Sheet and View Reports with Dimensions in D365 Business Central

In D365 Business Central there is no pre-defined Balance sheet/Income statement, because all these accounting statements can be viewed using Account Schedules.

So, in this blog let’s see how we can create new Balance Sheet and how can we check the reports of Balance Sheet.

1.       Search for “Account Schedules”

2. Now, go to Balance sheet line, then select “Process” function and then select “Edit Account Schedule”

3. By selecting “Edit Account Schedule” this will open the following page

4. Now, select “Insert” function and then select the “Insert G/L Accounts”.

5. By selecting “Insert G/L accounts” function the following page will open.

6. Now, right click the three dot options as shown and then select the “select more” option.

7. Now, select all the Assets, Liabilities and Equity accounts to create a new balance sheet.

8. When you click “OK” all the accounts will get added to the accounts schedules as shown below in the picture.

9. Now, use the G/L accounts specified in the account schedules to post transactions. Later, when you want to create a report of the G/L accounts used in the balance sheet we can do so with the following steps.

10. Click on “Report” functions and choose the option to “Print” as shown below.

11. The following page will open, where you have options as follows:

a.       Send to

b.       Print

c.       Preview

12. The report is generated as shown below:

13.  In the reports we can check the transactions with the dimensions assigned to the respective G/L accounts. Once, we choose the option to view the reports, we get options to select the dimensions and view the balance sheet report. In the picture below, we have one dimension as “Trader” and “Dan” is the assigned dimension value. Now, click on preview.

14. Below is the picture with the dimensions as displayed on the 2 G/L accounts. The values on the G/L accounts as seen in the picture are only for the dimension entries. Which means, the transactions with dimensions, are only viewed in the report.

Written by

Aditya Prabhu

Functional Consultant


Leave a Reply

Your email address will not be published. Required fields are marked *

Want to streamline your business processes?

  • This field is for validation purposes and should be left unchanged.

Recent Articles

  • Expenses in PSA for Fixed Bid and T&M contracts

    23 August’ 2019

    Problem Definition: One of my clients decided to use Expense module in PSA and to his surprise he could see the amount v...

    Read more
  • Setup Dockers

    23 August’ 2019

    Docker is an independent container platform that enables organizations to seamlessly build, share and run any applicatio...

    Read more
  • Qualify Lead in D365 CE: Select which entity records should be created

    20 August’ 2019

    Wave 2019 Updates brought some really sought-after features. Another one which I would like to bring up is the Lead Qual...

    Read more
  • Early Opt-in for October 2019 Wave 2 Updates

    20 August’ 2019

    August 2, 2019 was when the Wave 2 Updates were to be out. And here we are! By now, you should have gotten the option to...

    Read more
  • Setting Unified Interface App Icons

    20 August’ 2019

    Default App Icons for typical D365 environment look like these.But here’s what you can do to change these to put...

    Read more
  • We respect your privacy.
  • This field is for validation purposes and should be left unchanged.