Issue: The quantity in the Lot Management window does not link to the Quantities in the Warehouse stock tab of the inventory item. This How To is designed to correct an issue where the lot quantity does not equal the inventory quantity. Keep in mind, the lot form will include units that are showing in the “received” column on the item.

Step 1: Create an inventory adjustment that removes all of the inventory from the lots, and post it. It is OK for now if there is still inventory on the item, or if inventory goes negative. This is necessary because items with inventory in a lot cannot be switched to not track lots.

Step 2: Go to affected inventory item > Detail tab and change the Use Lots setting to “No”

Step 3: Create a second inventory adjustment to remove all inventory from the product, setting the stock to 0. This is important because items with inventory cannot be set to track lots.

Step 4: Go to the Detail tab and change the “Use Lots” flag to “Yes”.

Step 5: Create a third Inventory Adjustment to bring in the correct inventory and lots, making sure to enter the correct cost on the line as well.

Finally, verify the 2 quantities are correct.