Checking stock refers to the process of reviewing the current inventory or availability of products, goods, or materials in a store, warehouse, or business. This can involve counting physical items, reviewing digital records, or verifying stock levels in a system. The goal is to ensure that there are enough items on hand to meet demand, identify any shortages, or assess whether restocking is necessary.
This tutorial will show you how to view and adjust stock counts. It will also show you how to import, export and print stock-count transactions.
Navigation: Main Menu > Items > Stock Check
Table of Contents
Navigate to Main Menu > Items > Items.
Double-click to open the Item you want to perform the Stock Check on.
In the header information, check the checkbox next to Inventory.
Navigate to Inventory (tab) and add a Location.
Navigate to Units (tab) and tick the block under Stock Check for every unit you want to permit a stock check on.
Note: If the Inventory or Unit tabs are not displayed, click Menu (button) > Set Tabs and click the tabs on the dropdown list.
Navigate to Stock Check.
Adjust the filters as needed.
Click View (button).
Click New (button).
On the popup:
Select a Category or leave the default All.
Select a Location or leave the default All.
Click or unclick Active Items (only active items will be displayed if there is a checkmark).
Click View (button).
Select the Entries to import (use ctrl + left click to multi-select).
Adjust the Stock Check Date if necessary (defaults to yesterday and must be a prior date).
Click Create (button).
The new entries will be created with a Pending Status.
Type in a new Quantity in the Count Qty column (if applicable).
Note: While the transaction still has a Pending Status, you can freely change the amount in the County Qty column.
Change the Status from Pending to Complete (if applicable).
Note: You need Full Control under Settings > Users > Stock Check Access Allowed to change the Status of the transaction.
Click Save (button).
Navigate to Stock Check.
Apply the Filters so that only the items you want stock count sheets for are displayed.
Click View (button).
Click Output (button).
Navigate to Stock Check.
Click Menu (button) >
Email Excel to open your default email template with the current view attached as a .xlsx file, or
Export Grid to choose a save location for the .xlsx file on the server.
ℹ️ The following fields are created in the .csv file: CHECKDATE, ITEMID, LOCID, CATEGORY, DESCRIPTION, CODE, REFERENCE, LOCATION, UNIT, QTY
The fields highlighted in blue are used to import the records.
The CHECKDATE field must be in the format dd/mm/yyyy.
Navigate to Stock Check.
Click Actions (button) > Export (.CSV).
On the popup:
Select a Date.
Click the block Base Unit to show the Base Unit (Inventory Unit) of all the stock records.
Click the Categories to exclude (by default, they are all included).
Click the Locations to exclude (by default, they are all included).
Click Export (button):
Choose a save location on your local or cloud server for the .csv file.
Click Save (button).
Files can only be imported if they are in the same format and contain all the columns as the Export file. (See above)
After selecting the file to be imported, each line will be processed as follows.
▶ Check if an Inventory record exists for the selected Item and Location and create one if it does not exist.
▶ Check if a Stock Check record exists for the selected Date, Item, Location and Unit and create one if it does not exist.
▶ Update the quantity (Qty) in the Stock Check record.
▶ The Category, Description, Code, Reference and Location fields are there to make it easy for users to populate the file - these fields are not required for the import.
Navigate to Stock Check.
Click Actions (button) > Import (.CSV).
Navigate to the file on your local or cloud server to import and click Open (button).
Display a list of Stock Check transactions.
Select the Transactions to change (use ctrl + left click to multi-select).
Click Actions (button) > Batch Update.
Select Status from the dropdown list next to Batch Update and select the new status (Pending or Complete) in the dropdown list of Statuses next to it.
Click Update (button).
Confirm the Status change on the pop-up.
Display a list of Stock Check transactions.
Select the Transactions to delete (use ctrl + left click to multi-select).
Note: Only records with the Status Pending or Complete can be deleted. (Records with the Status Opening Balance cannot be deleted.)
Click Delete (button).
Confirm the deletion on the popup.
Display a list of Stock Check transactions.
Right-click the applicable transaction and select View/Edit Note from the context menu.
Type in a Note in the block provided.
Click Save (button).
Display a list of Stock Check transactions.
Click Menu (button) > Show Notes.
Note: If there is a checkmark, Notes will be shown below the record. If there is no checkmark, the notes will be suppressed.
ℹ️ All the usual Filters are available (e.g. the soft-filter icon next to each column heading). This function is an additional quick-sort option.
Display a list of Stock Check transactions.
Click the arrow on the dropdown list next to Sort on: and select Description, Code, Bin No., or Sub Category.
ℹ️ This feature only works on Stock Check transactions with a Pending Status. Although it will ask to confirm resetting the Count Quantity on Stock Check transactions with other Statuses, it will not change anything.
Display a list of Stock Check transactions.
Select the Pending transactions to change.
Click Actions (button) > Zero the Count Qty.
Confirm that the Count Quantity will be changed to zero.
Display a list of Stock Check transactions.
Select the records with a Pending Status to change.
Click Actions (button) > Update Stock Check/s.
Confirm the update on the popup.
Display a list of Stock Check transactions.
Right-click any transaction on the list and select an option from the context menu:
Open Item: Replaces the current view with the item's setup screen.
Open Item Dashboard: Replaces the current view with a list of all the item's transactions and prices
Open Item Summary: Opens a summary of the item's details on the right including some setup information and transactions
View Inventory (Alerts): Opens a summary of the item's details on the right showing Inventory Transactions (tab) to display any alerts.
Note: You can also click the Alerts checkbox (on the 2nd row from the top), to show or hide alerts.