Create a trial balance by account schedule on Microsoft Dynamics Nav Business Central

Hello Friends,

Today we will learn how to create a trial balance on account schedule. This tool permits us to create our customized report.

Step 1:

To create an account schedule, go on the following menu:

Main Menu --> Department --> Financial Management --> General Ledger --> Account Schedule.

Step 2:

Click on the button New and fill the following information.

Name	Enter a name for the account schedule
Description	Enter a description for the account schedule
Default Column	Need to create columns
Analysis View Name	If you want to associate a analysis view with the account schedule

Step 3:

To add a column click on the drop down of the field Default Column

The following page will open.

fill the following information:

Name	Enter a name
Description	Enter a description
Analysis View Name	If there is analysis view that need to be linked

Step 4:

Click on Edit Column Layout setup and fill the following information.

Column No	Add a column no
Column Header	Enter the name of the column header
Column Type	Enter type of the column
Ledger Entry Type	Enter entries in ledger entry type
Amount Type	Enter the type of the amount
Formula	Enter formula if any
Show opposite sign	If you want to show opposite sign in amount
Comparison date formula	Let it blank
Show	Enter always if you want the field to be display
Rounding Factor	Enter the rounding factor

Click on OK

Step 5:

To test the account schedule go on the main page and click on overview.

After clicking on overview, the report will appear.