Inventory Quantity Adjustment

To correct the quantity of stock items in inventory, perform an Inventory Adjustment transaction.

NOTE: If lot or serial class tracking is enabled, the adjustment process will vary slightly.  See steps below.

Correct Stock Item Quantities (NO lot/serial tracking)

1.  Determine the quantity change for the Inventory Adjustment
   1. Use the Inventory Summary screen to identify the current On Hand quantity, then calculate the necessary adjustment using the actual physical count.
   2. Formula:  Actual Qty in stock – System On Hand Qty = Adjustment Quantity
   3. Example:
      • Actual Qty in warehouse: 62,400 LB
      • On Hand quantity in Acumatica: 62,000 LB
      • Adjustment needed: +400 LB
      • In this case, enter a positive adjustment of 400 LB to reflect the physical stock count.

2. Create the Inventory Adjustment
   1. Open New Inventory Adjustment
   2. Enter Inventory ID
      1. In the Details tab, add a new line or select ADD ITEMS
      2. Select the appropriate Inventory ID for the item being adjusted.
   3. Enter Warehouse and Location
   4. Enter Quantity calculated in Step 1
      1. Use a positive value to increase inventory.
      2. Use a negative value to decrease inventory.
   5. The system automatically pulls the current unit cost and calculates the Extended Cost based on the quantity entered.
   6. Set the Extended Cost to $0.00. 

NOTE: If you need to adjust the quantity and the value you will need two separate transactions, first to adjust quantity, then value.  Contact Support for assistance with these transactions.

3. Release the inventory adjustment
   1. The system will:
      1. Update the item’s On Hand quantity in inventory.
      2. Create necessary GL and inventory transactions (if applicable). NOTE: Once released, the inventory adjustment is finalized and cannot be edited. Any further corrections will require a new adjustment transaction.
4. Verify the updated quantity in the Inventory Summary
   1. Refresh the Inventory Summary report.
   2. Confirm the new quantity.
      1. The On Hand Quantity should now reflect the adjustment made.

Correct Stock Item Quantities with Lot/Serial Tracking

 If a stock item is tracked by lot or serial number, the unit cost MUST be corrected individually for each lot/serial number.

When performing an inventory adjustment:

• Enter the applicable lot or serial number for each line item.
• Ensure the unit cost is specified for each lot or serial number, as cost is tracked at that level in the system.

1.  Determine the quantity change for each Lot/Serial Number in the Inventory Adjustment
   1. Use the Inventory Summary to identify the current On Hand quantity.
   2. Select the Expand by Lot/Serial Numbers checkbox
   3. Calculate the necessary adjustment using the actual physical count using this formula:

Actual Lot/Serial Qty in stock – Acumatica Lot/Serial On Hand Qty = Adjustment Quantity

1. 1. Examples:
      1.  Lot 121424HC:
         1. Actual Qty in warehouse: 2,240 cases
         2. On Hand quantity in Acumatica: 2,200 cases
         3. Adjustment needed: +40 cases
      2. Lot 20230327:
         1. Actual Qty in warehouse: 0 cases
         2. On Hand quantity in Acumatica: 380 cases
         3. Adjustment needed: -380 cases

2. Create the Inventory Adjustment:
   1. Open New Inventory Adjustment
   2. Enter Inventory ID
      1. In the Details tab, add a new line or select ADD ITEMS
      2. Select the appropriate Inventory ID for the item being adjusted.
   3. Enter Warehouse and Location
   4. Enter Quantity calculated in Step 1
      1. Use a positive value to increase inventory.
      2. Use a negative value to decrease inventory.
   5. Enter or select the Lot/Serial Number
   6. The system automatically pulls the current unit cost and calculates the Extended Cost based on the quantity entered.
   7. Set the Extended Cost to $0.00.  

NOTE: If you need to adjust the quantity and the value you will need two separate transactions, first to adjust quantity, then value. Contact Support for assistance with these transactions.

1. 1. Repeat steps b. – f. to add each lot/serial number to the adjustment.

3. Release the inventory adjustment. NOTE: Once released, the inventory adjustment is finalized and cannot be edited. Any further corrections will require a new adjustment transaction. 
   1. The system will:
      1. Update the item’s On Hand quantity in inventory.
      2. Create necessary GL and inventory transactions (if applicable).
4. Verify the updated quantity in the Inventory Summary
   1. Refresh the Inventory Summary report.
   2. Confirm the new quantity.
      1. The On Hand Quantity should now reflect the adjustment made.

NOTE: Lot 20230327 no longer appears on the report because the full quantity was adjusted out of inventory.