The lines of one count, with the difference

One page of the lines in a count. Each row is one variant at one location: system_quantity (the level snapshotted when the count was created), counted_quantity, variance and variance_value, with sku, product_title, variant_title, location_name and unit_cost for display.

counted_quantity, variance and variance_value are null on a line nobody has counted yet. That null is not a zero: a line counted at exactly system stock carries variance: 0, and the two are opposite statements about a shelf. line_scope narrows the page: differences returns only counted lines whose count differs from system (so it excludes the matched lines AND the uncounted ones), and uncounted returns only the lines nobody has counted, which is the work left to do on a count part way through. variance_only=true is the older spelling of line_scope=differences and still works.

unit_cost is null where no cost is on file, and a counted line with no cost is valued at zero, so variance_value: 0 beside a null unit_cost means not priced rather than no money at stake.

search matches product title and SKU. sort_args takes product_title, sku, location_name, system_quantity, counted_quantity, variance or variance_value, prefixed - for descending. limit defaults to 25. For variance measured across posted counts and attributed to a supplier rather than listed line by line, use get_stock_variance_by_supplier.

Scope: stocktakes:read.