Inventory adjustment and inventory worksheet.

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.

Leave a comment

Your email address will not be published. Required fields are marked *