Revalue stock

Find this screen

Open: Stock Control > Adjustments > Revalue Stock

How to

Revalue stock

Before you can revalue stock:

The stock level must be greater than zero.
You must have enabled Integrate stock management with the Nominal Ledger in the Stock Control Settings. See Integrate stock management with the Nominal Ledger.

Open: Stock Control > Adjustments > Revalue Stock

Select the Stock Item.
Enter the new buying price.

Note: This must always be greater than zero.
Specify the Nominal posting accounts.
1. Accept or amend the displayed Stock account.
  
  This shows the default stock nominal account for the item.
2. Enter the nominal account you want to use as the Revaluation Account.
3. Enter a Narrative description for the transaction (optional).
To revalue the stock item, click OK.

Useful info

About revaluing stock

There is published guidance regarding the presentation of the value of stock in accounts, such as FRS 102 (sometimes referred to as UK General Accounting Reporting Practices). Sometimes circumstances occur where the cost value of the stock is no longer valid and another value must be used. The revaluation process is designed to support the process of amending the value used for the entire stock of a single item. Use Revalue stock to show a decrease in the market value of all stock held for an item.

Stock items that use FIFO, average or actual cost have their value based upon their cost i.e. what was paid to the supplier, or what it cost to manufacture the item. Sage 200 creates an average buying price for the stock item. This is displayed when you choose to revalue an item. You can amend this to the price you want the item to be issued at, although the buying price must always be greater than zero.

Following revaluation all the stock held for the item processed will be valued at the cost specified during revaluation, including batches and serial number issues.

If you revalue items of actual cost, you will no longer have a record of the original cost of the stock item.

If you need to make a correction to the actual cost of a specific batch or serial item, if invoices prices were entered incorrectly, for example, do not use the Revalue stock option. Instead, write off the specific batch or serial number item and then add it into stock again at the correct price.

You cannot revalue the following:

Stock items that use the standard costing method.
Stock items that have a negative or zero stock level, such as when a stock item has been received but not confirmed or when there is a stock shortfall.
Stock items that are Phantom BOM built items.

Outcomes

When you specify a new price, the stock item is revalued as follows:

The entire holding of the stock item is assigned the new buying price.
The average cost of the stock item is set to the new buying price.
The buying history of the item is cleared.

You can still view individual receipts but you can no longer see the multiple buying prices.
The difference in the value of the stock is posted to the following two nominal accounts: the default stock nominal account for the item, and the Revaluation nominal account that you have specified. The transaction date is the current system date on your PC.

Be aware that when you revalue stock the average buying price is displayed for the revaluation, however, the difference that is posted to the nominal account depends on the stock item costing method.

If you are revaluing a stock item that uses average costing, then what is posted will be the difference between the current average stock price and the new stock price.

However, if you are revaluing a stock item that uses FIFO costing, then what is posted is the difference between the actual cost price of the item and the new price. For example, you have 2 stock items 'A' with prices of £100 and £200 entered in that order. The average buying price is calculated as £150 and displayed on the revaluation screen. If you write off one stock item, because it is using FIFO costing, the first stock item entered at £100 is written off. You now have one item in stock at £200 and the average buying price is still shown as £150. When you revalue the stock, if you now enter a new price for this item as £250, you might expect that the nominal posting would be £100 (the difference between the average buying price and the new price). However, because the stock item uses FIFO costing, the posting is actually £50 as this is the difference between the actual cost price of the remaining item (£200 and the new price entered at revaluation of £250).