Process for comparing Valuation reports against GL Acct balances

Before attempting to compare the GL Account Values to any of the Valuation reports (example Inventory Valuation, Unreconciled Receipt, etc. . ) throughout the system you need to make sure that the following has been done.

  1. Have a backup data set created, that you can have restored and configured as your Test Database for Analysis.You have to do this because inventory is a moving target on your live system.
  2. All AP Debit Memos Approved
  3. All Invoices need to be Released to AR
  4. All Credit Memos Approved
  5. All AP Reconciliations transferred to AP
  6. ALL transactions Released/Posted to the GL
  7. At this point in time you should be able to compare the Valuation Reports to the corresponding GL Account # Values.