Knowledgebase
[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 the Inventory Site, but there is no distinction for BIN. They are all listed equally in the table. (tbl = InventorySites)

Solution:

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

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

(2 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).