What is the Stocktake Valuation and Update Program?

The stocktake valuation and update program provides the ability to confirm what new stock levels will look like and either commit or cancel the stocktake completely. You can view the stock levels through the valuation report and then use one of the update options to either commit or cancel the stocktake.

When should you use the Stocktake Valuation and Update Program?

This program should be used when you believe you have finished your stocktake and are ready to set the new stock levels or want to cancel the stocktake and unfreeze all frozen branches. You can also use this program to view what your stock levels will be once the stocktake has been committed.

Steps to use the Stocktake Valuation and Update Program.

1) Choose which branch you want you want to run the program for.

2) Select which option you want to run for the select branch.

- Valuation Report (see step 3)

- Update to Live Stock and Cleardown (see step 4)

- Remove Stocktake Without Updating (see step 5)

3) Choose cost type and Report output option.

4) Confirm update to current stock.

5) Cofirm removal of stocktake.

Choose which branch you want you want to run the program for

The first step is to choose which branch you are wanting to run either the valuation report, stocktake update or stocktake cancel for. The branches shown from the drop down will only include those that have been previously frozen.

Select which option you want to run for the select branch

Once the branch has been selected you will need to select which part of the program you want to run. You can either select the run the valuation report and see what the new stock levels will look like, update to live stock and commit the stocktake or remove the stocktake and unfreeze all frozen branches

Valuation report (Choose items with zero quantity, cost type and report output option)

If you choose that you want to run the Valuation report you will be presented with 3 options to set before being able to run report and see what the updated stock figures would look like.

Choose items with zero quantity

The first option is to set whether or not you wish to include items that have zero difference value set against them. If no is selected then the report will only show items that should have a new value set against them.

Choose the cost type in report

When running the Valuation report it is possible to choose how you want the cost price of each item to show. If you select “latest” the report will show whatever the latest set cost price is. If the
“average” option is selected, the system will check for any cost price the item has had and produce an average of the previous cost prices and the current.

The Valuation report has 2 different output formats (PDF, Excel csv). There is very little difference in the information that is outputted from the difference formats. However the excel format will not provide a total of the columns but the data the easier to check and/or amend.

Update to Live Stock and Cleardown (Confirm update to current stock)

If you have checked the Valuation report and are happy that the the new figures are correct, you are ready to commit the stocktake and you will need to run the “update to live stock and cleardown” section of this program. This will amend the stock levels, for the branch select, to the “new qty” value from the valuation report, as well as unfreeze the branch and remove any scanner files related to that branch.

To commit the stocktake you will need to click update. NOTE: as the program states, any updates cannot be undone

Remove Stocktake Without Updating (Confirm removal of stocktake)

This program also gives you the ability to cancel a stocktake completely (unfreeze the branch and remove scanner files linked to that branch) without updating the new stock levels. This should be used if a branch has a stocktake done against it but then it is decided that you no longer require this branch to be part of the stocktake.

To cancel the stocktake for a branch, you will need to click “remove.” As the system states, proceeding with this will remove all counts against the branch and unfreeze the branch, losing the freeze records against it.