Configuration of user setup on Microsoft dynamics nav business central

Dear Friends,

Today's tutorial is on how to configure user setup. This configuration is important as it determines what a user can do on the system.

To proceed to user setup go on the following menu:

Main Menu --> Department --> Administration --> Application --> Users --> User Setup.

Step 1:

Click on the button New and fill the information.

User ID	Search the user id
Allow posting from	Specify the date range the user can post transaction
Allow posting to	Specify the date range the user can post transaction
Register Time	If the system has a time register, this will allow user to register time
Sales Pers./Purch. Code	If there is a sales person or purchaser code attached to the user
Allow to create new p.order	This will let the user to create purchase order.
Modify Qty in blanket order	This will allow the user to modify blanket order
Fields visibility in p.order	This will allow user to see important fields such as direct unit cost
Item general view	This will allow user to view items
Purchase order post option	This will determine the posting right of the user
Print po with cost	This will allow user to print purchase order with cost
Access to void check	This will allow user to void check.
Allow VAT group change	This will allow user to change vat prod posting group in invoices.
Time Sheet Admin	This will determine who will be admin for time sheet
E-mail	Eemail address of the user need to be inserted, in case to send mail to the user.

Click on OK to close.

Approval Entries for Payable on Microsoft Dynamics Nav Business Central

Dear Friends,

In this tutorial, we will learn where to approve a request in payable. Normally many users wish to have a hierarchy level in their company, where each level has a set of rights on the system. The user can set up a workflow which prevents a low level user to post a purchase invoice and the user need to send the purchase invoice through an approval process to validate the invoice.

To access the approval page go on the following menu:

Main Menu --> Department --> Financial Management --> Payable --> Request to Approve.

a). Approve purchase invoice.

      Select the purchase invoice you wish to validate and click on the button Approve.

b). Reject purchase invoice

       Select the purchase invoice you wish to revoke and click on the button Reject.

c). Reassign the purchase invoice to get approval from another approver.

      Select the purchase invoice you wish to reassign and click on the button Delegate.

d). In case you wish to know the content of the purchase invoice, click on the button Open Invoice

Verification of vendor ledger entries on Microsoft Dynamics Nav Business Central

Dear Friends,

I trust you are doing well, today we will learn on vendor ledger entries.  This part is important because any transaction done on a vendor (transaction can be a payment, invoicing or even journal entry) will be recorded. Vendor ledger entries are mostly used to do reporting or investigation when an occurrence arises.

To access the page vendor ledger entries go on the following menu:

Main Menu --> Department --> Financial Management --> Payable --> Vendor Ledger Entries.

a). If you want to check what invoices have been applied to a payment. Select the payment line then click on the button Applied Entry.

b). If ever a payment has been done without applying an invoice and the invoice has been created at a later stage, click on the button Apply Entries

Select the invoice line, then click on the button Set Applies to ID then click on the button Post Application

c.) If ever you wish to unapply an invoice from a payment click on the button unapply entries.

Select the invoice line and click on the button unapply.

d). If you wish to reverse a payment or transaction, first you need to check if there is an invoice attached to the payment, reverse it then click on the button Reverse Transaction.

e). You can create a payment on this page directly, select the invoice line then click on the button Create Payment.

Fill the information needed.

Batch Name	Select the Batch Name
Posting Date	Enter the posting date
Starting Document No	If no series has been setup, the document no will generate automatically
Bank Account	Select the bank account type
Payment Type	Let this field blank

Click on button OK

Run Payable Report on Microsoft Dynamics Nav Business Central

Dear Friends,

Today we will do a small tutorial on how to run some important payable reports. To access the report menu go on:

Main Menu --> Department --> Financial Management --> Payable

Run Report Age Account Receivable.

Aged As Of	Enter the date you wish to run as at
Aging by	Enter Posting date
Period Length	Enter the Period Length 1 month
Print Amounts in LCY	If you want to print the report in local currency
Print Details	If you want to print more detail

Run Report Vendor - detail trial balance

If you want to show the report in local currency check the checkbox.

Payment Journal transaction on Microsoft Dynamics Nav Business Central

Dear Friends,

