cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Frequent Explorer **

Adjusting Lot Number Quantities

Is there a way to adjust the quantities shown for a Lot Number when it gets out of wack and does not match whats actually on hand?  There are some part numbers showing negatives and some that show more than what is currently on hand in inventory. Its hard to convey this in a clear and concise manner, but if these Lot Number inconsistencies can be cleaned up it would help to reduce confusion for some employees.

Solved
Best answer 07-16-2019

Accepted Solutions
QuickBooks Team

Re: Adjusting Lot Number Quantities

Hi there, @NaturalStone.

 

When you adjust a quantity, QuickBooks assumes that the average cost of the item remains the same and adjusts the value accordingly. Let me walk you through adjust the quantities shown for a Lot Number.

 

Here's how:

  1. Open your QuickBooks company file.
  2. Go to the Inventory menu at the top, then pick Adjust Quantity/Value on Hand.
  3. Click the Adjustment Type drop-down, then click Lot Number.
  4. On the Item field, enter the item name or click the drop-down arrow and select it from the list.
  5. Enter the new lot number, then on the New Count column, enter the number of items in that lot.
  6. Click Save & Close.

For more reference, you can check out this article for further guidance: Use Serial or Lot Numbers.

 

Please let me know if you need anything else. Have a nice day!

View solution in original post

QuickBooks Team

Re: Adjusting Lot Number Quantities

Hello there, NaturalStone. 

 

I tried adjusting the item's quantity on hand for a Lot Number and was able to decrease it. 

 

We can perform an integrity check to identify if there's a data within the company file. 

 

Here's how: 

  1. Go to the File menu and choose Utilities
  2. Then, select Verify Data
  3. After it has been verified and you're prompted that "QuickBooks detected no problems with your data", click OK. No further action needed. 
  4. Proceed to Rebuilding your data if you get a message that "Your data has lost integrity". 
  5. Then, follow the on-screen instructions until rebuild has completed. 

After, let's create an adjustment again. If you get the same thing, I'd recommend reaching out to our customer support team. They'll further investigate this issue. 

 

From the Help menu, click QuickBooks Desktop Help. Then, select Contact us. Enter a brief description of your concern and then click Continue. Choose to either Talk to a Specialist or Message and Agent

 

Let me know if you need anything else. Have a great day!

View solution in original post

3 Comments
QuickBooks Team

Re: Adjusting Lot Number Quantities

Hi there, @NaturalStone.

 

When you adjust a quantity, QuickBooks assumes that the average cost of the item remains the same and adjusts the value accordingly. Let me walk you through adjust the quantities shown for a Lot Number.

 

Here's how:

  1. Open your QuickBooks company file.
  2. Go to the Inventory menu at the top, then pick Adjust Quantity/Value on Hand.
  3. Click the Adjustment Type drop-down, then click Lot Number.
  4. On the Item field, enter the item name or click the drop-down arrow and select it from the list.
  5. Enter the new lot number, then on the New Count column, enter the number of items in that lot.
  6. Click Save & Close.

For more reference, you can check out this article for further guidance: Use Serial or Lot Numbers.

 

Please let me know if you need anything else. Have a nice day!

View solution in original post

Frequent Explorer **

Re: Adjusting Lot Number Quantities

Thanks for your help GraceC! One thing I noticed though as I was making adjustments is that I'm able to adjust quantities up but not down.. Is there a way to reduce the quantity thats showing in a particular Lot Number?

QuickBooks Team

Re: Adjusting Lot Number Quantities

Hello there, NaturalStone. 

 

I tried adjusting the item's quantity on hand for a Lot Number and was able to decrease it. 

 

We can perform an integrity check to identify if there's a data within the company file. 

 

Here's how: 

  1. Go to the File menu and choose Utilities
  2. Then, select Verify Data
  3. After it has been verified and you're prompted that "QuickBooks detected no problems with your data", click OK. No further action needed. 
  4. Proceed to Rebuilding your data if you get a message that "Your data has lost integrity". 
  5. Then, follow the on-screen instructions until rebuild has completed. 

After, let's create an adjustment again. If you get the same thing, I'd recommend reaching out to our customer support team. They'll further investigate this issue. 

 

From the Help menu, click QuickBooks Desktop Help. Then, select Contact us. Enter a brief description of your concern and then click Continue. Choose to either Talk to a Specialist or Message and Agent

 

Let me know if you need anything else. Have a great day!

View solution in original post

Need to get in touch?

Contact us