Starting with QuickBooks Enterprise 2013 versions and later Intuit added an additional field on inventory related transactions called bins. You can read a detailed write up on how to enable and use the bin field on the Sleeter blog.
The QuickBooks field bin is available on the following import types in Transaction Pro Importer 6.0 (“TPI6”).
- Credit Memo
- Invoice Credit Memo
- Invoice Link to Sales Order
- Item Receipt
- Inventory Adjustment
- Purchase Order
- Sales Order
- Sales Receipt
If you have Advanced Inventory turned on and have enabled bins in QuickBooks Enterprise you will see two additional fields on the TPI6 mapping screen, Inventory Site and Inventory Bin.
Since the Inventory Bin is basically a child of the Inventory Site field you will need to provide both the Site and the Bin in your import file. For purposes of this example lets assume that the Site is called Warehouse A and that the Bin is Called Location 100. You have two options on the TPI6 mapping screen.
Option 1: If these two fields are in two different columns map the column that has the value Warehouse A to the QuickBooks field, Inventory Site, and the column that has the value, Location 100 to the QuickBooks field, Inventory Bin.
Option 2: If these two fields are in one column with a colon in between them (Warehouse A:Location 100) map the column that contains this data to the QuickBooks field, Inventory Site.
Please note the Inventory Site is required on both options.
You can request a free trial of Transaction Pro Importer here.