Receivable and Payable in cash management on Microsoft Dynamics Nav Business Central

Dear Friends,

In this tutorial, we will learn about receivable and payable reports in the module cash management.

Step 1:

To proceed with the report go on the following menu:

Main Menu --> Department --> Financial Management --> Cash Management --> Receivables Payables.

Select the way you wish to view the report in the field view by.

Period Start	The start date
Period Name	The name of the period will display automatically
Cust Balance Due	The balance due for all debtor
Vendor Balance Due	The balance due for all creditor
Receivable Payable	The is the remaining amount by taking customer due balance - vendor due balance

Click on the button OK

Bank Reconciliation on Microsoft Dynamics Nav Business Central

Dear Friend,

Today we will learn how to do bank reconciliation. This process is an important process for a company to cross check all payments done over a specific period with its bank statements and will highlight whether any illegitimate transaction has been done.

Step 1:

To proceed with the bank reconciliation, go on the following menu.

Main Menu --> Department --> Financial Management --> Cash Management --> Bank Reconciliation.

Step 2:

Click on the button New and fill the information.

Bank Account No	Choose the bank you wish to do the reconciliation
Statement No	The statement no will generate automatically
Statement Date	Enter the statement date
Balance Last Statement	This will show the last closing balance
Balance Ending Balance	Enter the ending balance on the bank statement

Step 3:

After choosing the bank, all the transactions in the bank account ledger entries which are open will appear in the right pane Bank Account Ledger Entries.

Step 4:

Process 1:

If you want the system to suggest the line, click on the button Suggest Line.

Enter the following information.

1. Starting date

We usually let the starting date be blank because it may be that there are previous transaction that have not been reconciled in the last statement.

2. Ending date.

Enter an ending date

3. Include Checks

We need to tick this because we need to include check transaction also.

4. Exclude reverse entries.

We usually let the field unticked because reversal is done at ERP level not bank.

Click on OK.

After clicking OK you will see the system will bring all the transactions on the left panel bank statement line.

Now take the bank statement and match it on nav.  If a transaction on nav is not found on bank statement, this means that the transaction is not yet done at bank level, so we need to delete the line on the left panel so that the line can be reconciled on the next statement.

Process 2:

If you want to apply transaction that is found only in the bank statement and in order not to delete lots of line on the left panel, click on the button Apply Entries.

Click in the checkbox on the line of transaction.

Then click on OK to bring it on left panel.

All the transaction has been grouped in one line.

Step 5:

After doing the reconciliation, we need to post the transaction.

After posting the transaction, the statement will be set to closed.

Creation of Bank Account in Microsoft Dynamics Nav Business Central

Dear Friends,

Today we will learn how to create a bank account on Microsoft. Bank accounts are used to pay a vendor, receive payment from a customer or effect an inter-banking transfer.

Step 1:

To create a bank account go on the following menu:

Main Menu --> Department --> Financial Management --> Cash Management --> Bank Accounts.

Step 2:

Click on the button New and fill the information.

General
No.	Enter a bank code
Name	Enter the name of the bank
Bank Branch No	Enter the branch number if there is
Bank Account No	Enter the bank account number
Communication
Address	Enter the address of the bank
Address 2	Enter the address of the bank
Post Code	Enter the post code
City	Enter the city
Country/Region Code	Enter the region code
Phone No	Enter the phone number
Contact	Enter a contact person in the bank
Fax No	Enter the fax number
Email	Enter bank email address
Homepage	Enter bank website url
Posting
Currency Code
Last Check No
Last Statement No
Bank Last Statement
Bank Acc. Posting Group
Transfer
Transit No	Enter a transit number if there is
Swift Code	Enter Bank Swift Code
IBAN	Enter Bank IBAN number

Click on OK to close

Creation of Users on Microsoft Dynamics Nav Business Central

Dear Friends,

Today we will learn how to create a user on Microsoft Dynamics Nav Business Central.

Step 1:

To proceed with the creation of user, go on the following menu:

Main Menu --> Department  --> Administration --> IT Administration --> General --> Users.

Step 2:

Click on the button New.

Step 3:

Fill the following information

General In case you wish to create a normal user
User name	Enter a user name for the user
Full Name	Enter full name of the user
License Type	Precise the license type of the user
State	State whether the user is active or not
Expiry Date	In case you wish to put an expiry date for temporary user
Contact Email	Enter user contact email
Window Authentication In case you wish to create user from the active directory of the server.
Window user name	Search the name in the active directory
User Set Permission
Permission Set	State the permission you wish to allocate the user
Description	Name of the permission will display automatically
Company Name	State the company you wish to set the permission
Extension Name	Not applicable
Permission Scope	This will default to system

Click on OK to close.

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