We currently run Sage 200 in the "old-school" on-premise version.
As part of our financial year end routine we thoroguhly review our entire stock file and make a large number of stock revaluations on a SKU by SKU basis.
In the first instance we export the stock file into Excel and calculate the write-downs on a line by line basis. For individual SKUs I have noticed that there are often unexplained differences of varying magnitudes between the implied write-down value (shown in the spreadsheet) and the actual write-down entry that is made in the Nominal Ledger.
The differences do not arise as a result of us failing to recognise numbers of the same SKU held in multiple warehouses (Sage 200 cannot make discrete adjustments between SKUs in different warehouses - if a SKU is revalued, all units are revalued regardless of which warehouse the SKU is held in).
In my opinion the revalue stock function is simplistic and as far as I know there little in the way of a detailed audit trail to explain the make-up of the entries that are made in the Nominal Ledger as a result of revaluing stock.
Has anybody experienced these differences or can anybody offer an insight or guidance?
Thanks very much