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.
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:
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
Thank you Julien Patureau it works correct now.
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.
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.
*Community Hub is the new name for Sage City