Language:


Aged Stock Revaluation

This page describes the 'Aged Stock Revaluation' Maintenance function in the Stock module.

---

If you have held some Items in stock for a long time, there may be circumstances where you need to change the value of that stock. If so, you can use the 'Aged Stock Revaluation' Maintenance function to create a record in the Stock Revaluation register that you can then use to implement the change in value.

The function will search for Stocked Items that you currently have in stock and will then create a Stock Revaluation record containing those Items. If you have stock of an Item in more than one Location, separate rows for each Location will be included in the new Stock Revaluation record.

To use this function, ensure you are in the Stock module and then open the 'Maintenance' list by clicking (Windows/macOS) or tapping (iOS/Android) the [Routines] button in the Home Screen and then the [Maintenance] button in the subsequent window. Double-click or tap 'Aged Stock Revaluation' in the resulting 'Maintenance' list. The specification window illustrated below will open:


Item No.
Paste Special    Item register
Range Reporting    Alpha
If you need a particular Item to be included in the new Stock Revaluation record, enter its Item Number here. You can also enter a range of Item Numbers separated by a colon (:).Only Stocked Items in the range will be included in the Stock Revaluation, not Plain, Structured or Service Items.

Group
Paste Special    Item Group register, Sales Ledger
If you need Items belonging to a particular Item Group to be included in the new Stock Revaluation record, specify that Item Group here.

New Cost
The function will place a suggested New Cost for each Item in the new Stock Revaluation record. Use these options to suggest whether the suggested New Cost of each Item should be its Last Purchase Cost (incl. extras), its Weighted Average or its Last Purchase Cost (excl. extras).
Click (Windows/macOS) or tap (iOS/Android) the [Run] button in the Button Bar to run the function. When it has finished, you will be returned to the 'Maintenance' list window. The function will create as many records in the Stock Revaluation register as necessary (each record will contain a maximum of 200 rows). The new Stock Revaluations will not have been marked as OK. To change the values of the Items held in stock, change any New Costs as necessary, mark the record as OK and save. You can also remove rows containing Items that you do not want to revalue. The stock values and Item History of the Items in question will be updated, and, depending on configuration, a Nominal Ledger Transaction will be created to update the stock valuation in the Nominal Ledger. Please refer here for full details about Stock Revaluations.

If the function does not create a Stock Revaluation when expected, the probable cause is that there is no valid record in the Number Series - Stock Revaluations setting. This problem will usually occur at the beginning of a new year.

---

Go back to: