QbXML for Querying for Inventory by Site
Example qbXML Request
<?xml version="1.0" encoding="utf-8"?> <?qbxml version="10.0"?> <QBXML> <QBXMLMsgsRq onError="stopOnError"> <ItemSitesQueryRq> <ItemSiteFilter> <SiteFilter> <FullName>Your Site Name Here</FullName> </SiteFilter> </ItemSiteFilter> <MaxReturned>25</MaxReturned> <ActiveStatus>All</ActiveStatus> </ItemSitesQueryRq> </QBXMLMsgsRq> </QBXML>
The response you get back includes elements such as:
ItemInventoryRef/ListID ItemInventoryRef/FullName InventorySiteRef/ListID InventorySiteRef/FullName ReorderLevel QuantityOnHand QuantityOnPurchaseOrders QuantityOnOrder QuantityOnSalesOrders QuantityOnSalesOrder QuantityToBeBuiltByPendingBuildTxns QuantityRequiredByPendingBuildTxns QuantityOnPendingTransfers