Knowledgebase: Tutorials
[QODBC-Desktop] Troubleshooting - Where is the Bin Location for Items stored?
Posted by Jack - QODBC Support on 30 March 2016 10:09 AM

Troubleshooting - Where is the Bin Location for Items stored?

Problem Description 1:

I am using QuickBooks Enterprise with Advanced Inventory enabled.

I am trying to find where the bin location for items is stored in QuickBooks through QODBC.

Problem Description 2:

We are looking for the below tables in QB Enter. 16 via QODBC (Linked Server) SQL server with no luck:

We can find the table for Inventory Site but there is no distinction for BIN, they are all listed equally in the table. (tbl = InventorySites)

Solution:

You can find inventory site list & location from below tables:

BillItemLine,PurchaseOrderLine,InvoiceLine,SalesOrderLine,CheckItemLine,CreditCardCreditItemLine,CreditMemoLine, SalesReceiptLine, CheckItemLine,CreditCardChargeItemLine,BuildAssembly,BuildAssemblyComponentItemLine,TransferInventoryLine,InventoryAdjustment,InventoryAdjustmentLine & ItemSites.

(0 vote(s))
Helpful
Not helpful

Comments (0)
Post a new comment
 
 
Full Name:
Email:
Comments:
CAPTCHA Verification 
 
Please complete the captcha below (we use this to prevent automated submissions).