Wednesday, May 13, 2020

Fixed Asset Creation on Microsoft Dynamics Nav Business Central

Dear Friends,

Fixed asset is a piece of property or an equipment owned by a company to produce goods or services to bring revenue to the company.  It is to be noted that an asset can be tangible or intangible.

Step 1:

To create a fixed asset go on the following menu:

Main Menu --> Department --> Financial Management --> Fixed Asset --> Fixed Asset.


Step 2:

Click on the button New and fill the information.



General
No.If no of series has been setup, the fixed asset number will be generated automatically
DescriptionEnter the description of the asset
FA Class CodeEnter the class code of the asset
FA Sub class CodeEnter the sub class code of the asset
FA Location CodeEnter the FA location Code
Serial NoEnter the serial number of the asset
Search DescriptionIt will be set as the description automatically
Responsible EmployeeEnter the employee responsible for the asset
BlockedIf no transaction need to be done on the asset, you can block it
Depreciation Book
Depreciation Book CodeEnter the depreciation book code
Posting GroupEnter the Fixed Asset Fixed Asset Posting Group
Depreciation MethodEnter the depreciation method
Depreciation starting dateEnter the depreciation start date
No of Depreciation yearsEnter the number of depreciation years
Straight Line %If depreciation method is straight line enter the percentage
Depreciation Ending DateThe depreciation ending date will be calculated automatically based on the depreciation year
Maintenance
Vendor No.Enter the vendor number for maintaining the fixed asset.

Click on OK to close.

Tuesday, May 12, 2020

Detailed Customer Ledger Entries and Customer Ledger Entries on Microsoft Dynamics Nav Business Central

Dear Friend,

Ledger Entries play an important role in a transaction. Detailed customer ledger entries and customer ledger entries show you all the transactions that have been done on a customer.  The transaction can be a payment received, invoices or a journal entry.

To go on customer ledger entries go on the following menu:

Main Menu --> Department --> Financial Management --> Receivables --> Customer ledger entries.


To go on detail customer ledger entries, go on the following menu:

Main Menu --> Department --> Financial Management --> Receivables --> Detailed customer ledger entries.


Request to approve on Microsoft Dynamics Nav Business Central

Dear friends,

In this tutorial, we will learn how to approve a sales invoice when we activate workflow on sale invoice approval.

Step 1:

To open the request to approval page go on the following page.

Main Menu --> Department --> Financial Management --> Receivables --> Request to approve.


Step 2:

Click on Approve to give approval

Click on Reject to reject an approval

Click on Delegate to assign someone else for approval

Click on Open record to check the document.

Cash Receipt journal on Microsoft Dynamics Nav Business Central.

Dear Friends,

Cash receipt journal is an important journal as it allow you to take payment from customer.

Step 1:

To proceed to cash receipt journal go on the following menu:

Main Menu --> Department --> Financial Management --> Receivables --> Cash Receipt Journal.


Step 2:

Enter the following information.

Line no.Line No will generate automatically
Posting DateEnter posting date
Document TypeEnter payment in document type
Document NoIf no series is setup, the document no will generate automatically
Account TypeChoose customer as account type
Account NoSearch the customer you wish to do the payment
DescriptionEnter a description for the transaction.

Click on the button Apply Entries.


Select the invoice line, then click on the button Set Applies-to ID. Finally click on OK.

AmountThe amount of the selected invoice will appear here.
Bal. Account TypeEnter Bank Account as Bal. Account Type
Bal. Account NoEnter the Bank No
Payment Method CodeEnter the payment method code
External Document NoEnter any extra important number link to the transaction such as cheque number or transfer number

Step 3: 

Click on Post to validate transaction.


Click on OK to close

Monday, May 11, 2020

Sales Credit Memo creation on Microsoft Dynamics Nav Business Central

Dear Friends,

Today we will learn how to create a sales credit memo. This document is used to reverse a sales invoice.

Step 1:

To create a sale credit memo go on the following path:

Step 2:

Click on the button New and fill the information.

Enter the Customer number.

Step 3:

Click on the button Copy Document.


Step 4:

Fill in the information.


Enter the document type Posted invoice and choose the document no that is the posted invoice you wish to reverse.

Click on OK

Step 5:

Click on the button Post.


Step 6:

Click on OK to close

Sales Invoice creation on Microsoft Dynamics Nav Business Central

Dear Friends,

In this tutorial, we will learn how to create a sale invoice. It is normally a document used to sell  goods or services to a customer.

Step 1:

To create a sale invoice go on the following menu:

Main Menu --> Department --> Financial Management --> Receivables --> Sales Invoices.


Step 2:

Click on the button New and fill the information.



General
Customer NoEnter the customer number
Customer NameCustomer name will appear automatically
AddressAddress will display automatically
Address 2Address will display automatically
CityCity will display automatically
Post CodesPost codes will display automatically
Country / Region CodeRegion Code will display automatically
Contact NoContact number will display automatically
ContactName of the contact will display automatically
Posting DateEnter the posting date
Due DateThe due date will calculate automatically
External Document NoEnter an extra relevant number
Posting DescriptionEnter a posting description
StatusIt will show the status of the sale invoice
Lines
TypeEnter the type
NoEnter the Type No
DescriptionThe name of the type will appear automatically
Description 2Enter a description
Location CodeEnter any Location Code
QuantityEnter the quantity
Unit of MeasureEnter the unit of measure
Unit Price Excl VATEnter the unit price excluding vat
Line Amount Excl Vat Quantity * Unit price
Line Discount %Enter a discount percentage if there is
Line Discount AmountEnter discount amount if there is
Allow Invoice DiscountIf check, the discount amount will be applied
VAT Prod Posting GroupEnter the VAT Prod Posting Group
Gen. Prod Posting GroupEnter the Prod Posting Group
Line No.Line number will display automatically


Invoice Details
Currency CodeIf the invoice is foreign enter the foreign currency
Location codeEnter location Code
Price Include VatIf you want to put price including vat then check this field
Shipping and Billing
Ship-toIf you want to ship the good to another location
ContactIf the another location has a contact person, it will appear here
Bill-toIf you want to bill another customer

Step 3:

Click on POST to validate transaction.


Click on OK to close.

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