Knowledgebase: TroubleShooting
[QODBC-Desktop] Troubleshooting - QuickBooks Advanced Inventory Module in QODBC
Posted by Jack - QODBC Support on 11 January 2016 11:56 AM

Troubleshooting - QuickBooks Advanced Inventory Module in QODBC

Problem Description:

Does your enterprise driver support the advanced inventory module for QuickBooks enterprise? Would we be able to query stock per item, per location? 


You can access the Advanced Inventory data from QuickBooks enterprise add-on.

Yes, site and location field is not available in ItemInventory & other Item tables through the Intuit SDK.

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

BillItemLine,PurchaseOrderLine,InvoiceLine,SalesOrderLine,CheckItemLine,CreditCardCreditItemLine,CreditMemoLine, SalesReceiptLine, CheckItemLine,CreditCardChargeItemLine,BuildAssembly,BuildAssemblyComponentItemLine,TransferInventory,TransferInventoryLine,InventoryAdjustment,InventoryAdjustmentLine,ItemSite

(2 vote(s))
Not helpful

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