Creation of Bank Account Posting Group on Microsoft Dynamics Nav Business Central

Dear Friends,

In this tutirial we will learn how to create a bank account posting group. This setup is a link between a bank account and a G/L Account.

Step 1:

To create the posting group go on the following menu:

Main Menu --> Department --> Financial Management --> Setup --> Bank Account Posting Group.

Step 2:

Click on the button New and fill the information.

Code	Enter a code to the posting group
G/L Account No.	Enter the G/L Account correspond to the posting group

Click on OK to close.

Creation of Vendor Posting Group on Microsoft Dynamics Nav Business Central

Dear Friends,

Today we will learn how to create vendor posting group. This setup shows which G/L account will post the transaction involving the vendor. This posting group defines account for payable, service charge, payment discount account, interest, additional fees and invoice rounding amount.

Step 1:

To create the posting group, go on the following menu:

Main Menu --> Department --> Financial Management --> Setup --> Vendor Posting Group

Step 2: 

Click on OK and fill all the necessary information.

Code	Enter a code for the vendor posting group
Description	Enter a description
Payable Account	Enter the payable G/L account
Service Charge Account	Enter the service charge G/L account
Debit Rounding Account	Enter the rounding G/L account when doing a debit
Credit Rounding Account	Enter the rounding G/L account when doing a crebit
Debit Curr. Appln. Rndg. Account	Enter the G/L Account to post rounding differences when applying different currencies
Credit Curr. Appln. Rndg. Account	Enter the G/L Account to post rounding differences when applying different currencies

Click on OK to close

Creation of Customer Posting Group in Microsoft Dynamics Nav Business Central

Dear Friends,

In this tutorial, we will learn how to create a customer posting group and which G/L account to associate with the posting group. 

The customer posting posting group determines which G/L Account will post the transaction involving the customer. The customer posting group specifies the G/L Account for customer receivable, service charge, payment discount amount, interest, additional fees and invoice rounding amount.

Step 1:

To create a customer posting group, go on the following menu:

Main Menu --> Department --> Financial Management --> Setup --> Customer posting group.

Step 2:

Click on the button New and filled all the required information.

Code	Enter a code for the customer posting group
Description	Enter a description
Receivable Account	Enter the receivable G/L account
Service Charge Account	Enter the service charge G/L account
Debit Rounding Account	Enter the rounding G/L account when doing a debit
Credit Rounding Account	Enter the rounding G/L account when doing a credit
Debit Curr. Appln. Rndg. Account	Enter the G/L Account to post rounding debit differences when applying different currencies
Credit Curr. Appln. Rndg. Account	Enter the G/L Account to post rounding credit differences when applying different currencies

Click on on OK to close.

Creation of a Deferral Template in Microsoft Dynamics Nav Business Central

Dear Friends,

In today's lesson, we will learn how to create a deferral template but first of all lets see what is the word deferral means in the world of accounting. A deferral is always consider as a amount that was paid or received but it cannot be reported on the current income statement, since it will be an expense or revenue for a future accounting period.

The amount will be deferred to a balance sheet account until a future accounting period when it will be transferred to the income statement.

Step 1:

To create a deferral template go on the following menu:

Main Menu --> Department --> Financial Management --> Setup --> Deferral Template.

Step 2:

Click on the button new to create a template and fill all the required information

Deferral Code	Enter a code for the deferral
Description	Enter a description
Deferral Amount	Enter the deferral Amount
Deferral %	Enter the deferral % normally we deferred at 100%
Calc. Method	Enter the calculation method of the deferral template
Start Date	Enter when the deferral template will start
No of Periods	Enter the number of period
Period Desc	Add a description for the period

Click on OK to close.

Setting up Gen Posting Setup on Microsoft Dynamics Nav Business Central

Dear Friends,

This tutorial will provide you an overview on how to configure the General Posting Setup. This setup is done by doing a combination of the Gen. Business Posting Group and Gen. Product Posting Group and their associated G/L Account.

Step 1:

To proceed with the configuration of the General Posting Setup, go on the following menu:

Main Menu --> Department --> Financial Management --> Setup --> Gen. Posting Setup

Step 2: 

Click on the button New and add the following details.

Gen. Bus Posting Group	Enter the Gen. Business Posting Group
Gen. Prod Posting Group	Enter the Gen. Product Posting Group
Description	Enter a description
Sales Account	If it is a sales invoice enter the sales G/L account
Sales Credit Memo Account	If it is a sales credit memo then enter the sales credit memo G/L Account
Sales Line Disc. Account	If on the sales invoice line there is a discount enter the sales line discount G/L Account
Sales Inv. Disc. Account	If the sales invoice contain a discount enter the sales invoice discount G/L Account
Sales Prepayments Account	If prepayment is being done on sales invoice enter the sales prepayments G/L Account
Purch. Account	If it is a purchase invoice enter the purchase G/L Account
Purch. Credit Memo Account	If it is a purchase credit memo then enter the purchase credit memo G/L Account
Purch. Line Disc. Account	If on the purchase invoice line there is a discount enter the purchase line discount G/L Account
Purch. Inv. Disc Account	If the purchase invoice contain a discount enter the purchase invoice discount G/L Account
Purch. Prepayments Account	If prepayment is being made on purchase invoice enter the purchase prepayments G/L Account
COGS Account	Enter your cost of good sold / cost of sale G/L Account
Inventory Adjmt. Account	If adjustment is being done on inventory, enter the inventory adjustment account
Direct Cost Applied Account	This G/L Account is linked with purchase transaction
Overhead Applied Account	Enter the G/L account to post indirect post to income statement
Purchase Variance Account	Enter the purchase variance G/L Account
COGS Account (Interim)	If you wish to pass through an interim account before impacting the COGS account, enter the interim G/L Account
Invt. Accrual Acc. (Interim)	Enter the G/L Account for inventory expected cost transaction
Purch FA Disc. Account	Enter the G/L Account when giving a discount on a requisitioning of a Fixed asset

