Skip to the article

Other Actions in Stock Adjustments

Filtering, attaching, and reading the adjustment total as a number in its own right.

Adjustments are worth watching in aggregate, not just raising one at a time. The list is where that reading happens.

The Stock Adjustments list with columns for Date, Adjustment number, Reason, Description, Type, Warehouse, Status and Total Value, showing a mix of Quantity and Value adjustments across five depots, some Adjusted and some Draft, with total values ranging from a 6,372.69 write-down to a 5,429.00 opening balance.
Sort by Total Value and the expensive ones come first, which is rarely the same as the recent ones.

On the list

ActionWhat it does
Filter by reasonSeparates a count discrepancy from breakage, which are different problems
Filter by warehouseNarrows to one depot, where a pattern usually belongs
Filter by typeQuantity changes against value write-downs
Filter by statusDrafts are adjustments nobody has applied yet
Sort by total valuePuts the expensive ones first
ExportTakes the filtered list out as a file

On one adjustment

ActionWhen it is available
ViewAlways. An applied adjustment is a record
Attach a documentAlways. The stocktake sheet belongs here
EditOnly while it is a draft
DeleteOnly while it is a draft

Reading the total

The Stock Movement report filtered to adjustments is a good monthly read, and it answers a question no single document does: what is this costing us.

A rising total
Usually a process problem rather than bad luck. Goods leaving undocumented, receives entered short, or a unit of measure nobody agrees on.
One item, repeatedly
Worth investigating before the next stocktake rather than after it.
A large one-off
Should have a description explaining it. If it does not, that is the finding.

Was this document helpful?