Change a lot number

dtretton · ‎December 11, 2018

Our warehouse changed lot numbers on some inventory. How do I change a specific lot number in QB Enterprise? Seems like it should be easy, but I can't figure it out.

FritzF · ‎December 11, 2018

Hello there, @dtretton.

It's nice to see you here in the Community. Let me walk you through changing lot numbers for inventory in QuickBooks Desktop Enterprise.

To change or assign lot numbers to an existing inventory, you'll be using the Adjust Quantity/Value on Hand window. Here's how:

1. Open your QuickBooks company file.
2. Go to Inventory menu at the top, then pick Adjust Quantity/Value on Hand.
3. Click the Adjustment Type drop-down, then select 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. Select Save & Close.

Please see the sample screenshot below.

Once done, you can run the Lot Numbers in Stock report by going to the Reports menu then selecting Inventory to confirm the accuracy of your entries. For your reference, you may check out this article for further guidance and scroll down to assign serial/lot numbers to existing inventory: Use Serial or Lot Numbers.

That's it! Please let me know how it goes or if I can be of additional assistance. I'd be glad to answer should you have any follow-up questions. Take care and have a good one.

View solution in original post

FritzF · ‎December 11, 2018

Hello there, @dtretton.

It's nice to see you here in the Community. Let me walk you through changing lot numbers for inventory in QuickBooks Desktop Enterprise.

To change or assign lot numbers to an existing inventory, you'll be using the Adjust Quantity/Value on Hand window. Here's how:

1. Open your QuickBooks company file.
2. Go to Inventory menu at the top, then pick Adjust Quantity/Value on Hand.
3. Click the Adjustment Type drop-down, then select 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. Select Save & Close.

Please see the sample screenshot below.

Once done, you can run the Lot Numbers in Stock report by going to the Reports menu then selecting Inventory to confirm the accuracy of your entries. For your reference, you may check out this article for further guidance and scroll down to assign serial/lot numbers to existing inventory: Use Serial or Lot Numbers.

That's it! Please let me know how it goes or if I can be of additional assistance. I'd be glad to answer should you have any follow-up questions. Take care and have a good one.

dtretton · ‎December 11, 2018

Thank you!
I noticed that this left me with 2 lots (both old and new numbers, same inventory in each), so I entered a second line item bringing the original lot down to 0.

Appreciate the quick response!

BettyJaneB · ‎May 08, 2019

Hello, @Rangeley1988.

I'd be pleased to help you with reinstalling your QuickBooks. Let's get this started.

Before you reinstall your QuickBooks you'll need to make sure that you have your license and product number ready. In case you're unable to find these numbers, you may refer to this link for some steps in locating it.

Once done, you can now proceed with installing your QuickBooks.

Here's how:

Download the QuickBooks Desktop.
Select Yes to All.
Select Next.
Agree to the Software License Agreement, then select Next.
Enter your License and Product numbers, then select Next.
Select the type of installation for the computer.
Select where you will be using QuickBooks.
Choose a new install location or select Next to install to the default directory.
Select Install.
Select Open QuickBooks to get started.

Here are great articles that you can check out to guide you with the installation process and fixing installation issues:

In case you need further assistance with the procedure, feel free to get in touch with our Customer Care Team.

I'll be around to provide continuous support if there's anything else you need about reinstalling QuickBooks. Thanks for coming and wishing you well.

SHAHBAZ650 · ‎August 01, 2019

Please guide how to change LOT Number when I move inventory from one location to another. I Have three ware house locations. Islamabad, Lahore & Karachi. Item Name: Cabinet Lot Number: Karachi / 01-06-2019 / Order for Hussain Engineering Qty: 200 pcs Location: Karachi Now I want to move 50 pcs to Lahore and 100 pcs to Islamabad ware house. Once I move these items to other locations then I want to change LOT NUMBERS 1. Cabinet – Qty 50 pcs – Lahore / 01-06-2019/ Sample for Alpha Engineering 2. Cabinet – Qty 100 pcs – Islamabad / 01-06-2019 / Order for Zahoor Engineering. Remaining 50 pcs will remain in Karachi with same lot number 1. Cabinet – Qty 50 pcs - Karachi / 01-06-2019 / Order for Hussain Engineering Please guide ....

JenoP · ‎August 01, 2019

Thanks for joining us here, SHAHBAZ650.

There's an option in QuickBooks to transfer items from one site to another. Here's how:

Go to the Inventory menu, then select Transfer Inventory.
Provide all required information including Date, Reference No., Class, Transfer from, and To.
Look for the items under the Item column.
Enter all other details including the quantity of items to transfer.
You might also want to indicate a short reason of the transfer in the Memo field.
Select Save & Close.

Once done, follow the steps in the first reply of this thread to change lot numbers. Let me also share this article with you for additional reference: Multiple Inventory Sites.

You can always visit us again if you need more help with your inventories.

Topics

Training

Community

Resources

Change a lot number