Work with Analysis
After updating the reconciliation view, you need to calculate the analysis windows to perform the most actual analyses. You can do this by executing Related Information, Update, Analysis. In the window Reconciliation View. Based on this function the windows Analysis Inventory Accounts and Analysis Applied Accounts are updated. You can also add filters for the calculation of the analysis. The function to calculate analyses can also be executed from the windows Analysis Inventory Accounts and Analysis Applied Accounts.
Note! Check whether the analysis has been updated, otherwise update it.
Analysis Applied Accounts
In the window Analysis Applied Accounts you can analyse the reconciliation between the applied accounts and the general ledger accounts based on the reconciliation view.
Follow the steps below to analyse the Applied Accounts:
1. Open the window Analysis Applied Accounts.
2. Select in the field Reconciliation View Code the code that you want to use for analysis.
3. Select in the field Show Fields the type of reconciliation that you want to view. You can analyse based on the historical reconciliation (Used) or based on the current settings (Setup).
4. The window shows per general ledger account the reconciliation between the Applied accounts (the fields (1) Applied Inventory Amount, (2) Applied Sales Amount, (3) Production Variances and (4) Applied Purchase Amount) and the general ledger amount (field G/L Amount). In the field Difference you can see the differences. On FastTab Filters or with the time interval buttons on the bottom of the window you can refine the reconciliation.
5. If the window Analysis Applied Accounts shows differences the first (quick visible) possible cause is that the account is used as inventory account. You can see this in the field Used Inventory Account or Setup Inventory Account (depending on which reconciliation (Show Fields) you are analysing). There are two other possible causes of differences, manual postings or other automatic postings, visible in the next fields:
- G/L Manual Entry Amount: the amount of manual postings on the G/L account.
- G/L Other Non-manual Amount: automatic, by the system generated postings for which the system cannot find a linked value entry in the sub administration, e.g. compressed entries or entries from another sub administration.
If the amount of the manual postings and the amount of the non-manual postings are equal to the difference, the sub administration and the general ledger are reconciled completely. In other words: “Difference - G/L Manual Entry Amount - G/L Other Non-manual Amount” should always be 0.
6. You can filter on various ways with the FastTabs Filters and Posting Group Filters. Note that when a filter is changed, the analyse should be recalculated. Click on Actions, Functions, Calculate.
7. You can use the field Show Check Columns to make the fields Inventory/WIP Sub Ledger Amount and Check visible. With these fields you can check the reconciliation. The field Inventory/WIP Sub Ledger Amount shows the possible posted inventory related entries to the general ledger accounts. The field Check calculates the difference minus the fields G/L Manual Entry Amount, G/L Other Non-manual Entry Amount and Inventory/WIP Sub Ledger Amount. If the column Check still shows differences, you need to contact your Dynamics NAV partner.
8. You can trace possible differences to a certain period or posting group by analysing the reconciliation of only one G/L account per period or posting group with the windows Analysis by Period, Analysis Production variance by Posting group and Analysis Applied Account by Posting Group. Select Actions (Alt+F10), Account and select Analysis by Period, Analysis Production variance by Posting group or Analysis Applied Account by Posting Group to open the specific windows.
Analysis Inventory Accounts
In the window Analysis Inventory Accounts you can analyze the reconciliation between the inventory accounts and the general ledger accounts based on the reconciliation view.
Follow the steps below to analyze the inventory:
1. Open the window Analysis Inventory Accounts.
2.Select in the field Reconciliation View Code the code that you want to use for analysis.
3. Select in the field Show Fields the type of reconciliation that you want to view. You can analyze based on the historical reconciliation (Used) or based on the current settings (Setup).
4. The window shows per general ledger account the reconciliation between the sub administration (the fields Inventory, Inventory (Interim) and WIP Inventory) and the general ledger (field G/L Amount). In the field Difference you can see the differences. On FastTab Filters or with the time interval buttons on the bottom of the window you can refine the reconciliation.
5. If the window Analysis Inventory Accounts shows differences the first (quick visible) possible cause is that the account is also used as applied account. You can see this in the field Used Applied Account or Setup Applied Account (depending on which reconciliation you are showing). There are two other possible causes of differences, manual postings or other automatic postings, visible in the next fields:
- G/L Manual Entry Amount: the amount of manual postings on the G/L account
- G/L Other Non-manual Amount: automatic, by the system generated postings for which the system cannot find a linked value entry in the sub administration, e.g. compressed entries or postings from another sub administration.
If the amount of the manual postings and the amount of the non-manual postings are equal to the difference, the sub administration and the general ledger are reconciled completely. In other words, “Difference - G/L Manual Entry Amount entries - G/L Other Non-manual Amount entries” should always be 0.
6. You can filter the differences on various ways with the FastTabs Filters and Posting Group Filters. Note that when a filter is changed, the analysis from should be recalculated.Click on Actions, Functions, Calculate.
7. You can use the field Show Check Columns to make the fields Applied Sub Ledger Amount and Check visible. With these fields you can check the reconciliation. The field Applied Sub Ledger Amount shows the possible entries of applied costs on the general ledger accounts. The field Check calculates the difference minus the fields G/L Manual Entry Amount, G/L Other Non-manual Entry Amount and Applied Sub Ledger Amount. If the column Check still shows differences, you need to contact your Dynamics NAV partner.
8. You can trace possible differences to a certain period or posting group by analyzing the reconciliation of only one G/L account per period or posting group with the windows Analysis by Period and Analysis by Posting Group. Select Analysis by Period and Analysis by Posting Group to open the specific windows.
Analysis General Ledger Entries
In the window Analysis G/L Entries you can analyse the general ledger entries based on a reconciliation view for example by dimension, source code or user ID.
Follow the steps below to analyse the G/L Entries
1. Open the window Analysis G/L Entries.
2. Select in the field Reconciliation View Code the reconciliation view code that you want to use for the analysis.
3. Select in the field Show as Lines the values that you want to show as lines in the analysis window. For example if you select G/L Account, all G/L Accounts will be shown in the Lines.
4. Select in the field Show as Columns which values can be shown as columns in the analysis window. For example if you select the Source Code, the amount of the source code by G/L Account will be shown in the columns.
5. On the FastTab Filters and by the time interval buttons you can refine the result. On the FastTab Options you can indicate if the result should include Closing Entries and should include a Rounding Factor, for example thousands. Check Show Column Name to show the name (or otherwise the code) of the columns.
Note! This window requires no calculation after changing filters and other parameters.
Process Skipped Value Entries
In the window Skipped Value Entries you can analyse and, if possible, process skipped value entries.
Value entries will be skipped if they belong to an unknown entry (not default Dynamics NAV), for example caused by customization. The module Inventory Reconciliation cannot determine how these entries should be processed automatically in the reconciliation. These entries are logged as a Skipped Entry Post during building or updating. You can define how the module Inventory Reconciliation should process these entries.
Follow the steps below to process Skipped Value Entries:
1. Open the window Reconciliation View.
2. Select the field No. of Skipped Value Entries and open the window Skipped Value Entry Listby using the arrow down button. This window shows a list of all value entries that are skipped during updating the reconciliation view.
3. Select the value entry that you want to process. Select Function key Ctrl+Shift+V. The window Skipped Value Entry shows the skipped value entry and the reason for skipping on the FastTab General.
4. On the FastTab Accounts you can define G/L accounts for processing the skipped value entries. Depending on the entry type of the value entry, only the relevant fields are editable. Select in the fields Inventory Accounts, Inv. Account (Interim), WIP Account, Applied Account or Applied Account (Interim) the applicable G/L accounts. You can only select the G/L Accounts that are linked to the value entry. The right side of the window shows a proposal (based on the current posting group setup) for the accounts that should be filled. This are not necessarily the correct accounts, the setup can be modified.
5. If you have filled all accounts, the fields Inventory Amount, G/L Amount, Applied Amount and G/L Amount determines if the value entry can be processed. The value entry can only be processed if the amounts on the inventory and applied accounts are in balance with the G/L accounts. If so, the field Reprocess is checked automatically and the entry will be processed when the reconciliation view is updated. Skipped value entries can also be processed manually by selecting Related Information, Skipped Value Entry, Reprocess Skipped Value Entries.
6. If you have multiple skipped value entries of the same posting type and posting groups you do not have to define the settings for every single value entry. Select Related Information, Skipped Value Entries, Apply Settings.
In this window you can define a value entry range that applies to the settings. The settings are only applicable to the value entries with the same posting types and posting groups. Enter a value entry range and click on OK.
7. After setting up all skipped value entries you can process them by updating the reconciliation view or select Related Information, Skipped Value Entries, Process Skipped Value Entries. If there are value entries that cannot be processed, please contact your Dynamics NAV partner. These entries are always caused by customizations or bugs.