Run General Ledger Entries on Microsoft Dynamics Nav Business Central

Dear Friends,

Today we will learn about general ledger entries. The general ledger entries display transactions done and if a G/L Account is involved, the transaction will be recorded in the general ledger entries.

To access General Ledger Entry go on the following menu:

Main Menu --> Department --> Financial Management --> General Ledger --> General Ledger Entries.

Run Standard Detail Trial Balance and Trial Balance on Microsoft Dynamics Nav Business Central

Hello viewers,

Accounting people always use the trial balance and detail trail balance to check their G/L account transaction. Today we will learn how to run the report.

Go on the following menu:

Main Menu --> Department --> Financial Management --> General Ledger

1. Detail Trail  Balance

You can filter the report by the following field.

No.	You can run the trial balance by G/L number
Search Name	You can run the trial balance by search name
Income/Balance	You can run the trial balance by income statement or balance sheet
Debit/Credit	You can run the trial balance by Debit or Credit Account
Date Filter	You can run the trial balance by date filer

2. Trail Balance

Enter the filter to run the report.

No	You can run the report by G/L Account No
Account Type	You can run the report by Account Type
Date Filter	You can run the report by Date Filter

Creation of Fixed Asset Posting Group on Microsoft Dynamics Nav Business Central

Dear Friends,

Today we will learn how to setup FA posting group. This setup is very important for acquisition and depreciation of fixed asset.

Step 1:

To proceed with the setup go on the following menu:

Main Menu --> Department --> Financial Management --> Setup --> FA Posting Group.

Step 2:

Click on the button New and Fill the following information

Code	Enter a code for the posting group
Acquisition Cost Account	Enter the Acquisition G/L Account
Accum. Depreciation Account	Enter the Accumulated Deprecation G/L Account
Write-Down Account	Enter the write down G/L Account
Appreciation Account	Enter the Appreciation G/L Account
Custom 1 Account
Custom 2 Account
Maintenance Expense Account
Acq. Cost Acc. on Disposal	Enter the acquisition cost G/L Account on disposal
Accm. Depr. Acc. on Disposal	Enter the depreciation G/L Account on disposal
Write-Down Acc. on Disposal	Enter the write down G/L Account on disposal
Appreciation Acc. on  Disposal	Enter the appreciation G/L Account on disposal
Custom 1 Account on Disposal
Custom 2 Account on Disposal
Gains Acc. on Disposal	Enter the gain G/L Account on disposal
losses Acc. on Disposal	Enter the losses G/L Account on disposal

Step 3:

Enter the Balancing account.

Fill all the necessary information.

Acquisition Cost Bal. Acc	Enter the acquistion cost balance G/L account
Depreciation Expense Acc	Enter the Depreciation G/L expense account
Write-Down Expense Acc	Enter the write down G/L expense account
Appreciation Bal. Account	Appreciation G/L balance account
Custom 1 Expense Acc
Custom 2 Expense Acc
Sales Bal Acc	Enter the sale balance G/L Account
Maintenance Bal. Acc	Enter the Maintenance Balance G/L Account
Write-Down Bal. Acc on Disp	Enter the write down Balance G/L Account on disposal
Apprec. Bal Acc. Disp	Enter the balance G/L Account on disposal
Custom 1 Bal. Acc on disposal
Custom 2 Bal. Acc on disposal

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.