How To Perform a Cycle Count
Count a selection of parts on the shelf, enter what you found, and let Cetec correct the stock, with a reason code for every change.Updated Nov 9 2026
Before you start
- Cycle Count is under Warehouse and needs the Warehouse role.
- Every counted row needs a Reason Code. The codes come from the InvShortageReason table (see Add a reason code).
- Each row you set changes the stock at once. Closing the count only finishes it.
-
Create the cycle count
- Go to Warehouse > Cycle Count > Cycle Count List. The list is headed Cycle Count and shows open counts (Status filter Open).
- Click Create New at the top of the page. The Create New Cycle Count window opens.
- Pick the Location (warehouse) to count.
- Choose how parts are picked in Selection Method:
- System Generated: Cetec picks the parts. Set Number of Parts (default 20) and narrow them with ABC Code, Prcpart (parts like this one), Min Value (per part or total, in Min value applies to), Bins Like or Commodity Code.
- User Generated: pick the parts yourself in Prcpart (the search takes a moment to show results).
- To stop anyone changing the stock while you count, set Lock Inventory Transactions? to Lock Warehouse or Lock Bins; leave Do not Lock Inventory otherwise. Cetec unlocks it when the count is closed.
- Click Create. The count opens, headed Cycle Count number, with how many bins and parts to count and one row per part and bin.
-
Enter the counts
On the cycle count, pick the counter in Assigned To and click Assign if someone else is counting (the list of counts shows who it is assigned to). Print All prints count sheets.
Count each bin and type the number in Actual Shelf Qty. Count only what is on the shelf; stock picked to orders is shown separately in WIP QTY, and Shelf Qty is what Cetec expects. Type a number in every row you set, even when it matches Shelf Qty.
Pick a Reason Code for the row. To use one code for every row, pick it in the box under the Reason Code heading.
Click Set on the row. Cetec shows Count set for part in bin., greys the row out and fills Last Updated. To set every row that has a quantity and reason, click Set All (n) instead and confirm Set count for n selected rows? (rows already set are set again).
To see what is left, set View Rows with Status to Not Updated and click Submit next to the filters.
-
Close the count
- On the cycle count, set View Rows with Status to Not Updated and click Submit to see which rows you haven't set. You can close with rows still not updated: Cetec leaves those bins' quantities unchanged.
- Click Close and confirm Are you sure you want to close this cycle count? Cetec closes the count, unlocks the warehouse or bins, and goes back to the Cycle Count list.
- To find it later, on Warehouse > Cycle Count > Cycle Count List click the filter search bar, pick Status, choose Closed (and Location if needed), and click Apply (1). Click the ID to open it; a closed count opens on the classic page, headed Cycle Count n -- CLOSED, with Qty Expected, Delta and Qty Set To for each row. Reopen on a closed count lets you correct it.
-
Add a reason code
- Go to Admin > Maintenance > Data Maintenance, filter Data Type for
InvShortageReason, (type it and press Enter), click Apply (1), and click it. The page Data Maintenance For InvShortageReason opens. - Click Add Record. Cetec saves an empty row at once.
- Fill in the row's Name and Description, leave Active set to Active so the code can be picked, and tick No Inv Change if the code means the count found no change.
- Click Submit.
- Reload the cycle count page; the new code is in Reason Code.
- Go to Admin > Maintenance > Data Maintenance, filter Data Type for