Thursday, May 7, 2020

Customer Creation on Microsoft Dynamics Nav Business Central

Hello Friends,

Today's tutorial is on creating customer on Microsoft Dynamics NAV Business Central. A customer is also know as a debtor and we provide them with goods or services.

Step 1:

To create a customer go on the following path:

Main Menu --> Financial Management --> Receivables --> Customers.

Step 2:

Click on the button New and Fill the information.



General
No.If no series is setup, customer number will generate automatically
NameEnter the name of the customer
Name 2If the name if long, enter the remaining name here
Credit Limit (LCY)If you want to set a credit limit on the customer.
BlockedYou can block the customer to prevent further transaction
Address & Contact
AddressEnter customer address
Adress 2Enter customer address
CityEnter customer city
Post CodeEnter post code
Contry/Region CodeEnter Region Code
Primary Contact CodeIf the customer is a company and there is a contact person.
Contact NameUpon choosing contact code, the name will appear automatically
Phone NoEnter Phone Number
EmailEnter Email Address
HomepageEnter customer website
Fax NoEnter customer fax number
Invoicing
Bill-to CustomerIf you want billing to be done to another customer
VAT Registration NoEnter VAT registration number
GLNEnter GLN number
BRNEnter Business Registration Number
Gen. Bus. Posting GroupEnter the General Business Posting Group
VAT. Bus. Posting GroupEnter the VAT Business Posting Group
Customer Posting GroupEnter customer posting group
Currency CodeIf customer is a foreigner, enter the currency code
Payments
Application MethodEnter the application method
Payment Term CodeEnter the payment term code
Payment Method CodeEnter the payment method code

Step 3:

Click on bank account.

Step 4: 

Click on the button New and fill the information



General
CodeEnter a code for the bank
NameEnter the bank name
AddressEnter bank address
Address 2Enter bank address
Post CodeEnter bank post code
CityEnter bank city
Country / Region CodeEnter bank region code
Phone NoEnter bank phone number
ContactEnter the contact person in the bank
Currency CodeEnter the currency of the bank
Bank Branch NoEnter bank branch number
Bank Account NoEnter bank account number
Transit NoEnter bank transit number
Communication
Fax noEnter bank fax number
EmailEnter bank email address
Home PageEnter bank website
Transfer
SWIFT CodeEnter bank swift code
IBANEnter bank IBAN
Bank Clearing StandardEnter bank clearing standard
Bank Clearing CodeEnter bank clearing code


Tuesday, May 5, 2020

Execute standard banking report on Microsoft Dynamics Nav Business Central

Dear Friends,

I will show you how to run standard banking reports in this tutorial. Reports are very important because it displays the required information so that we can do our work or investigation.

To proceed to the report menu go to the following path:

Main Menu --> Department --> Financial Management --> Cash Management

Bank Account - Check Details


You can search by Bank No or Search Name or Bank Acc. Posting Group.



Bank Acc. - Details Trial Bal.


You can search by Bank No or Search Name or Bank Acc. Posting Group.



Bank Account Ledger Entries on Microsoft Dynamics Nav Business Central

Dear Friends,

Today we will learn on Bank Account Ledger Entries, normally this is used for audit purposes because it stores all the transactions done on a bank account.

To open the page go on the following menu:

Main Menu --> Department --> Financial Management --> Cash Management --> Bank Account Ledger Entries.


If you want to reverse a transaction, click on the button Reverse Transaction.


Click on the button Reverse.

Click on Yes to reverse the transaction.

If you want to void a check from a payment that has already been done.

Click on Check ledger entries.


Select the check line and click on the button Void Check.


Select the void date and choose unapply and void check.


Click on Yes to unapply the check and void the check also

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 StartThe start date
Period NameThe name of the period will display automatically
Cust Balance DueThe balance due for all debtor
Vendor Balance DueThe balance due for all creditor
Receivable PayableThe is the remaining amount by taking customer due balance - vendor due balance

Click on the button OK

Monday, May 4, 2020

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 NoChoose the bank you wish to do the reconciliation
Statement NoThe statement no will generate automatically
Statement DateEnter the statement date
Balance Last StatementThis will show the last closing balance
Balance Ending BalanceEnter 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.

Sunday, May 3, 2020

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
NameEnter the name of the bank
Bank Branch NoEnter the branch number if there is
Bank Account NoEnter the bank account number
Communication
AddressEnter the address of the bank
Address 2Enter the address of the bank
Post CodeEnter the post code
CityEnter the city
Country/Region CodeEnter the region code
Phone NoEnter the phone number
ContactEnter a contact person in the bank
Fax NoEnter the fax number
EmailEnter bank email address
HomepageEnter bank website url
Posting
Currency Code
Last Check No
Last Statement No
Bank Last Statement
Bank Acc. Posting Group
Transfer
Transit NoEnter a transit number if there is
Swift CodeEnter Bank Swift Code
IBANEnter 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 nameEnter a user name for the user
Full Name
Enter full name of the user
License Type
Precise the license type of the user
StateState whether the user is active or not
Expiry DateIn case you wish to put an expiry date for temporary user
Contact EmailEnter user contact email
Window Authentication
In case you wish to create user from the active directory of the server.
Window user nameSearch the name in the active directory
User Set Permission
Permission SetState the permission you wish to allocate the user
DescriptionName of the permission will display automatically
Company NameState the company you wish to set the permission
Extension NameNot applicable
Permission ScopeThis will default to system

Click on OK to close.

Monday, April 27, 2020

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 IDSearch the user id
Allow posting fromSpecify the date range the user can post transaction
Allow posting toSpecify the date range the user can post transaction
Register TimeIf the system has a time register, this will allow user to register time
Sales Pers./Purch. CodeIf there is a sales person or purchaser code attached to the user
Allow to create new p.orderThis will let the user to create purchase order.
Modify Qty in blanket orderThis will allow the user to modify blanket order
Fields visibility in p.orderThis will allow user to see important fields such as direct unit cost
Item general viewThis will allow user to view items
Purchase order post optionThis will determine the posting right of the user
Print po with costThis will allow user to print purchase order with cost
Access to void checkThis will allow user to void check.
Allow VAT group changeThis will allow user to change vat prod posting group in invoices.
Time Sheet AdminThis will determine who will be admin for time sheet
E-mailEemail 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

Sunday, April 26, 2020

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 NameSelect the Batch Name
Posting DateEnter the posting date
Starting Document NoIf no series has been setup, the document no will generate automatically
Bank AccountSelect the bank account type
Payment TypeLet this field blank

Click on button OK