Today's session will focus on how to do a transaction on the payment journal. Normally we take payment to a vendor on the payment journal. In case a purchase invoice has already been posted, when paying the vendor it needs to be done on the payment journal by applying the posted purchase invoice to the transaction.

Before proceeding to payment, you need to ensure that you have a posted purchase invoice on the system.

Step 1:

Go on the following Menu:

Main Menu --> Department --> Financial Management --> Payable --> Payment Journal.

Step 2: 

Choose the batch name you wish to do the transaction.

Step 3: 

Fill all the information needed.

Line No	The line no will be displayed automatically
Posting Date	Enter the transaction date
Document Type	Enter Payment as document type
Document No	If no series has been setup the document no will generate automatically
External Document No	Enter external document no
Account Type	Choose vendor
Account No	Choose the vendor number
Description	The name of the vendor will appear here
Description 2	Enter a description of the transaction

Click on the button Apply Entries.

Then choose the invoice you wish to apply, then click on the button Set Applies-to ID to link the invoice with the payment.

Click on OK

Amount	After applying the invoice, the amount will appear automatically
Bal. Account Type	Enter Bank Account as Type
Bal. Account No	Choose the Bank Account
Bank Payment Type	Select the Bank Payment Type
Check Printed	This field show if check has been printed or not
Payment Method Code	Choose the payment method Code

Step 4: 

Check printing.

To print check click on the button print check.

Step 5:

Enter the following information.

Bank Account	Enter the bank account you wish to print the check
Last Check No	Upon choosing the bank account the last check no will display automatically
Journal Template Name	The template name will display automatically
Journal Batch Name	The batch name will display automatically

Click on Print and choose your printer.

In case you have already printed a check and you wish to cancel the transaction, click on the
button VOID Check.

If you have multiple line and want to void all, click on the button VOID All Checks.

Step 6:

To validate the transaction click on the button POST.

Click on OK to close.

Purchase Credit Memo creation on Microsoft Dynamics Nav Business Central

Dear Friends,

Today we will learn how to create a purchase credit memo in case a purchase invoice has been created incorrectly and posted. The aim of a purchase credit memo is to cancel a purchase invoice transaction and reverse all amount from G/L Account.

Step 1:

Go on the following menu:

Main Menu --> Department --> Financial Management --> Payable --> Purchase Credit Memos.

Step 2:

Click on the button New and click on the tab navigate.

Step 3:

After clicking on the button Copy Document.

1. Choose the document type posted invoice, because we will reverse a posted purchase invoice.

2. Search the Posted Purchase Invoice Number

3. Click on the checkbox Include Header to bring the header information on the credit memo

Click on OK.

Step 4:

The system will take the information in the posted invoice to filled the credit memo automatically. Click on the button POST to validate the purchase credit memos.

Click on OK to close

Purchase Invoice Creation on Microsoft Dynamics Business Central

Dear Friends,

Today we will learn how to create a purchase invoice on Microsoft Dynamic Nav Business Central. A purchase invoice is a document that a buyer uses to present a payment to a seller. The use of purchase invoice is to track any payment done for audit purposes.

Step 1:

To create a purchase invoice go on the following menu:

Main Menu --> Department --> Financial Management --> Payable --> Purchase Invoice.

Step 2:

Click on the button New and fill the following information.

General
Vendor No	Enter the Vendor Number
Vendor Name	Vendor Name will display automatically
Address	Address will display automatically
Address 2	Address 2 will display automatically
City	City will display automatically
Post Code	Post Code will display automatically
Country/Region code	Region code will display automatically
Contact No	Choose the contact person from the vendor
Contact	Contact person name will display automatically
Document Date	Document will be filled automatically
Posting Date	Posting date will be taken as today's date but can be changed
Due date	Due date is calculated as per the payment term code
Vendor Invoice No	Enter the vendor invoice no
File Ref	Enter the file reference where the invoice is
Posting Description	Enter a posting description
Status	Status will be set automatically as per level of the invoice has reached

