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?

4 Comments 4
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.

kdwilson
Level 1

Bin location

Hello, we've tried the solution provided above multiple times and the system still defaults the warehouse location to the wrong location - any ideas as to what else we could try? 

ZackE
Moderator

Bin location

Thanks for joining the Community, kdwilson.

 

I've reviewed our ongoing/solved investigations and can confirm there's currently no records about warehouse locations showing an incorrect location in advance reports compared to what location's on file.

 

Since you're seeing invalid information in your report, I'd recommend using the Verify Data feature to see if anything needs to be rebuilt.

 

Here's how:

  1. Choose Window, then Close All.
  2. In your top menu bar, go to File.
  3. Click Utilities.
  4. Select Verify Data.

 

After verification is complete, you'll see one of a few possible messages. I've listed each of them and their meanings:

  • "QuickBooks detected no problems with your data," - No action is required.
  • "Your data has lost integrity," - This indicates that there's data damage in your company file. You'll want to perform a rebuild to correct the problem.
  • An error message could display. If so, there might be an article about it. Try searching Intuit's QuickBooks Desktop support site for specific instructions.

 

If your Verify/Rebuild Data utilities didn't solve the issue, you'll want to get in touch with our Customer Care team. They'll be able to pull up the account in a secure environment, conduct further research, and create an investigation ticket if necessary.

 

They can be reached while using QuickBooks:

  1. In your top menu bar, go to Help, then QuickBooks Desktop Help.
  2. Click Contact Us.
  3. Enter a brief description of your issue in our Ask a question (or tell us what's wrong) field.
  4. Hit Continue.
  5. Select Start messaging or Get a callback.

 

Be sure to review their support hours so you'll know when agents are available.

 

Please feel welcome to send a reply if there's any questions. Have a great day!

Need to get in touch?

Contact us