Inventory Adjustment
The stock correction. Each line names an item, a movement that says whether stock goes up or down, a reason, and the quantity. Save corrects the stock and posts its value. This is also where opening stock is brought in.
What it is for
Stock that the system holds and the shelf holds differ. The adjustment brings the system in line and charges or credits the difference to the account the movement's posting profile names.
The one rule people get wrong: the movement is chosen on each line, not on the header. One adjustment can add some items and remove others. The DCInd column shows which way each line goes.
An adjustment cannot be edited or deleted after Save. Reverse it.
Every field in plain words
Header
| Field | What it means | What to put |
|---|---|---|
| Transaction | The adjustment number | Given on Create |
| Posting Date | The date of the correction | In an open inventory period. How far back is allowed is set on the journal |
| Transaction Journal | The journal | Decides which movements the lines may use |
| Site, Warehouse | Default for new lines | Each new line starts with them |
| Notes | Free text |
Lines
| Field | What it means | What to put |
|---|---|---|
| Movement | Which kind of correction | Required. An adjustment movement: Debit adds stock, Credit removes it |
| Reason | Why | Required when the movement has Reason Required |
| Special Indicator | Optional | Shown when switched on in the company settings |
| Item No, Item Variant, Name | The item | |
| Stock Category, Stock Status | Optional | Shown per the company settings |
| Site, Warehouse, Storage Location | Where | From the header, changeable per line |
| Movement Unit, Movement Quantity | How much | More than zero. Rounded to the unit's precision as you type |
| DCInd | Up or down | Read only, from the movement |
| Cost Price | The unit cost | Filled with the item's average cost when the item or unit is picked. Editable only on lines that add stock; lines that remove stock leave at average cost |
| Catch Weight Quantity | The weight of a catch-weight item | Required for such items, within its minimum and maximum |
| Batch/Serial Number, Batch Date, Batch Expiry Date | The batch | On a line that adds stock, the new batch and its dates. On a line that removes stock, the batch to take, or empty to let the system choose |
| Line Text | Free text |
What happens on Save
- Lines that add stock come in at the Cost Price typed (a moving-average item refuses a zero price; a standard-cost item with no price takes its standard cost). Lines that remove stock leave at the average cost of the posting date.
- Lines that remove stock are refused if the stock is not there on the posting date, unless the item allows negative stock.
- The voucher posts each line between the inventory account and the account the posting profile gives for that movement.
How to configure it
- Make one adjustment movement per kind of difference you want to see separately in the accounts, each with Reason Required where a reason matters.
- For opening stock, use an adjustment movement whose offset account is the opening balance account, and date the adjustment the day before go-live.
Scenarios
- Monthly count in a supermarket. One adjustment per store: shortages on a Credit movement, surpluses on a Debit movement, each with its reason.
- Go-live. One adjustment per warehouse with every item's quantity, batch and cost.
What it is connected to
- Movement - the line's movement and its reason rule.
- Adjustment Request - the same lines as a request, which posts nothing.
- Inventory Movement - the other way to move stock against an account.
If something looks wrong
- "Line ID: ... Movement cannot be emtpy" - each line needs a movement.
- "Line ID: ... - Reason is mandatory for Movement: ..."
- "Line ID: ... - Catch Weight Unit cannot be empty" / "... Catch Weight Quantity cannot be zero" / "... cannot be less than ..." / "... cannot be greater than ..."
- "Basic Data - Line ID : ... - Price cannot be zero" - a line that adds stock has no cost.
- "Basic Data - Item (...) ... - Stock not available : Quantity cannot be greater than available Quantity ..."
- "Inventory is Closed of this Period"