Tuesday, April 14, 2020

General Journal on Microsoft Dynamics Nav Business Central

Hello Friends,

Today's tutorial is about doing a journal.  The aim of doing journal is to make adjustment in the system. On Microsoft Dynamics Nav Business Central, you can do a journal in different way and you can do it as follows.

1. G/L Account to G/L Account
2. Vendor to G/L Account
3. Customer to G/L Account
4. Bank Account to Bank Account
5. Vendor to Bank Account
6. Customer to Bank Account
7. G/L Account to Bank Account

Step 1:

To open the journal, go on the following menu:

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



Step 2:

Fill all the necessary information.

Batch NameChoose the Batch Name
Line NoThe line no will display automatically
Posting DateEnter the date of the transaction
Document TypeEnter the document type of the transaction
Document NoDocument no will be display automatically if no of series has been setup
Account TypeEnter the account Type for the debited amount
Account NoEnter the account No for the debited amount
Account NameUpon Choosing the account no, the name of the account will display automatically
DescriptionEnter a description for the transaction
AmountEnter the amount (if amount to be credited then negative amount else if amount to be debited then amount is positive)
Amount (LCY)If foreign currency has been used, the amount will be converted to local currency here
Bal. Account TypeEnter the destination account type (Account to be credited)
Bal. Account NoEnter the destination account no (Account to be credited)
Deferral CodeEnter a deferral code if you need to use
External Document NoAdd an external document no
Currency Codeenter the currency code you are using.

Step 3:

After entering all the date click on the button POST to validate the date and post it to the correct G/L account.

Click on OK to close

Creation of G/L Budget on Microsoft Dynamics Nav Business Central

Dear Friends,

In this tutorial we will learn how to create a budget for a G/L Account. Budgeting is done when a specific amount is assigned to a specific G/L account in order to have a better control when the amount is being credited or debited.

Step 1:

To create a budget click go on the following menu:

Main Menu --> Department --> Financial Management --> General Ledger --> G/L Budgets


Step 2: 

 Click on the button New and fill the following information

NameEnter the name of the budget
DescriptionGive a description for the button
Global Dimension 1 CodeGlobal Dimension 1 will display automatically
Global Dimension 2 CodeGlobal Dimension 2 will display automatically
Budget Dimension 1 CodeIf you want to put another dimension
Budget Dimension 2 CodeIf you want to put another dimension
Budget Dimension 3 CodeIf you want to put another dimension
Budget Dimension 4 CodeIf you want to put another dimension
BlockedIf the budget is not longer in use

Step 3:

Click on the button Edit Budget and add the following information


General
Budget NameThe Budget name will appear automatically
Show as LinesLet it be G/L Account
Show as ColumnLet it be period
View ByThe frequency you want to see, here we have chosen month
Rounding FactorIf you have any rounding factor
Show column NameInstead of month and year, you can display the name of the month completely
Budget Matrix
Budget AmountThis will represent the total amount of all the amount from months
Month (JAN 2020, FEB 2020)You will need to enter the amount budget for the specific G/L
Filters
Date FilterIf you want to filter by a specific date
G/L Account FilterIf you want to filter per G/L Account
G/L Account Category FilterIf you want to filter by Account Category
Income/Balance G/L Account FilterIf you want to filter by Income statement or Balance sheet
Global Dimension 1 CodeChoose a global dimension if you need
Global Dimension 2 CodeChoose a global dimension if you need
Budget Dimension 1 CodeUpon creating the budget if you have enter budget dimension it will appear here automatically
Budget Dimension 2 CodeUpon creating the budget if you have enter budget dimension it will appear here automatically
Budget Dimension 3 CodeUpon creating the budget if you have enter budget dimension it will appear here automatically
Budget Dimension 4 CodeUpon creating the budget if you have enter budget dimension it will appear here automatically

Click on OK to close.

Creation of G/L Account on Microsoft Dynamics Nav Business Central

Hello Friends,

In this tutorial, we will learn how to create a G/L account on business central. A general ledger account is used to debit and credit amount while a list G/L Account is know as a chart of account.

Step 1:

To create a G/L Account go on the following menu:

Main Menu --> Department --> Financial Management --> General Ledger --> Chart of account.


Step 2: 

Click on the button New and fill the required information

General
NoEnter the number of the G/L Account
NameEnter the name of the G/L Account
Name 2If the name is long, split the name and enter the second part here
Vendor NameIf the G/L account is linked with a vendor enter the vendor name
Bank Account NoIf the G/L account is linked with a bank account no enter the account no 
Income/BalancePrecise whether the account is an income statement or a balance sheet
Account CategorySelect an account category
Account SubcategorySelect an account subcategory
Debit/CreditAlways enter both
Account TypeSelect an account type
TotalingWhen you will indent the chart of account the totaling field will be populated automatically
Search NameIf you want to enter a search name for the G/L account
Direct PostingIf this field is checked, mean you can post transaction in the G/L Account
BlockedIf the G/L account is no longer in use, you can blocked it so that it will not appear in trial balance
Posting
Gen. Posting TypeEnter a General Posting Type
Gen. Bus. Posting GroupEnter a General Business Posting Group
Gen. Prod Posting GroupEnter a General Product Posting Group
VAT. Bus. Posting GroupIf the G/L Account is taxable enter the VAT Business Posting Group
VAT. Prod. Posting GroupIf the G/L Account is taxable enter the VAT Product Posting Group
Consolidation
Consol. Debit Acc.If consolidation need to be done, enter the Debit Account
Consol. Credit Acc.If consolidation need to be done, enter the Credit Account

Click on OK to close.