Language:


Cost Price Analysis Revaluation

If the Cost Price of an Item changes, there may be circumstances where you need to change the value of the examples of that Item that you hold in stock. If so, you can use the 'Cost Price Analysis 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 where the Last Purchase Cost or the Weighted Average is different to the Cost Price. If there are any Items in which this is the case, it will then create a Stock Revaluation record containing those Items.

To use this function, ensure you are in the Stock module and then open the 'Maintenance' list by clicking (Windows/Mac OS X) or tapping (iOS/Android) the [Routines] button in the Navigation Centre and then the [Maintenance] button in the subsequent window. Double-click or tap 'Cost Price Analysis Revaluation' in the resulting 'Maintenance' list.

If you need to see a list of the Items that will be revalued, produce a Cost Price Analysis report before running this function. You can run this function from that report when it is printed to screen, by clicking (Windows/Mac OS X) or tapping (iOS/Android) the [Stock Revaluation] text link at the top of the report.

In both cases (from the 'Maintenance' list and from the Cost Price Analysis report), the specification window illustrated below will open. If you ran the function from the Cost Price Analysis report, the window will be filled in with the specifications that you used when running the report.

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 (:).

For an Item in the range to be included in the Stock Revaluation, it must meet the following requirements:
  • It must be a Stocked Item.

  • You must have at least one unit in stock.

  • Its Last Purchase Cost or the Weighted Average must be different to its Cost Price.
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.

%
By default, an Item will be included in the new Stock Revaluation record if its Last Purchase Cost or Weighted Average (as specified below) is different to its Cost Price. If you need this difference to be at least as much as a particular percentage of the Cost Price, enter that percentage here.

The sign of the difference will be ignored. For example, if you enter "10" in this field, an Item will be included in the Stock Revaluation if its Last Purchase Cost or the Weighted Average is 10% higher than its Cost Price or 10% lower than its Cost Price.

New Cost
In deciding whether an Item will be included in the new Stock Revaluation record, the function will compare its Last Purchase Cost (incl. extras), its Weighted Average or