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? 

Solution:

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

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