Knowledgebase
[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 the QuickBooks enterprise add-on.

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

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

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

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