[SAM] How to modify the Last cost or Average cost of a stocked Item

This article goes through the process of changing the Average Cost and/or the Last Cost for a stocked item.

 

View the Stock Item

Adjust the stock to zero

Change the Cost figures

Adjust on-hand back to correct levels

 

The On Hand figure must be zero to change the Average Cost and/or Last Cost 

This will have have an impact on your stock valuations and may affect your GL reports  

 


KB_SAM_Arrow up

To view the stock item

1. Select Maintenance > Stock

a) Highlight the correct stock item and click on Change.

Stock 1


KB_SAM_Arrow up

Adjust the stock to zero

2. Select Adjustment.

In this example we will need to decrease the on-hand figure by one

Stock 2

 

a) AD+ will INCREASE your On Hand quantity

b) AD- will DECREASE your On Hand quantity (which is what we will use).

c) Select OK to Save the stock Adjustment change then OK to save the change to the stock file.

stock 3

You will need to close and re-open the Maintain Stock window 


KB_SAM_Arrow up

Adjust the Average and/or Last cost figures

 

Re-opening the stocked item will show that the Average and Last cost will no longer be greyed out and are now available to adjust 

 

3. Enter in the correct cost prices then click OK to save your changes.

stock 5


KB_SAM_Arrow up

Adjust the required stock back on

Physically check for the number of items you actually have on the shelf.

Make sure that the correct cost is entered. 

 

4. You will then need to do another Adjustment to adjust the stock back on.

stock 6

SAM will now recalculate your stock value based on your new on hand quantity and cost price.

 

Didn’t find what you were looking for?

Our Support team are here to help, you can reach us by submitting a support ticket

or calling us on 09 583 2451