How-To’s of Financial Reports in Business Central

Posted on: December 13, 2023 | By: Page Wildridge | Microsoft Dynamics Business Central

Microsoft Dynamics Business Central, a popular cloud-based ERP solution for small to mid sized businesses, comes equipped with a strong financial reporting system. You can utilize financial reporting tools to understand more about your data and your business. In this blog, we will discuss various tools within financial reports in Business Central.  

How to Create a Brand New Financial Report 

Business Central stores several templates for your financial reports that are quick and easy to use. However, if none of the premade templates fit your business’s needs, you can always create your own. To do so, navigate to the Financial Reports page, and choose either “New” or “Copy Financial Report” to reuse settings from a past report. After, fill in the fields as needed while also choosing an existing definition for the “Column Definition” field. Next, choose the Edit Row Definition Action, along with Insert G/L and CF Accounts, and Insert Cost Types actions. You can view the financial report by selecting “edit financial report” on the “financial reports” page. 

Edit a Column Definition

You can specify your column definitions to ensure you can compare and contrast your desired fields for your financial report. To do so, select different types of column definitions under the “Column Definition Field,” and check what you have changed by opening the “Financial Report” page. 

How to Create a Column That Calculates Percentages

If you would prefer to have a column in your financial report that displays percentages of a total, follow these steps. Start by opening your desired financial report. After, select the “edit financial report”, and insert a line above the row you want to display a percentage. In the Totaling Type field, select Set Base for Percent. Then, in the Totaling field, enter the formula for the total percentages to be based on. This means that you should enter the row number that contains the total sales. Next, choose “Edit Column Definition”. In the “Column Type” field, select “formula,” and enter the formula for the amount you want to calculate the percentage off of, along with the % sign. This means that if Column Z contains the net change, enter Z%. Repeat this process as necessary for the rows you want to contain percentages. 

To learn more about setting up various tools in Business Central, click here

Next Steps 

Understanding your ERP is key to harnessing its power. At Logan Consulting, we are committed to ensuring our clients get the most out of their ERP. Contact us today to speak to an expert. 

2020 Nucleus Research Report on ERP Technology

Free Download:

2020 Nucleus Research Report on ERP Technology

Download the guide ›