Stock Adjustments

Stock adjustments allow you to manually manipulate the stock levels of any inventory item within the database. There are a few different ways to adjust stock:

Mass Adjustments

Updating the inventory of multiple products at the same time is done by navigating to the main Stock Adjustments page within the inventory tab.

Single Adjustments (without batches)

Single adjustments can be performed in one of two ways, the first being the Mass Adjustment method above.

The second method is to locate the item in either the Inventory List (for items with no batches) or the Detailed Inventory List (for items with batches).

Pressing the adjustment button from the inventory list will open the adjustment modal.

• First choose the location you would like to adjust the stock level for - this will update the quantity box, on the left will be the current stock level, on the right will be the new stock level.
• Enter a positive number to increase the stock or a negative number to decrease the stock.
• Press Save and the stock will be adjusted throughout the system.

When adding stock (positive) the Unit Cost input will be editable, by default the MAC (Moving Average Cost) is used. If you would like to add stock with a different price simply change the unit cost value.

When deducting stock (negative) the Unit cost input is disabled.

Single Adjustments (with batches)

Pressing the adjustment button from the detailed inventory list will open the adjustment modal.

• When adjusting a batched item, the location is already set, instead a batch drop down appears, which will default to whichever batch record you selected.
• The quantity box will be pre-loaded with the before (on the left) and the after (on the right) figures.
• Enter a positive number to increase the stock or a negative number to decrease the stock.
• Press Save and the stock will be adjusted throughout the system.

When adjusting a batch there is no unit cost input, the unit cost from the existing items in the batch is applied.

Zero down inventory with negative stock

When an item's stock goes below zero, an Oversell record is created in the inventory database. Usually oversell records will be removed with valid stock when a purchase order is received or a manufacturing schedule is completed.

Oversold stock items that are supposed to have batches will be created without a batch number. This would normally be replaced with a valid batch number from incoming stock.

If you need to zero down an oversold stock item without a batch you will need to click the + icon next to the batch number drop down in the stock adjustment and create a new dummy batch number and expiry.