Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for
Connect with and learn from others in the QuickBooks Community.
Join nowI 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?
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:
Once done, you can now create or add a new bin location in QuickBooks Desktop. Please follow the steps below.
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:
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!
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.
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?
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:
After verification is complete, you'll see one of a few possible messages. I've listed each of them and their meanings:
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:
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!
You have clicked a link to a site outside of the QuickBooks or ProFile Communities. By clicking "Continue", you will leave the community and be taken to that site instead.