Skip to main content

Inventory Count

Report displays a list of items which show what quantity is on hand currently and a space where the person counting can indicate the quantity actually counted.

Generally a count is done without giving what the quantity is on hand, however if you want to see the quantity on hand, remove the tick off the option called "Ignore system quantity"

Inventory module> Reports> Reports List

image.png

Code from / To

Select the from item in your list, this looks at the code in order to determine the from and to.

Warehouse If you select all warehouses the report will fetch data from all warehouses.
If you want to search by a specific warehouse, select the warehouse from the menu.
WIP (Work in progress)

Run the count for working progress items, On Shelf, All, Invoice, Sales Orders, Jobs and Bill of Materials.

Most counts are done on the on-shelf option

Sort by Select a sort by option by Code, Description, Group Code or Bin Location
Sub sort by Select a sub sort by Code, Description, Group Code or Bin Location
Priority level Count based on the Priority level of marked items
Disable bin range

Disable bin range is on by default which means the order is by code.

Enable this which allows you to print count by bin location from and to

Bin location from / To Select which bin to print from and to 
Show inactive Show inactive items on printout (Default option is off)
Group selection

Print a selected group selection of your group codes

This is defined in the group code setup which allows you to count for specific groups automatically

Ignore system Qty

This option is on by default to ignore the system quantity on report.

if you want the system on hand value, remove the tick

Decimal places It is advisable to set decimals to two places.
You can View the report with any number of decimal places.
Ignore if quantity zero
Use group codes

Double click on the code from the list to move the group codes you wish to filter your report by to the selected window.

Available group codes Displays a list of available group codes
Selected group codes Shows the list of selected group codes for the report
Show barcode Show the barcode on the printout
Batch number Display the batch number of the stock item
Expiry Date Display the default expiry date of the item


Print count with on hand quantity

To print the report with the displayed on-hand quantity, remove the tick for "Ignore system quantity" on the criteria

image.png

Report with count, showing on hand quantity

image.png