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

Bin location

I would like to add the bin location that a product was invoiced from, not the default sale bin location, in advance reports.  Which field should I use from all the ones available within advance reports?

2 Comments 2
ChristieAnn
QuickBooks Team

Bin location

Hi there, Willy Wonka.

 

Welcome back to the QuickBooks Community. I'll share steps to make sure you can add bin locations for the invoiced product.

 

Once you track them, QuickBooks also adds a Location column to the form. To start with, you'll have to turn on the Row, Shelf, or Bin preference. This way, you can start using the bin location feature to multiple forms.

 

Here's how:

 

  1. Go to the Edit menu at the top.
  2. Select Preferences.
  3. Choose Items & Inventory section.
  4. Under Company Preferences, click Advanced Inventory Settings
  5. On the Multiple Inventory Locations preference, check the box beside Track bin Locations within Inventory Sites (row, shelf, or bin).
  6. Click OK twice.

 

Once done, you can now create or add a new bin location in QuickBooks Desktop. Please follow the steps below.

 

  1. Go to the List menu.
  2. Select Inventory Site List.
  3. Go to the Inventory Site drop-down arrow, select New.
  4. Enter the name of the location for your inventory items.
  5. Turn on the radio button for is a bin within site.
  6. Type in the name of your new bin location.
  7. Hit OK twice.

 

After that, you can run the Items by Bin Location report and customize this. That way, you're able to add the bin location column to see where the product was invoiced from. 

 

Follow these steps:

 

  1. Click the Reports menu at the top.
  2. Choose Inventory and select Items by Bin Location.
  3. Click the Customize Report button.
  4. Go to the Display tab. Then, checkmark the Bin Location.
  5. Click OK.

 

For additional information on how you can customize the data, delete columns, add or remove information on the header/footer, you can click this article: Customize reports in QuickBooks Desktop.

 

Lastly, I've got you this helpful article for ideas about the other ways you can utilize for your inventory management: Set up and use the Warehouse Manager App.

 

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

Fiat Lux - ASIA
Level 15

Bin location

@Willy Wonka 

The feature is available in Advanced Inventory of Platinum edition. If you are using QBD Pro/Premier, you may consider having a 3rd party inventory management app.

Need to get in touch?

Contact us
Sign in for the best experience
Ask questions, get answers, and join our large community of QuickBooks users.
Sign In / Sign Up