Quantity Adjustment

Use this form to enter a transaction to adjust the quantity of an item stored at a given location.

You cannot adjust the quantity of a lot-tracked or serial number-tracked item.

The stockroom location must exist for this item. An inventory cost adjustment transaction is also posted. Unless the On Hand Neg Flag in the Inventory Parameters is selected, the On Hand cannot be set to less than zero. If the flag is selected, a warning is issued indicating that the On Hand will be negative.

If the Warehouse, Location, or Lot fields change, the grid on the Pieces tab automatically refreshes to retrieve the corresponding records.

The system adjusts the stock balance on hand. A material transaction is created by this adjustment with a transaction type of Adjustment.

Note:  The quantity adjusted cannot be adjusted less than the quantity reserved (for customer orders) for the item location.

The adjust transaction creates records in the IC Dist Journal in the General Ledger. The quantity adjusted (the difference between the old quantity and the new quantity) is multiplied by the unit cost. If Actual costing is specified in the System Parameters, these costs are used for the different cost flow methods:

  • Average Costing - the Items form, Unit Cost field
  • Specific Costing - cost at the location being adjusted
  • LIFO/FIFO Costing - cost of the last record in the stack

If Standard costing is specified in the System Parameters form, the Standard costing unit cost is used.

To select a different warehouse to use for this form, select Change Warehouse from the Actions menu.