Skip to main content

Counted location card

The counted location card shows one counting of one location and what the counter found. It opens when you click a row of the locations list. The form is inventory_count_location_tabbed (kind Tabbed). The data object is inventory_count_location_card. The card is loaded by inventory_count_task_card_get.

It has two tabs and two toolbar buttons.

Toolbar buttons​

ButtonEnabled whenWhat it doesTask page
Accept VarianceStatus is Variance (grey text Only a variance is accepted)Asks for the cause, then adjusts the stock to what was counted.Accepting a variance
RecountStatus is Variance and the count still allows a recount (grey text Only a variance with recounts left is recounted: the count allows no more)Sends the location to be counted again.Recounting a location

Messages: Accept Variance: success Location {location}: the variance is adjusted, failure The variance was not accepted: {error}. Recount: success Location {location} goes to be counted again, failure The location was not sent to recount: {error}. If the task or its version is not known: Reopen the location: its task is unknown, Reopen the location: its version is unknown. After success the card goes back and the count is read again.

Tab Location​

The form is inventory_count_location_card_form. Every field is read only.

LabelColumnTypeWhat it shows
LocationlocationTextThe location code.
StatusstatusTextOpen, Variance, Closed, Recounted or Cancelled.
Attemptattempt_noWhole number1 for the first count, then 2, 3.
DifferencesdifferencesWhole numberHow many stock identities did not match.
Counted Atcounted_atDate and timeWhen the counter finished.
Decided Atdecided_atDate and timeWhen the supervisor decided.
Confirmed Emptyempty_confirmedCheck boxOn when the counter said "nothing here".
Causevariance_causeTextWhy the count differed. Set by Accept Variance, or Within tolerance when it was accepted on its own.
Cause Commentvariance_commentTextThe supervisor's comment to the cause.

The fields ID, Version and Recount Allowed are hidden.

Tab Result Lines — every attempt, the latest first​

The form is inventory_count_location_results_list_form. The data object is inventory_count_result_line. It is read by inventory_count_location_results. It shows one line for each stock identity of every attempt of the location. Every column is read only.

LabelColumnTypeWhat it shows
Attemptattempt_noWhole numberThe attempt the line belongs to.
Attempt Statustask_statusTextThe status of that attempt.
SKUsku_codeTextThe SKU.
Ownerowner_codeTextThe owner code.
LotlotTextThe lot.
Expiresexpiration_dateDate, listed as textThe expiry date of the lot.
Manufacturedmanufactured_dateDate, listed as textThe manufacturing date of the lot.
Best Bybest_by_dateDate, listed as textThe best-by date of the lot.
Deliver Bydelivery_by_dateDate, listed as textThe deliver-by date of the lot.
Lot Attributeslot_attributesTextThe other attributes of the lot, as text.
LPNlpnTextThe container. Empty for loose stock.
UOMuomTextThe unit of measure.
Expectedexpected_qtyDecimalWhat the snapshot held (a soft count: snapshot plus the stock changes since).
Movedmovement_qtyDecimalThe part of Expected that came from stock changes after the snapshot. 0 for a hard count.
Countedobserved_qtyDecimalWhat the counter recorded.
DifferencedifferenceDecimalCounted − Expected. Stored by the database.
Resultresult_typeTextMatch, QtyVariance, ExpectedButMissing or UnexpectedFound.
Adjustmentadjustment_numberTextThe number of the adjustment that corrected the line. Empty until the variance is accepted.

The column Task (task_id) is hidden.

Result types​

ResultMeaning
MatchCounted equals expected.
QtyVarianceBoth exist, with different quantities.
ExpectedButMissingThe snapshot had this stock and the counter recorded none of it.
UnexpectedFoundThe counter recorded stock the snapshot did not have.

Sources: the tables in crates/libs/wms-lib-sql/sql/wms-app/migrations/056_a_count_observes_the_stock.sql:122-142, 060_a_counted_location_keeps_its_result_lines.sql, 073_a_count_may_let_stock_move.sql; the forms in crates/libs/wms-lib-sql/sql/wms-meta-ui/migrations/104_inventory_count_location_card.sql and 105_inventory_count_location_tabs.sql.

Not confirmed by code: how the dates Expires, Manufactured, Best By, Deliver By are written in the cells (their format). They are typed as text in the list. To verify: open the card of a location counted with a dated lot.

What it affects​

  • The buttons change stock only through the adjustment that Accept Variance posts.
  • When the count is Blind, the quantities of the snapshot are hidden from the counter while the location is open; the supervisor sees them here after it is counted.

Who can use it​

Reading: ADMIN, MANAGER, SUPERVISOR, VIEWER. The two buttons: ADMIN, MANAGER, SUPERVISOR. See Who can do what.