GetMovementsByQuery

This function lets you retrieve information about stock movements. By "movement" we mean when an item physically moves from one warehouse location to another location.

Tags: GetMovementsByQuery, GetGoodsOwnerMovementsQuery, GetMovementsByQueryResponse, GetGoodsOwnerMovementsResult, GoodsOwnerMovement, GetGoodsOwnerMovementsErrorResult, ArticleInfo_GetGoodsOwnerMovements, InOrderInfo_GetGoodsOwnerMovements, LocationInfo_GetGoodsOwnerMovements, WarehouseInfo_GetGoodsOwnerMovements, ArticleItemPalletItemInfo, ArticleFreeValues

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/GetMovementsByQuery"

<?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>
    <GetMovementsByQuery xmlns="http://ongoingsystems.se/WSI">
      <GoodsOwnerCode>string</GoodsOwnerCode>
      <UserName>string</UserName>
      <Password>string</Password>
      <Query>
        <FromLocation>string</FromLocation>
        <ToLocation>string</ToLocation>
        <MoveTimeFrom>dateTime</MoveTimeFrom>
        <MoveTimeTo>dateTime</MoveTimeTo>
        <ArticleDefIdsToGet>
          <int>int</int>
          <int>int</int>
        </ArticleDefIdsToGet>
        <ArticleNumbersToGet>
          <string>string</string>
          <string>string</string>
        </ArticleNumbersToGet>
        <FromWarehouseCode>string</FromWarehouseCode>
        <ToWarehouseCode>string</ToWarehouseCode>
        <FromWarehouseId>int</FromWarehouseId>
        <ToWarehouseId>int</ToWarehouseId>
        <OnlyMovementsBetweenDifferentWarehouses>boolean</OnlyMovementsBetweenDifferentWarehouses>
        <OnlyMovementsBetweenDifferentArticleItemPalletItems>boolean</OnlyMovementsBetweenDifferentArticleItemPalletItems>
      </Query>
    </GetMovementsByQuery>
  </soap:Body>
</soap:Envelope>

Request specification

GetMovementsByQuery
GoodsOwnerCode	string(400)	Req.	The name/code of your client
UserName	string(50)	Req.	Your username
Password	string(50)	Req.	Your password
Query	GetGoodsOwnerMovementsQuery	Req.	The query object

GetGoodsOwnerMovementsQuery
FromLocation	string(50)		Only return stock movements from this location.
ToLocation	string(50)		Only return stock movements to this location.
MoveTimeFrom	dateTime	Req.	Only return stock movements which happened after this time.
MoveTimeTo	dateTime		Only return stock movements which happened before this time.
ArticleDefIdsToGet	int[]		Only return stock movements for these particular articles.
ArticleNumbersToGet	string[]		Only return stock movements for these particular articles.
FromWarehouseCode	string		Only return stock movements from this warehouse.
ToWarehouseCode	string		Only return stock movements to this warehouse.
FromWarehouseId	int		Only return stock movements from this warehouse.
ToWarehouseId	int		Only return stock movements to this warehouse.
OnlyMovementsBetweenDifferentWarehouses	boolean		Only return stock movements between warehouses.
OnlyMovementsBetweenDifferentArticleItemPalletItems	boolean		Only return stock movements where items where moved into, out from, or between pallet items.

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>
    <GetMovementsByQueryResponse xmlns="http://ongoingsystems.se/WSI">
      <GetMovementsByQueryResult>
        <Success>boolean</Success>
        <Movements>
          <Movement>
            <Article>
              <ArticleDefId>int</ArticleDefId>
              <ArticleNumber>string</ArticleNumber>
              <ArticleName>string</ArticleName>
              <FreeValues>
                <ArticleFreeDecimal1>decimal</ArticleFreeDecimal1>
                <ArticleFreeDecimal2>decimal</ArticleFreeDecimal2>
                <ArticleFreeDecimal3>decimal</ArticleFreeDecimal3>
                <ArticleFreeBool1>boolean</ArticleFreeBool1>
              </FreeValues>
            </Article>
            <NumberOfItems>decimal</NumberOfItems>
            <OriginalArticleItemId>int</OriginalArticleItemId>
            <Serial>string</Serial>
            <ExpiryDate>dateTime</ExpiryDate>
            <Batch>string</Batch>
            <InOrder>
              <InOrderId>int</InOrderId>
              <InOrderNumber>string</InOrderNumber>
            </InOrder>
            <MoveTime>dateTime</MoveTime>
            <FromLocation>
              <LocationName>string</LocationName>
              <LocationTypeCode>string</LocationTypeCode>
            </FromLocation>
            <ToLocation>
              <LocationName>string</LocationName>
              <LocationTypeCode>string</LocationTypeCode>
            </ToLocation>
            <FromWarehouse>
              <WarehouseId>int</WarehouseId>
              <WarehouseCode>string</WarehouseCode>
            </FromWarehouse>
            <ToWarehouse>
              <WarehouseId>int</WarehouseId>
              <WarehouseCode>string</WarehouseCode>
            </ToWarehouse>
            <FromArticleItemPalletItem>
              <Id>int</Id>
              <TypeCode>string</TypeCode>
              <LabelId>string</LabelId>
            </FromArticleItemPalletItem>
            <ToArticleItemPalletItem>
              <Id>int</Id>
              <TypeCode>string</TypeCode>
              <LabelId>string</LabelId>
            </ToArticleItemPalletItem>
            <Weight>decimal</Weight>
          </Movement>
          <Movement>
            <Article>
              <ArticleDefId>int</ArticleDefId>
              <ArticleNumber>string</ArticleNumber>
              <ArticleName>string</ArticleName>
              <FreeValues>
                <ArticleFreeDecimal1>decimal</ArticleFreeDecimal1>
                <ArticleFreeDecimal2>decimal</ArticleFreeDecimal2>
                <ArticleFreeDecimal3>decimal</ArticleFreeDecimal3>
                <ArticleFreeBool1>boolean</ArticleFreeBool1>
              </FreeValues>
            </Article>
            <NumberOfItems>decimal</NumberOfItems>
            <OriginalArticleItemId>int</OriginalArticleItemId>
            <Serial>string</Serial>
            <ExpiryDate>dateTime</ExpiryDate>
            <Batch>string</Batch>
            <InOrder>
              <InOrderId>int</InOrderId>
              <InOrderNumber>string</InOrderNumber>
            </InOrder>
            <MoveTime>dateTime</MoveTime>
            <FromLocation>
              <LocationName>string</LocationName>
              <LocationTypeCode>string</LocationTypeCode>
            </FromLocation>
            <ToLocation>
              <LocationName>string</LocationName>
              <LocationTypeCode>string</LocationTypeCode>
            </ToLocation>
            <FromWarehouse>
              <WarehouseId>int</WarehouseId>
              <WarehouseCode>string</WarehouseCode>
            </FromWarehouse>
            <ToWarehouse>
              <WarehouseId>int</WarehouseId>
              <WarehouseCode>string</WarehouseCode>
            </ToWarehouse>
            <FromArticleItemPalletItem>
              <Id>int</Id>
              <TypeCode>string</TypeCode>
              <LabelId>string</LabelId>
            </FromArticleItemPalletItem>
            <ToArticleItemPalletItem>
              <Id>int</Id>
              <TypeCode>string</TypeCode>
              <LabelId>string</LabelId>
            </ToArticleItemPalletItem>
            <Weight>decimal</Weight>
          </Movement>
        </Movements>
        <Error>
          <ErrorType>FromDateOccursAfterToDate or Unknown or LogonError</ErrorType>
          <Message>string</Message>
        </Error>
      </GetMovementsByQueryResult>
    </GetMovementsByQueryResponse>
  </soap:Body>
