Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for
Hello,
This is my first time asking a question here. I have been trying to deal with an ongoing issue in which the Quantity On Hand by Site inventory doesn't match with Quantity on Hand by Lot number. I am unsure of how to make an adjustment to correct that discrepancy. When using the Adjust Quantity/Value on Hand function, any change made through that channel changes the total quantity on hand. Is there a way to adjust the quantity of a specific item and lot without affecting the total quantity on hand?
Solved! Go to Solution.
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:
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.
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:
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.
Hi, AlverMarkT,
Thanks for taking the time to reply. I will try this out when I have a chance!
You have clicked a link to a site outside of the QuickBooks or ProFile Communities. By clicking "Continue", you will leave the community and be taken to that site instead.
For more information visit our Security Center or to report suspicious websites you can contact us here