Inventory adjustment change the quantity and value of inventory without entering a purchase order.
Key differences between inventory adjustment form and inventory adjustment worksheet-
- Inventory adjustment is inclusive of previous stock and adds to the previous stock.
- Inventory worksheet is exclusive of previous stock. It resets inventory count to the date of the worksheet regardless of the previous stock.
- For serialized and lot numbered items inventory adjustment form can only be used.
- In inventory adjustment, inventory count wont’s be changed in the future due to transactions entered prior to the inventory count date.
Navigation to create inventory adjustment and inventory worksheet –
- Inventory adjustment – transaction > inventory > adjust inventory.
- Inventory adjustment worksheet – transaction>inventory>adjust inventory worksheet.
CSV import of inventory adjustment and inventory adjustment worksheet-
Inventory adjustment –
- Set up> import/export> import csv records.
- Choose import type – transaction and record type – inventory adjustment.

Inventory adjustment worksheet –
Transaction > inventory > adjust inventory worksheet > import.
