This article gives a step by step process to import a .csv file in Dynamics NAV 2017 for Bank Reconciliation.
In Part I and II of this series we reviewed the basic aspects of Inventory Setup and Inventory Transactions. In Part III, I will review select inventory reports which can be useful for analyzing inventory, how to identify when your inventory needs to be reconciled and the steps to take to begin processing an inventory reconciliation.
In Part I of this series, we reviewed the basic aspects of Inventory Setup which influences how NAV calculates inventory value in various scenarios. In Part II of this series, I will review what types of entries NAV posts when inventory transactions are processed. In order to determine the cost of an item there are three types on entries posted:
Have ever look for a option in Microsoft Dynamics NAV to reconcile the cash accounts or any other liquid accounts before posting the transaction to the ledgers?
If you have, then you need to activate the Reconciliation Functionality in the Chart of Accounts. Reconciliation option in the General Ledger Account allows you to see the current balance, and the balance that will be after porting the transaction.
The General Ledger should match the Inventory Subledger at all times, however there are instances when the two can get out of sync and need to be reconciled. In this demonstration we are going to review common causes of differences between the inventory account on the Chart of Accounts and the inventory value of the subledger.