The Stock Valuation by GL Account report is a diagnostic report to be run if the Stock Value by GL Group (Summary) report shows there is a value discrepancy between the GL Value and the stock sub-ledger value.
Variances typically occur in the following situations:
1.The GL Opening Balance is manually altered (it is generated from the Opening Balance PO's and should never be touched).
2.Users have journalled directly to the 1-XXXX Stock on Hand accounts (they should not do this).
3.You may see small rounding variances over time, but usually if you have a high volume of purchases and returns and are transacting in 4 decimal places and/or multicurrency.
4.If using Manufacturing, and selecting stock from PO's on received in the manufacturing process, it can cause a temporary variance. Once the PO's are finished the variance is cleared.
The Stock list – Stock on Hand Report from a stock list includes the below, whereas the Stock Value by GL Account report in Management Reports does not include:
•Consignment Stock (From a Consign In PO)
•Consignment Stock (From a Consign Buy PO), but only if these have not been sold.
Further information