cancel
Showing results for 
Search instead for 
Did you mean: 
Dytrt
Level 1

Empty Bin Locations

I'm seeing several bin locations showing up on my reports with a quantity of 0 on hand.  Some also show lot #'s in the bin even though there is a 0 balance.  How can I clear all of those bins so they don't show up on my report.

3 Comments 3
Rose-A
Moderator

Empty Bin Locations

I'd be glad to help you clear all your empty bin locations so they don't show up on your reports in QuickBooks Desktop, Dytrt.

 

If there no transactions associated with those empty bin locations, you can delete them through the Inventory Site List. Here's how:

 

  1. Click Lists at the top menu bar and choose Inventory Site List.
  2. Highlight the empty Bin Location.
  3. Right-click and select Delete Bin Location.
  4. Hit OK.

However, if the bin location is assigned to a transaction, you can simply make it inactive.
 

 

Once done, you can now pull up your reports without these empty bins. I recommend customizing the report to get the specific details you need. You can also memorize it to save its current customization settings. It serves as your record and helps you quickly access it for future use.

 

Additionally, you can take a look at this write-up: Multiple Inventory Sites. It provides more details on what other reports you can pull to track your inventory at different locations in QuickBooks Desktop.

 

This should get you moving today, Dytrt. Don't hesitate to let me know if I can be of additional assistance while working in QuickBooks Desktop or if you have any follow-up questions in mind. I'm always here to keep helping. Have a good one!

Dytrt
Level 1

Empty Bin Locations

I should have been more clear.  I don't want to delete the actual bin location, just the data showing in it.  When I have 0 on-hand in a bin, I don't want the reporting to show previous part numbers that were in those bins, along with their lot #'s.  I want those to disappear when the value of that part number hits 0.  Some of the bins below have product in them and that I want to see.  But the others with 0 on hand I don't want to see the old part number or the old lot #.

Bin Location Part Number On Hand Lot Number
3A14B      
  TA2-2B-T72-BLK (Dual Motor Height Adjustable Desk Base)Dual Motor Height Adjustable Desk Base0.00 7-23-20
  AIM02E002 (Electric Height Adjustable Desk Base  Dual motor-3stage rectangular co...Electric Height Adjustable Desk Base  Dual motor-3stage rectangular column, Grey0.00 9-24-20
  AIMYJYTAJ002 ("Electric Height Adjustable Desk Base  without motor-2stage rectang..."Electric Height Adjustable Desk Base  without motor-2stage rectangle column, Gray"  31.00 1-18-2021
3C3A      
  AIM02E001 (Electric Height Adjustable Desk Base  Dual motor-3stage rectangular co...Electric Height Adjustable Desk Base  Dual motor-3stage rectangular column ,Black0.00 9-25-20
  AIMDP-12W (Table Top    particle board 1200mm)Table Top    particle board 1200mm0.00  
3C3B      
  AIM02E001 (Electric Height Adjustable Desk Base  Dual motor-3stage rectangular co...Electric Height Adjustable Desk Base  Dual motor-3stage rectangular column ,Black0.00  
  AIM02E003 (Electric Height Adjustable Desk Base  Dual motor-3stage rectangular co...Electric Height Adjustable Desk Base  Dual motor-3stage rectangular column, White0.00  
  AIMYJYTZB3002 (Electric Height Adjustable Desk Base-Dual motor-3stage rectangular...Electric Height Adjustable Desk Base-Dual motor-3stage rectangular upside down column ,Gray  30.00 1-18-2021
3C3C      
  AIM01EDB2002 (Electric Height Adjustable Desk Base  Dual motor-2stage rectangular...Electric Height Adjustable Desk Base  Dual motor-2stage rectangular column Grey0.00  
  AIM02E001 (Electric Height Adjustable Desk Base  Dual motor-3stage rectangular co...Electric Height Adjustable Desk Base  Dual motor-3stage rectangular column ,Black0.00  
  AIMYJYTAJ001 ("Electric Height Adjustable Desk Base  without motor-2stage rectang..."Electric Height Adjustable Desk Base  without motor-2stage rectangle column, Black"  27.00 1-18-2021
JonpriL
Moderator

Empty Bin Locations

Hello @Dytrt,

 

As of the moment, there isn't an integrated way to remove an item with 0 quantity on hand under a bin location. With this, let's consider exporting an Excel copy of your report so you can remove the items in question.

 

To do so:

  1. Go to Reports.
  2. Under Inventory, select Items by Bin Location.
  3. Select Excel.
  4. Click Create New Worksheet.

In addition, here's an article you can read to learn more about how you can work with your report in an Excel file: Export reports as Excel workbooks in QuickBooks Desktop.

 

Lastly, I've also included this reference for a compilation of articles you can use while working with us: Know where you stand financially.

 

If you have any other questions, please let me know by leaving any comments below. I'll be here to lend a hand.

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

Need to get in touch?

Contact us