Work with Inventory Reconciliation

This quickstart will set up the module Inventory Reconciliation in 8 simple steps.

Open the window Reconciliation SetupwithDepartments - Compliance- Control - Reconciliation - Inventory Reconciliation - Setup - Reconciliation Setup. Enter in the fieldInventory Post Codethe source code (usually “VOORWDEBKN”). Select with Actions, Functions, Setup Default Reasons Skipped Value EntryandSetup Default Reasons Skipped G/L Entry. In the FastTabsSkipped Value EntryandSkipped G/L Entry, Dynamics NAV automatically fills the default reason codes that are used for skipping value and G/L Entries.

Only applicable for Dynamics NAV version 3.x: Set up parameters for posting of expected costs to G/L. Open the window Post Expected Costs to G/L. Enter to which value entry range the expected costs were posted to the G/L (usually applicable to all entries from number 1).

Create a new reconciliation view. Enter in the field Code a clear code and in the field Name a clear description. Select in the field Type ‘Inventory Reconciliation’ and select in the field Date Compression the desired compression level (bigger compression is quicker build). Select Determine Used Accounts to be able to, besides the reconciliation based on the current posting group setup, also analyse the historical reconciliation. Select Show Progress if you want to see the progress during the calculation (advice in bigger environments is to deselect Show Progress for a better performance).

You can also specify the reconciliation view with Dimensions and Customer, Vendor and Item Attributes. The Customer, Vendor and Item Attributes cannot be used in the analysis windows.

Update the reconciliation view initially with Related Information, Update, All. The initial building can take a while depending on the size of your database.

If there are notifications about non existing accounting periods when you are updating the reconciliation view, you need to create these periods. Afterwards, you can resume updating the reconciliation view by Related Information, Update, From Last Entry . The calculation is moving on from last processed entry before the notification.

Step 6: Process Skipped Value Entry

If you have skipped value entries during updating of the reconciliation view, you have to analyse and process these skipped entries (if possible). This is possible by the window Reconciliation View and the field No. of Skipped Value Entries. Select the arrow down button to show a list of the skipped value entries. Here you can analyse and process the value entries of the Skipped Value Entry Card.

If the reconciliation is built completely, then you can calculate the analysis in the windows. This is possible by the button Related Information, Update, Analysis. You can also set filters in the calculation. After the calculation you can open the windows Analysis Inventory Accounts or Analysis Applied Accounts. If you select the reconciliation view in the field Reconciliation View Code, the window will fill with data. You also can recalculate the windows Analysis Inventory Accounts and Analysis Applied Accounts with Actions, Functions, Calculate, for example after changing the filters.

With the data in the analysis windows you can analyse the reconciliation between the general ledger and the sub administration of the inventory and applied accounts. Possible differences can be limited to a certain period or posting group combination by the button Actions (Alt+F10), Account, Analysis Per Period and Actions (Alt+F10), Account, Analysis Per Posting Group.

From the main window and the analysis per posting group window you can zoom in to the entries to trace and analyse possible differences to document numbers.

More information: Work with Analysis

More information: Work with Reconciliation Views

  • 2-controlware/09inventoryreconciliation/1work_with_inventory_reconciliation.txt
  • Last modified: 2020/10/23 12:55
  • by luukvm