QbXML for Querying for Inventory by Site

From ConsoliBYTE Wiki
Jump to: navigation, search

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