Skip to main content

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.

LabelColumnTypeShown at firstWhat it shows
IDidWhole numberNoThe id of the counting (task).
LocationlocationText, up to 20 charactersYesThe location code.
StatusstatusTextYesOpen, Variance, Closed, Recounted, Cancelled. See below.
Attemptattempt_noWhole numberYes1 for the first count, 2 for the first recount, and so on.
DifferencesdifferencesWhole numberYesHow many stock identities in the location did not match. 0 until the location has been counted.
Emptyempty_confirmedYes or noYesYes when the counter said "nothing here".
Counted Atcounted_atDate and timeYesWhen the counter finished.
Decided Atdecided_atDate and timeYesWhen the supervisor decided the variance (accepted it or sent it to be recounted).
Adjustmentadjustment_idWhole numberYesThe id of the adjustment that corrected the variance. Empty when none.
Causevariance_causeTextYesWhy the count differed, in words of the list count_variance_cause. Within tolerance when it was accepted on its own. Empty until accepted.
Cause Commentvariance_commentTextYesThe supervisor's comment to the cause.
VersionversionWhole numberNoThe version of the counting. Sent by Accept Variance, Recount and Remove Location.
Recount Allowedrecount_allowedYes or noNoComputed: 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​

StatusMeaning
OpenThe location is waiting to be counted, or is being counted.
VarianceIt was counted and something differs from the snapshot. It waits for a decision.
ClosedIt matched, or the variance was accepted and adjusted. Final.
RecountedA supervisor sent it to be recounted. A new row with the next Attempt replaces it. Final for this row.
CancelledThe 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​

ButtonEnabled whenWhat it doesTask page
Add LocationsThe 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 LocationThe 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 VarianceThe ticked row is Variance (grey text Tick a location with a variance)Adjusts the stock to what was counted.Accepting a variance
RecountThe 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
RefreshAlwaysReads 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):

ButtonSuccessFailure
Remove Location{location} is no longer counted: it is released{location} stays in the count: {error}
Accept VarianceLocation {location}: the variance is adjustedThe variance of {location} was not accepted: {error}
RecountLocation {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 Hard count is frozen (flag CycleCountActive) from the moment it is added until it is Closed, Cancelled or removed. No movement, allocation, putaway or picking may touch it.
  • Each row of status Open is a task of type Count in Task Manager. It is withdrawn when the row is removed or the count is cancelled.
  • When no row is Open or Variance any 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.

  • Count header
  • Counted location card
  • Count statuses
  • API: inventory_count_list_tasks, inventory_count_remove_location (stateful, version of inventory_count_task), inventory_count_accept (stateful), inventory_count_recount (stateful)
  • RF terminal: Inventory > Count location (CNT00 takes the next location of the count).