cancel
Showing results for 
Search instead for 
Did you mean: 
Sydney-Rupes
Level 2

Inventory & Bin Locations

We have never utilized the Inventory tracking and Bin locations for our Inventory. Now that we have turned it on, I am having trouble setting it up. 

I attempted to adjust inventory, and was able to assign which location I was using (using "unassigned" as we get things organized, then planning on assigning each part a bin). I could not save the inventory without adding an Inventory Bin Location, then still could not save the updated inventory list. 

 scnshot- QB inventory.jpg

 

 

Also, I was unable to find a way to assign specific locations in the "Edit Item" screen for when we go in to add specific Bin locations.

8 Comments 8
ShiellaGraceA
QuickBooks Team

Inventory & Bin Locations

Thanks for coming in today, @Sydney-Rupes.

 

I have an idea on how to get past the warning message. Looking at your attached screenshot, you should be able to save your quantity adjustment. You'll want to make sure each item in your adjustment has an assigned bin location.

 

You can tick on the sidebar arrow and scroll up and down to check if there's an empty bin location. Here's how it looks like:

 

 

Once found, assign a bin location and then save.

 

About assigning a specific location, you'll want to use the Add/Edit Multiple Items feature. It's where you can enter your desired bin location. Let me walk you through the steps.

 

  1. Go to the Inventory menu at the top. Then, select Item List.
  2. Scroll down towards the Item drop-down, and choose Add/Edit Multiple Items.
  3. In the Add/Edit Multiple Items screen, tap the Customize Columns button at the top.
  4. From the Available Columns field, search for the Default Sales Bin and Default Purchase Bin.
  5. Hit the Add > button to transfer the columns to Chosen Columns field.
  6. Click OK. See the attached image below.

 

After adding the column, pick the items you want to assign a specific location. For more information about managing inventory, check out this guide: Set up Advanced Inventory.

 

Additionally, here's a link that covers all tasks you can do when using the inventory feature.

 

If you still have questions or concerns, feel welcome to message me. I'll be happy to help. Take care and have a great weekend.

Sydney-Rupes
Level 2

Inventory & Bin Locations

Hi, @ShiellaGraceA thanks for that info. 

The updating inventory bin tips worked well, thank you.

 

However, I am still having the same issue with updating inventory amounts. I even tried to just update one item, so that I would know that it was not missing info. 

QB 1 ASSIGNED.png

 

Then, I went in and did the inventory bin assignment, hoping that would clear the background coding that is getting stuck, and that didn't work either. I double checked and every item has a location assigned. Unless there is some "line item" that is not showing up, that doesn't seem to be the issue. 

 

MadelynC
Moderator

Inventory & Bin Locations

Let gets this resolved, @Sydney-Rupes.


There are cases we can experience unexpected behavior and issues from time to time. Data problems might be the reason that you’re getting stuck. I can provide steps so you can continue to run the business. 


You can utilize the Verify Rebuild Data tool in QuickBooks. It identifies the most commonly known data issues within your company file while resolving it right away. Here are the steps to do it:

 

  1. First, choose Window and then select Close All.
  2. Go to the File menu, then click on the option of Utilities.
  3. Select the option of Rebuild Data.
  4. Follow the onscreen instruction to back up your data.
  5. When the tool finishes, select OK.
  6. Navigate to the File menu, then hover over Utilities.
  7. Click Verify Data and select Rebuild Now once QuickBooks finds an issue with your company file.

You can check this article for additional information about the process. This provides other troubleshooting instructions in case the issue remains the same.


I’ve added a reference here about Multiple Inventory Sites. It shows you how to assign items, set up multiple locations to track and transfer your inventory in the program. It also contains helpful links so you can manage them accordingly.


If you need further assistance with any of the steps, let me know by posting a comment below. I'll always be around. 

Sydney-Rupes
Level 2

Inventory & Bin Locations

Hey @MadelynC

I will try that! Is that something I should do in single user mode? 

When we are all logged in I don't want to mess with anything that could possibly give issues for someone else! 

Also, how long should the repair take? 

Just trying to figure out the best time for the company to do so. Thank you! 

 

MirriamM
Moderator

Inventory & Bin Locations

Hello again, @Sydney-Rupes

 

When running the Verify Rebuild Tool, you'll need to log in as QuickBooks Admin using the single-user mode

 

As for how long will the process take, it depends on your company file size.

 

To give you more of an idea about the verify and rebuild data, take a look at this article: Verify and Rebuild Data in QuickBooks Desktop.

 

Here's also a resource that'll help you learn the task you can perform when switched to single or multi-user mode: Features available and tasks you can perform in single or multi-user mode.

 

Please know that I'm always here to lend a hand if you have any other QuickBooks concerns. Feel free to leave a comment below. Have a nice day.

Sydney-Rupes
Level 2

Inventory & Bin Locations

Thanks @MirriamM I'll do that one of these mornings! 
I was more looking for an idea- like, less than 30 minutes, less than an hour, several hours? 

I wouldn't want to cause QuickBooks to be down for half a day just because I didn't know how long it would take! (I don't think everyone would appreciate that excuse, eep!)

 

Thanks for those resources. Hopefully this fixes the issue! 

 

Sydney-Rupes
Level 2

Inventory & Bin Locations

Is anybody able to give me an idea of how long this will take? Even just an idea would be helpful for scheduling. 

 

Thank you

Catherine_B
QuickBooks Team

Inventory & Bin Locations

Hello there, Sydney-Rupes.

 

Verifying and Rebuilding your data will take minutes for it to complete. However, it will still depend on your company's file size as my colleague shared. If you get the same thing, I'd suggest contacting our Phone Support Team. They can a remote screen sharing with you so they can walk you through the process of resolving the prompts you're receiving.

 

Here's how to contact us:

 

  1. Open your company file.
  2. Go to Help and click QuickBooks Desktop Help
  3. Enter a brief description of your issue something about adjusting inventory.
  4. Click Continue and select an option you'll want to connect with us. 

You can also click here for our Chat Support direct link.

 

Feel free to post your questions here if you have other questions. Take care!

Sign in for expert help
Ask questions, post replies & join our community of QuickBooks users.

Need to get in touch?

Contact us