Discrepancy Between Stock Valuation Report and Account Balance

Question

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.

Julien Patureau · Accepted Answer

Hi Sagex 
 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

Julien Patureau · 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.

Sage X3

Discrepancy Between Stock Valuation Report and Account Balance

Top Replies

COMMUNITY

COMPANY

PARTNERS

SUPPORT & TRAINING