Lines
Line No	Line Number will be displayed automatically
Type	Enter the type of the transaction line
No	Enter the no of the type
Description	The name of the type number will display automatically
Description 2	Enter a description for the transaction
Location Code	Enter a location code if there are
Quantity	Enter the quantity to purchase
Unit of Measure	Enter the unit of measure
Direct Unit Cost Excl. VAT	Enter the unit cost excluding vat
Line Amount Excl. VAT	Line amount will be calculate with quantity by unit cost
Line Discount %	Enter a discount % if there is
Line Discount Amount	Enter a discount amount if there is
Gen. Prod Posting Group	The general product posting group will appear automatically
VAT Prod. Posting Group	Enter the VAT product posting code

Invoice Details
Currency Code	Enter the currency code of the foreign invoice
Price including VAT	If the user wants to enter unit cost including vat, then checked this field
Global Dimension 1 Code	Enter Global dimension 1 code
Global Dimension 2 Code	Enter Global dimension 2 code

Shipping and Payment
Ship-to	If the user wish the goods being delivered to another location or address
Name	Enter the name
Address	Enter the address
Address 2	Enter the address 2
City	Enter the city
Post Code	Enter the Post Code
Country/Region	Enter the Region
Contact	If their is a contact person there
Pay-to	If payment need to be done to another vendor

Vendor Creation on Microsoft Dynamics Nav Business Central

Dear Friends,

Today we will learn how to create a vendor on the ERP. By definition, a vendor is a person or a company that supplies goods or services.

Step 1:

Go on the following menu to create the vendor.

Main Menu --> Department --> Financial Management --> Payable --> Vendors

Step 2: 

Click on the button New and fill the following information.

General
No	If no series has been parameter, the no will generate automatically
Name	Enter the name of the supplier
Name 2	If the name is long enter the remaining name here
Blocked	If there is no activity on the vendor, you can block it to prevent further transaction
Search Name	You can enter a short name in order to facilitate user to search the vendor
Address & Contact
Address	Enter the address 1
Address 2	Enter the address 2
City	Enter the city
Post Code	Enter the post code
Country/Region Code	Enter the region code
Contact	if the vendor has a specify contact person
Phone No.	Enter the vendor phone number
Email	Enter the vendor email address
Fax No.	Enter vendor fax no
Invoicing
VAT Registration No	Enter the VAT registration number
BRN	Enter the business registration number
NID	If the the vendor is an individual, enter the national identity card number
Gen. Bus Posting Group	Enter the General Business Posting Group
VAT Bus Posting Group	Enter the vat business posting group
Vendor Posting Group	Enter the vendor posting group (Creditor control)
Currency Code	If the vendor is a foreigner, enter his currency
Payments
Application Method	Let the method be manual
Payment Term Code	Enter the payment term
Payment Method Code	Enter the payment method

Step 3:
To enter vendor bank information, go on the tab Navigate then click Bank Account

Step 4:
Click on the button New and enter the following information

General
Code	Enter a code for the bank
Name	Enter Bank Name
Address	Enter address 1
Address 2	Enter Address 2
Post Code	Enter Post Code of the bank
City	Enter City of the bank
Country/Region Code	Enter region code of bank
Phone No	Enter Bank Phone number
Contact	If the bank has a specific person to contact
Currency Code	If the bank is foreign, enter the foreign currency
Bank Branch No	Enter bank branch number
Bank Account No	Enter bank account no
Transit No.	Enter transit no
Communication
Fax No.	Enter fax number
Email	Enter email address
Home Page	Enter website of the bank
Transfer
Swift Code	Enter the swift code of the bank
IBAN	Enter the IBAN of the bank
Bank Clearing Standard	Enter the clearing standard
Bank Clearing Code	Enter the clearing code

Click on OK to close

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.

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 Name	Choose the Batch Name
Line No	The line no will display automatically
Posting Date	Enter the date of the transaction
Document Type	Enter the document type of the transaction
Document No	Document no will be display automatically if no of series has been setup
Account Type	Enter the account Type for the debited amount
Account No	Enter the account No for the debited amount
Account Name	Upon Choosing the account no, the name of the account will display automatically
Description	Enter a description for the transaction
Amount	Enter 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 Type	Enter the destination account type (Account to be credited)
Bal. Account No	Enter the destination account no (Account to be credited)
Deferral Code	Enter a deferral code if you need to use
External Document No	Add an external document no
Currency Code	enter 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

