RE: Inventory Valuation report
Step 1 - Check Direct Posting on the GL Accounts, verify they are turned off
Step 2 - Check GL accounts for entries made 1) system created entry = no and 2) source code = genjnl. Both of these mean that the inventory subledger was bypassed.
Step 3 - Does the Inventory to GL Reconcile report for the date in question have values in the Inv. Value to be Posted column? If so you have adjust costs to be run whether you post to the date in question or to current date can be controlled in General Ledger Setup
Step 4 - Review Inventory Posting Setup and General Posting Setup to make sure that you are accounts setup as required by the system. Except for COGS interim, no inventory accounts in any other fields in General Posting Setup and in Inventory Posting Setup only GL accounts.
Step 5 - Are you using Expected Cost, what account are you posting expected costs to?
Step 6 - You might have to compare receipt dates to invoice dates. If you receive on 7/31 but post the invoice to 8/1, you will have a difference. Control this by closing the allow from/to dates quicker.
Step 7 - There are other variables, you need to contact your partner or a NAV expert.
Check out the Inventory to GL Reconciliation Blog Series at kimdandnavbc.com
