Sanmol Software is leading custom solutions provider as per customer needs!!

Sanmol Software

U13, Breezy Castle, 125 Owen Roberts Dr, PO Box 11958, Grand Cayman, KY1-1010, Cayman Islands

24/7 online support


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