Yes, there's a way to adjust the quantity of an item by lot without impacting the overall quantity on hand. I'd be glad to assist with this, @dkassner.
You can consider adjusting inventory by lot number to change the quantity of a specific item and address the inventory discrepancy. I can provide the steps to achieve this in QuickBooks Desktop (QBDT).
Adjusting the inventory by lot number changes the quantity of the items but doesn't change the total quantity on hand by site. To assist in the task of correcting the discrepancies in your inventory quantity, I suggest pulling up the Quantity on Hand by Site and Lot Numbers in Stock reports side-by-side to compare quantities on the lot number level and total quantity on hand by site. Once done, you can follow these steps:
- Go to the Inventory menu. Then, select Adjust Quantity/Value on Hand.
- Choose Lot Number for the Adjustment Type.
- Enter the Adjustment Date.
- Choose the Inventory Site where the item you want to change the amount is.
- If applicable, type in the Reference No and choose the Customer:Job.
- Pick from the drop-down list the Inventory Site where the item you want to adjust is.
- Enter the Item, Lot Number, and the New Count of the item. The amount you input in the New Count box will be the new quantity on hand by lot.
- Type in a description in the Memo field for reference.
- Hit Save & Close.
For future reference, let me add this article as a guide in saving the current customizations of your inventory reports in QBDT: Create, access and modify memorized reports.
We'll be here in the Community if you have additional questions about adjusting inventory in QBDT. We'll do our best to assist.