</soap:Envelope>

Response specification

GetMovementsByQueryResponse
GetMovementsByQueryResult	GetGoodsOwnerMovementsResult

GetGoodsOwnerMovementsResult
Success	boolean
Movements	GoodsOwnerMovement[]	List of movements.
Error	GetGoodsOwnerMovementsErrorResult	An element of type GetGoodsOwnerMovementsErrorResult.

GoodsOwnerMovement
Article	ArticleInfo_GetGoodsOwnerMovements	Contains information about the moved article (article number, article name, etc).
NumberOfItems	decimal	Number of items which were moved.
OriginalArticleItemId	int	Original article item id.
Serial	string(128)	Serial number of the moved item.
ExpiryDate	dateTime	Expiry date of the moved item.
Batch	string(50)	Batch number of the moved item.
InOrder	InOrderInfo_GetGoodsOwnerMovements	Information about the purchase which the item belongs to (if the item was received on a purchase order).
MoveTime	dateTime	The time when the move was performed.
FromLocation	LocationInfo_GetGoodsOwnerMovements	The location the items were moved From.
ToLocation	LocationInfo_GetGoodsOwnerMovements	The location the items were moved to.
FromWarehouse	WarehouseInfo_GetGoodsOwnerMovements	The warehouse which the items were moved from.
ToWarehouse	WarehouseInfo_GetGoodsOwnerMovements	The warehouse which the items were moved to.
FromArticleItemPalletItem	ArticleItemPalletItemInfo	Information about the pallet item that the item was (possibly) packed in before the move.
ToArticleItemPalletItem	ArticleItemPalletItemInfo	Information about the pallet item that the item is (possibly) packed in after the move.
Weight	decimal	Weight of the moved item.

GetGoodsOwnerMovementsErrorResult
ErrorType	enum	An element of type GetGoodsOwnerMovementsErrorType.
Message	string

ArticleInfo_GetGoodsOwnerMovements
ArticleDefId	int	The id of the article.
ArticleNumber	string(200)	The article number.
ArticleName	string(200)	The article number.
FreeValues	ArticleFreeValues	An element of type ArticleFreeValues.

InOrderInfo_GetGoodsOwnerMovements
InOrderId	int	The id of the inorder which the item belongs to (if the item was received on an inorder).
InOrderNumber	string(50)	The inorder number of the inorder which the item belongs to (if the item was received on an inorder).

LocationInfo_GetGoodsOwnerMovements
LocationName	string(50)	The location name.
LocationTypeCode	string(50)	The location type code.

WarehouseInfo_GetGoodsOwnerMovements
WarehouseId	int
WarehouseCode	string

ArticleItemPalletItemInfo
Id	int	System id of the pallet item
TypeCode	string(50)	Code of the package type
LabelId	string(30)	Label number

ArticleFreeValues
ArticleFreeDecimal1	decimal	Custom decimal field. By default not used for anything.
ArticleFreeDecimal2	decimal	Custom decimal field. By default not used for anything.
ArticleFreeDecimal3	decimal	Custom decimal field. By default not used for anything.
ArticleFreeBool1	boolean	Custom boolean field. By default not used for anything.