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?
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.
Go to the Edit menu at the top.
Choose Items & Inventory section.
Under Company Preferences, click Advanced Inventory Settings.
On the Multiple Inventory Locations preference, check the box beside Track bin Locations within Inventory Sites (row, shelf, or bin).
Click OK twice.
Once done, you can now create or add a new bin location in QuickBooks Desktop. Please follow the steps below.
Go to the List menu.
Select Inventory Site List.
Go to the InventorySite drop-down arrow, select New.
Enter the name of the location for your inventory items.
Turn on the radio button for is a bin within site.
Type in the name of your new bin location.
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:
Click the Reports menu at the top.
Choose Inventory and select Items by Bin Location.
Click the Customize Report button.
Go to the Display tab. Then, checkmark the Bin Location.