Discrepancy Between Stock Valuation Report and Account Balance

SOLVED

I compared my Stock valuation report with the Account balance (INVENTORY), and they don't match. How can I find the transactions that caused this discrepancy.

Top Replies

  • Hi  

    There lots of good explanations for this to happen.

    First you need to run the stock valuation report based on the follwing settings:

    • Use the costing mode based on the product issued method 1
  • +1
    verified answer

    Hi  

    There lots of good explanations for this to happen.

    First you need to run the stock valuation report based on the follwing settings:

    • Use the costing mode based on the product issued method 1
    • Tick the accounting date option and be sure to use the same date range
    • Untick the transferred field (except if manage as direct GL entry on the same account!)

    Then possible reasons are: posting rule are not corrects, manual journals have been created on the INVENTORY account, desynch on PIT tables (normally fixed with stock utilities tools), etc.

    And keep in mind Stock site <> Finance site, so be sure to be consistent in the site selection especially if you have multiple stock sites hitting the same finance site (which is usually the case).

    If you still have discrepencies, Sage is offering a training exactly on this topic on sageu.com : Stock & General Ledger reconciliation

  • 0 in reply to Julien Patureau

    Thank you  it works correct now.

  • +1 in reply to Sagex
    verified answer

    If you want to secure the value of stock in the GL, please make sure all STOJOU records (except internal ones) are posted.
    Easy way is

    Be sure to remove internal movement and make sure to have value change and price adjustments.