Name	Enter the name of the budget
Description	Give a description for the button
Global Dimension 1 Code	Global Dimension 1 will display automatically
Global Dimension 2 Code	Global Dimension 2 will display automatically
Budget Dimension 1 Code	If you want to put another dimension
Budget Dimension 2 Code	If you want to put another dimension
Budget Dimension 3 Code	If you want to put another dimension
Budget Dimension 4 Code	If you want to put another dimension
Blocked	If the budget is not longer in use

Step 3:

Click on the button Edit Budget and add the following information

General
Budget Name	The Budget name will appear automatically
Show as Lines	Let it be G/L Account
Show as Column	Let it be period
View By	The frequency you want to see, here we have chosen month
Rounding Factor	If you have any rounding factor
Show column Name	Instead of month and year, you can display the name of the month completely
Budget Matrix
Budget Amount	This 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 Filter	If you want to filter by a specific date
G/L Account Filter	If you want to filter per G/L Account
G/L Account Category Filter	If you want to filter by Account Category
Income/Balance G/L Account Filter	If you want to filter by Income statement or Balance sheet
Global Dimension 1 Code	Choose a global dimension if you need
Global Dimension 2 Code	Choose a global dimension if you need
Budget Dimension 1 Code	Upon creating the budget if you have enter budget dimension it will appear here automatically
Budget Dimension 2 Code	Upon creating the budget if you have enter budget dimension it will appear here automatically
Budget Dimension 3 Code	Upon creating the budget if you have enter budget dimension it will appear here automatically
Budget Dimension 4 Code	Upon 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
No	Enter the number of the G/L Account
Name	Enter the name of the G/L Account
Name 2	If the name is long, split the name and enter the second part here
Vendor Name	If the G/L account is linked with a vendor enter the vendor name
Bank Account No	If the G/L account is linked with a bank account no enter the account no
Income/Balance	Precise whether the account is an income statement or a balance sheet
Account Category	Select an account category
Account Subcategory	Select an account subcategory
Debit/Credit	Always enter both
Account Type	Select an account type
Totaling	When you will indent the chart of account the totaling field will be populated automatically
Search Name	If you want to enter a search name for the G/L account
Direct Posting	If this field is checked, mean you can post transaction in the G/L Account
Blocked	If 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 Type	Enter a General Posting Type
Gen. Bus. Posting Group	Enter a General Business Posting Group
Gen. Prod Posting Group	Enter a General Product Posting Group
VAT. Bus. Posting Group	If the G/L Account is taxable enter the VAT Business Posting Group
VAT. Prod. Posting Group	If 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.

Creation of Inventory Posting Setup on Microsoft Dynamics Nav Business Central

Dear Friends,

Today in our tutorial we will learn how to setup inventory posting. This setup determines the inventory account in the general ledger to which the program posts for transactions involving this item (any transaction related to Item Inventory).

Step 1:

To do the setup go on the following menu:

Main Menu --> Department --> Financial Management --> Setup --> Inventory Posting Setup

Step 2: 

Click on the button New and fill the required information.

Location Code	Enter the location
Inv. Posting Group Code	Enter the inventory posting group
Description	Enter a description
Inventory Account	Enter the inventory G/L account
Inventory Account (interim)	If you want to use an interim account during good receive enter the G/L Account here
WIP Account	In case you are you work in progress, enter the work in progress G/L Account
Material Variance Account	Enter the Material Variance G/L Account
Capacity Variance Account	Enter the Capacity Variance G/L Account
Mfg. Overhead Variance Account	Enter the Manufacturing Overhead Variance G/L Account
Cap. Overhead Variance Account	Enter the Capacity Overhead Variance G/L Account
Subcontracted Variance Account	Enter the subcontracted variance G/L Account

Creation of Inventory Posting Group on Microsoft Dynamics Nav Business Central

Hello friends,

Today we will learn how to create an inventory posting group.

Step 1:

To proceed with the creation go on the following menu:

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

Step 2:

Click on the button New and fill the following information.

Code	Enter a code for the posting group
Description	Enter a description

Click on OK to close