GetHistoricalInventoryByQuery

This function returns stock information for a specified date. The response will contain both the total stock balance for each article that was in stock, and additionally more detailed information concerning exactly which batches or serial numbers that were in stock.

Note that if an article was not in stock on the specified date, then it will not be returned in the response.

Tags: GetHistoricalInventoryByQuery, GetHistoricalInventoryQuery, GetHistoricalInventoryByQueryResponse, GetHistoricalInventoryResult, HistoricalInventoryArticleRow, HistoricalInventoryArticle, HistoricalInventoryArticleItem

Request XML

POST /xxx/Service.asmx HTTP/1.1
Host: api.ongoingsystems.se
Content-Type: text/xml; charset=utf-8
Content-Length: length
SOAPAction: "http://ongoingsystems.se/WSI/GetHistoricalInventoryByQuery"

<?xml version="1.0" encoding="utf-8" ?>
<soap:Envelope xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema" xmlns:soap="http://schemas.xmlsoap.org/soap/envelope/">
  <soap:Body>
    <GetHistoricalInventoryByQuery xmlns="http://ongoingsystems.se/WSI">
      <GoodsOwnerCode>string</GoodsOwnerCode>
      <UserName>string</UserName>
      <Password>string</Password>
      <GetHistoricalInventoryQuery>
        <StockDate>dateTime</StockDate>
        <OutboundDateType>PickingTime</OutboundDateType>
        <WarehouseCode>string</WarehouseCode>
      </GetHistoricalInventoryQuery>
    </GetHistoricalInventoryByQuery>
  </soap:Body>
</soap:Envelope>

Request specification

Response XML

<?xml version="1.0" encoding="utf-8" ?>
<soap:Envelope xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema" xmlns:soap="http://schemas.xmlsoap.org/soap/envelope/">
  <soap:Body>
    <GetHistoricalInventoryByQueryResponse xmlns="http://ongoingsystems.se/WSI">
      <GetHistoricalInventoryByQueryResult>
        <Success>boolean</Success>
        <Message>string</Message>
        <Rows>
          <HistoricalInventoryArticleRow>
            <Article>
              <SystemId>int</SystemId>
              <ArticleNumber>string</ArticleNumber>
              <ArticleName>string</ArticleName>
              <ProductCode>string</ProductCode>
              <NumberOfItems>decimal</NumberOfItems>
              <Price>decimal</Price>
            </Article>
            <Items>
              <HistoricalInventoryArticleItem>
                <NumberOfItems>decimal</NumberOfItems>
                <Serial>string</Serial>
                <BatchNo>string</BatchNo>
                <InOrderId>int</InOrderId>
                <InOrderNumber>string</InOrderNumber>
                <InOrderLineUnitPrice>decimal</InOrderLineUnitPrice>
                <InDate>dateTime</InDate>
                <ExpiryDate>dateTime</ExpiryDate>
                <ProductionDate>dateTime</ProductionDate>
              </HistoricalInventoryArticleItem>
              <HistoricalInventoryArticleItem>
                <NumberOfItems>decimal</NumberOfItems>
                <Serial>string</Serial>
                <BatchNo>string</BatchNo>
                <InOrderId>int</InOrderId>
                <InOrderNumber>string</InOrderNumber>
                <InOrderLineUnitPrice>decimal</InOrderLineUnitPrice>
                <InDate>dateTime</InDate>
                <ExpiryDate>dateTime</ExpiryDate>
                <ProductionDate>dateTime</ProductionDate>
              </HistoricalInventoryArticleItem>
            </Items>
          </HistoricalInventoryArticleRow>
          <HistoricalInventoryArticleRow>
            <Article>
              <SystemId>int</SystemId>
              <ArticleNumber>string</ArticleNumber>
              <ArticleName>string</ArticleName>
              <ProductCode>string</ProductCode>
              <NumberOfItems>decimal</NumberOfItems>
              <Price>decimal</Price>
            </Article>
            <Items>
              <HistoricalInventoryArticleItem>
                <NumberOfItems>decimal</NumberOfItems>
                <Serial>string</Serial>
                <BatchNo>string</BatchNo>
                <InOrderId>int</InOrderId>
                <InOrderNumber>string</InOrderNumber>
                <InOrderLineUnitPrice>decimal</InOrderLineUnitPrice>
                <InDate>dateTime</InDate>
                <ExpiryDate>dateTime</ExpiryDate>
                <ProductionDate>dateTime</ProductionDate>
              </HistoricalInventoryArticleItem>
              <HistoricalInventoryArticleItem>
                <NumberOfItems>decimal</NumberOfItems>
                <Serial>string</Serial>
                <BatchNo>string</BatchNo>
                <InOrderId>int</InOrderId>
                <InOrderNumber>string</InOrderNumber>
                <InOrderLineUnitPrice>decimal</InOrderLineUnitPrice>
                <InDate>dateTime</InDate>
                <ExpiryDate>dateTime</ExpiryDate>
                <ProductionDate>dateTime</ProductionDate>
              </HistoricalInventoryArticleItem>
            </Items>
          </HistoricalInventoryArticleRow>
        </Rows>
      </GetHistoricalInventoryByQueryResult>
    </GetHistoricalInventoryByQueryResponse>
  </soap:Body>
</soap:Envelope>

Response specification