What is the Stocktake Analysis Printing Program?

This program is used so that it is possible to analyse what items or departments have been frozen, what has been counted and which bin locations have been counted. It also provides that ability to see if there are any discrepencies between what has been frozen and what has been counted.

When should you use the Stocktake Analysis Printing Program?

The analysis printing program should be used whenever you wish to check if an item or department has been frozen, if the amount you have counted is the same as the amount that was frozen, or if you are wanting to check if certain bin locations have been counted.

Steps to use the Stocktake Analysis Printing Program.

There are multiple reports that can be ran from this report, most of the steps are the same but there may be slight difference so please ensure you follow the steps for the report you are running.

Freeze Report:

1. Select if you want to run the report for a specific branch.

2. Choose if you want to consolidate branches.

3. Choose whether to include items with a zero frozen quantity.

4. Choose if you want to run the report for a specific department.

5. Filter by Stock item keyword (optional)

Discrepency report:

- Select if you want to run the report for a specific branch.

- Choose if you want to consolidate branches.

- Choose whether to include items with zero counted quantities.

- Choose whether to print scanner details.

- Select which cost price is shown againt product.

- Choose if you want to run the report for a specific department.

- Filter by Stock item keyword (optional)

- Choose how you want the report to be presented to you (Output Option)

Location Summary:

1. Choose which branch you want to run the report for.

2. Choose whether to include items with zero counted quantities.

Freeze Report

Select if you want to run the report for a specific branch

The first drop down for both the Freeze report and the Discrepency report will default to “all” branches. You can either keep the report set to this or choose from one of the other branches. Please note that the drop down will only show branches that are frozen.

Choose if you want to consolidate branches

If you select to run the report for all branches you will be given the option to consolidate the branches so that you only receive 1 amount per item. You can use this option if you are wanting to see the frozen amount for all branches and not have to calculate the total value manually.

Choose whether to include items with zero frozen quantity

For the freeze report it is also possible to show items that currently have no frozen quantity against them, therefore showing that you either don’t have any in stock and therefore shouldn’t have a counted value on the Discrepency report. The quantity may also not have been added to stock yet and therefore will be corrected once the stocktake is complete.

Choose if you want to run the report for a specific department

The department drop down for this report as default is set to “all” departments. If you are only wanting to run the report for a specific department then you can select one from this drop down. 

Filter by Stock item keyword (optional)

If you only want to see the frozen levels for certain products you can filter items by keywords and only items that match these keywords will be shown on the freeze report.

Discrepancy report

Select if you want to run the report for a specific branch

The first drop down for both the Freeze report and the Discrepency report will default to “all” branches. You can either keep the report set to this or choose from one of the other branches. Please note that the drop down will only show branches that are frozen.

Choose if you want to consolidate branches

If you select to run the report for all branches you will be given the option to consolidate the branches so that you only receive 1 amount per item. You can use this option if you are wanting to see the frozen amount for all branches and not have to calculate the total value manually.

Choose whether to include items with zero difference quantity

When running a discrepency report it is also possible to only show products that have a difference (the counted value is either more or less than the frozen value). This is done by setting the “include items with zero quanity” field to no.

If this is set to yes then the report will also show those products that have no difference value (the counted and frozen values are the same).

Print Scanner Details

If you are using scanners to perform you stocktake then you can set this option to “yes” and this will provide details under each item as to how many were counted as well as which bin location they were counted from and which scanner was used to count that quantity.

Select which cost price is shown againt product

When running the Discrepency 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.

Choose if you want to run the report for a specific department

The department drop down for this report as default is set to “all” departments. If you are only wanting to run the report for a specific department then you can select one from this drop down.

Filter by Stock item keyword (optional)

If you only want to see the frozen levels for certain products you can filter items by keywords and only items that match these keywords will show on the freeze report.

Select the output option of the report

The stocktake discrepency 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.

Location Summary

Choose which branch you want to run the report for

Unlike the freeze and discrepancy report, for the location summary you have to select a branch as not all branches may have the same bin locations, therefore it is not possible for the system to run the bin locations for branches at one time. The list of branches available will be the same as for the other reports (only the branches that have been frozen).

Choose if you want items with Zero counted quantity