You are viewing an old version of this page. View the current version.

Compare with Current View Page History

« Previous Version 15 Next »

User can use Financial Reports to create Balance Sheet and Profit & Loss Statement that fit their use.

To create new Financial Report
1

Search "Financial Report", then click "New" to create a new one.



2

Enter the report name, description, row definition & column definiation.


User can edit the row definition and column definition for each report name.

For default Column Layout, user can use system's sample layout. Choose M-BALANCE for Balance Sheet and choose M-NETCHANGE for Profit & Loss Statement.

3Choose Edit the financial report.

4To edit the row definition, chick Insert >  Insert G/L Accounts 

5

Select the G/L Accounts to be inserted, then click OK.

For example, Balance Sheet only includes Balance Sheet G/L Accounts. 

6

For Balance Sheet, user will need to add a row to include current year's Profit & Loss figures.

For Totaling Type column, choose Posting Accounts. 

Under Totaling column, input Profit & Loss G/L Accounts.

7

For Totaling Type most commonly use are:

  • Posting Accounts gets data from posting accounts on G/L Account List.

  • Total Accounts gets data from G/L Accounts that are Total or End-Total.

  • Formula allows you to calculate use the column "Row No." (e.g. row 3130+3120).


To run Account Schedule, highlight the report user want to run, then click "View Financial Report"

Input related Date Filter and the results will show at the bottom. E.g. Income Statement

Column Definition Formula:

Reference: Column definitions in Financial Reporting - Business Central | Microsoft Learn

  • No labels