Count locations
The locations list is the bottom part of the count document. It has one row for each counting of a location. A location that is recounted gets a second row for the second attempt.
The form is inventory_count_task_list_form. The data object is inventory_count_task_row, over the table inventory_count_task. The list is read by inventory_count_list_tasks.
A click on a row opens the counted location card in the same place (TargetForm to inventory_count_location_tabbed, slot slot_2).
Columns
All columns are read only.
| Label | Column | Type | Shown at first | What it shows |
|---|---|---|---|---|
ID | id | Whole number | No | The id of the counting (task). |
Location | location | Text, up to 20 characters | Yes | The location code. |
Status | status | Text | Yes | Open, Variance, Closed, Recounted, Cancelled. See below. |
Attempt | attempt_no | Whole number | Yes | 1 for the first count, 2 for the first recount, and so on. |
Differences | differences | Whole number | Yes | How many stock identities in the location did not match. 0 until the location has been counted. |
Empty | empty_confirmed | Yes or no | Yes | Yes when the counter said "nothing here". |
Counted At | counted_at | Date and time | Yes | When the counter finished. |
Decided At | decided_at | Date and time | Yes | When the supervisor decided the variance (accepted it or sent it to be recounted). |
Adjustment | adjustment_id | Whole number | Yes | The id of the adjustment that corrected the variance. Empty when none. |
Cause | variance_cause | Text | Yes | Why the count differed, in words of the list count_variance_cause. Within tolerance when it was accepted on its own. Empty until accepted. |
Cause Comment | variance_comment | Text | Yes | The supervisor's comment to the cause. |
Version | version | Whole number | No | The version of the counting. Sent by Accept Variance, Recount and Remove Location. |
Recount Allowed | recount_allowed | Yes or no | No | Computed: yes while Attempt is not above Recounts per Location. |
Sources: the table in crates/libs/wms-lib-sql/sql/wms-app/migrations/056_a_count_observes_the_stock.sql:62-92; the rows in crates/libs/wms-inventory/src/service/inventory_count/read.rs:63-127.
Location statuses
| Status | Meaning |
|---|---|
Open | The location is waiting to be counted, or is being counted. |
Variance | It was counted and something differs from the snapshot. It waits for a decision. |
Closed | It matched, or the variance was accepted and adjusted. Final. |
Recounted | A supervisor sent it to be recounted. A new row with the next Attempt replaces it. Final for this row. |
Cancelled | The count was cancelled before the location was decided. Final. |
A location can hold only one live row (Open or Variance) at a time, in the whole warehouse (unique index uq_inventory_count_task_live_location). A second count cannot take a location that is still being counted by another.
Toolbar buttons
| Button | Enabled when | What it does | Task page |
|---|---|---|---|
Add Locations | The count is Open (grey text Save the count first; a closed or cancelled count takes no more locations) | Opens the Add Locations window. | Adding locations to a count |
Remove Location | The ticked row is Open (grey text Tick a location that is still to be counted) | Takes the location off the count and thaws it. | Removing a location from a count |
Accept Variance | The ticked row is Variance (grey text Tick a location with a variance) | Adjusts the stock to what was counted. | Accepting a variance |
Recount | The ticked row is Variance and Recount Allowed is on (grey text Tick a location with a variance and recounts left: the count allows no more) | Sends the location to be counted again. | Recounting a location |
Refresh | Always | Reads the list again. |
Messages of the buttons (command bindings in crates/libs/wms-lib-sql/sql/wms-meta-ui/migrations/093_inventory_count_screens.sql and later):
| Button | Success | Failure |
|---|---|---|
Remove Location | {location} is no longer counted: it is released | {location} stays in the count: {error} |
Accept Variance | Location {location}: the variance is adjusted | The variance of {location} was not accepted: {error} |
Recount | Location {location} goes to be counted again | {location} was not sent to recount: {error} |
For all three: no row ticked: Tick one location; the list changed: The locations have moved on — tick the location again and retry; version unknown: Tick the location again: its version is unknown.
What it affects
- A location of a
Hardcount is frozen (flagCycleCountActive) from the moment it is added until it isClosed,Cancelledor removed. No movement, allocation, putaway or picking may touch it. - Each row of status
Openis a task of typeCountin Task Manager. It is withdrawn when the row is removed or the count is cancelled. - When no row is
OpenorVarianceany more, the count closes by itself.
Who can use it
Reading: ADMIN, MANAGER, SUPERVISOR, VIEWER. The four buttons: ADMIN, MANAGER, SUPERVISOR. See Who can do what.
Related pages
- Count header
- Counted location card
- Count statuses
- API:
inventory_count_list_tasks,inventory_count_remove_location(stateful, version ofinventory_count_task),inventory_count_accept(stateful),inventory_count_recount(stateful) - RF terminal:
Inventory > Count location(CNT00takes the next location of the count).