Setting up Gen. Product Posting Group on Microsoft Dynamics Nav Business Central

Dear Friends,

In this tutorial, we will learn how to setup the General Product Posting Group. This setup specifies what is being sold (item and resources) and what is being purchased (item).

Step 1:

To proceed with the setup go on the following page:

Main Menu --> Department --> Financial Management --> Setup --> Gen. Product Posting Group.

Step 2:

Click on the button New and add the following information.

Code	Enter a code for the posting group
Description	Enter a description for the posting group
Def VAT Prod Posting Group	If you wish to add a default VAT Posting Group
Auto Insert Default	Always check this field

Setting up Gen. Business Posting Group Microsoft Dynamics Nav Business Central

Dear friends,

Today's tutorial is on how to setup the General Business Posting Group. This setup shows who is sold to (Customer) and who is purchased from (vendor).

Step 1:

To proceed with the setup go on the following menu:

Main Menu --> Department --> Financial Management --> Setup --> Gen. Business Posting Group.

Step 2:

Click on the button New and add the following information.

Code	Enter a code for the posting group
Description	Enter the description of the posting group
Def. VAT Bus. Posting Group	In case you wish to default a VAT posting group here
Auto Insert Default	Always ticked this field

Creation of Dimension on Microsoft Dynamics Nav Business Central

Dear Friends,

Today's tutorial will show you how to create dimension and dimension value, used for analytical purposes.

Step 1:

To create a dimension go on the following path:

Main Menu --> Department --> Financial Management --> Setup --> Dimensions --> Dimensions

Step 2:

 Click on the button New and add the following information

Code	Enter a code for the dimension
Name	Enter the name of the dimension
Code Caption	Normally we keep it same as name
Filter Caption	Normally we keep it same as name
Description	Normally we keep it same as name
Blocked	If the dimension is no longer in use, it can be blocked

Step 3:

Setting up Dimension Values.

Click on the button Dimension Values.

Step 4:

Click on the button New and add the following information.

Code	Enter a code for the dimension value
Name	Enter the name of the dimension value
Dimension value type	Let it as standard
Totaling	Not applicable
Blocked	If the dimension value is not in use, you can block it

Setup General Ledger Setup on Microsoft Dynamics Nav Business Central

Hello Guys,

Today's tutorial is about setting up the general ledger setup.  This configuration is essential due to its impact on various parts of the ERP.

To proceed with the setup, go on the following menu:

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

Allow Posting From	Enter when the user can post transaction
Allow Posting To	Enter till when the user can post transaction
Register Time	This field allows a user to register time on the system
Local Address Format	Enter the format of the employer local address
Local Cont. addr format	Always select after company name
inv. rounding precision (LCY)	This will show the rounding of amount for invoices
inv. rounding type (LCY)	Always choose nearest
Amount rounding precision (LCY)	Rounding of amount in the system
Amount decimal places (LCY)	Specify the decimal place for amount
Unit-amount rounding precision (LCY)	Rounding of unit amount in the system
Unit-amount decimal places (LCY)	Specify the unit amount decimal places
Allow G/L Acc deletion before	If you want to prevent delete a G/L as from a date
Check G/L Acc Usuage	This will check if the G/L has been used before deletion
EMU currency	This will convert any amount to EUR currency
LCY Code	Enter the local currency code
Local currency symbol	Enter the symbol of the local currency
Local currency description	Enter the description of the local currency
pmt. disc excl VAT	Exclude VAT on payment discount
Adjust for payment disc	Adjustment on payment discount
Unrealised VAT	If you wish to post VAT amount to a temporary account first then when the transaction is completed the amount will be transfer to the VAT account
Prepayment unrealised VAT	If you wish to post prepayment VAT to a temporary account first then after completing the transaction the amount will transfer to the prepayment VAT account
Max vat difference allowed	This will show you the range allow to change vat amount in invoices
Tax invoiced renaming threshold	Let the threshold amount be 0.00
Vat rounding type	Specify the vat rounding type
Bank Account Nos	No series for bank account number
Bill-to / Sell-to vat calc	VAT will be calculated on bill-to or sell-to
Print vat specification on LCY	If this field is checked, the system will set the vat amount in local currency
use legacy G/L Entry locking	This field lock the G/L entry table when posting date, this prevent data mixing.
show amount	Set this to amount only

Setting up global dimension

Dimension is used for analytical analysis

To add a global dimension click on the button Change Global Dimensions

Enter the global dimension 1 and global dimension 2 then click on the button start.

Setting up shortcut dimension code

                            

Enter the dimension directly.

I hope that this tutorial has been of help to you.  Follow me for more tutorials.

Create an accounting period on Microsoft Dynamics Nav Business Central

Dear friends,

In today's tutorial, I will show you how to create an accounting period. It is very important to create an accounting period because this defines the period when transaction can be done.

To proceed with the creation on the accounting period,

Step 1:

Go on the following menu:

Main Menu --> Department --> Financial Management --> Setup --> Accounting Period.

Click on the button New

Step 2:

Click on the button Create Year.

a) Enter the start date of the financial year

b) Enter the no of period (normally 12 months)

c) Enter the period length (1 M = 1 Month)

d) Then click on OK

After clicking on OK, you will see the system will generate the 12 month period.