Skip to main content
6
67FARMER
March 3, 2025
Question

Physical inventory worksheet

  • March 3, 2025
  • 1 reply
  • 0 views

We have added new parts to our inventory and when we print the physical inventory worksheet with BIN locations we have found that new inventory shows up on the last page not with the BIN location of items in the same bin.

 

For example we have BIN location GC10 (grey cabinet, cabinet number 10). We added a new part that goes in this location but this part does not show up with all the other parts in GC10, but shows up and the last page after the letter Z location.

Why does it not put this item with other items in GC10 on the worksheet?

1 reply

MorganB
MorganB
March 3, 2025

Hello, 67FARMER.

 

Thanks for reaching out for support here in the Community. I'm happy to provide some info about the physical inventory worksheet in your QuickBooks Desktop account.

 

When printing a physical inventory worksheet with bin locations in QuickBooks Desktop, new inventory items might appear on the last page, not grouped with items in the same bin, because the bin locations are not being correctly associated with the new item during its creation or transaction.


To verify bin location settings:
1. Go to Edit > Preferences > Items & Inventory > Company Preferences.
2. Click on Advanced Inventory Settings.
3. Make sure that "Track bin Locations within Inventory Sites (row, shelf, or bin)" is checked

 

The following article provides additional info about setting up Advanced Inventory.

 

Please feel free to drop a comment below if you have any other questions. I'll be here to help.

6
67FARMERAuthor
March 3, 2025

Okay i tried what you said and nothing changed. In fact I sent up a new part and used BIN location 10. That fell into line with the others. Then I changed it to BIN location GC15 and it came at the end of the report with all the other letter locations we have added?

H
Heide DC
March 4, 2025

I appreciate your effort in performing the steps mentioned above, 67FARMER. Let's confirm the items are added to the specific BIN location. Let me show how it goes.

 

You can ensure that when recording a new item, it is assigned to the correct location. Please note that QuickBooks is intended for recording purposes only and will accurately reflect the data you have entered.

 

However, if you verify that the item has been posted to an incorrect BIN location, you can transfer the inventory to the correct BIN location accordingly.

 

 

Otherwise, if the item is in the correct BIN location, I recommend running the verify and rebuild the data to ensure everything is in order before you proceed with the migration. This will give you an extra layer of confidence that your data is ready to be moved without any issues.

 

I will also include this article to help you learn how to import or export information with QuickBooks: Import and export data in QuickBooks Desktop.

 

Tag me in if there’s anything else you need assistance with in managing your QBDT inventory. I’ll be around to lend a hand. Keep safe and more successful in your business.

Terms & ConditionsAccessibility statement