Hey Rika Kleinschmidt 

If you’re still experiencing difficulties,

Could you please give us a call or start a webchat ?

This will allow us to investigate the issue with you directly and resolve it.

Regards

William

Good Day Rika

There lots of good explanations for this to happen.

First, you need to run the stock valuation report based on the following 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 discrepancies, Sage is offering a training exactly on this topic on sageu.com: Stock & General Ledger reconciliation

Download patch finder from Sage Community and search for stock valuation to see which bugs have been reported and fixed on version 12.

communityhub.sage.com/.../x3-2025-r2-12-0-38

See below useful links:
us-kb.sage.com/.../

For further assistance please log a case with support so that the issue can be investigated.

Thanks