Description

API call that exposes pixi* report: "Stock Movements for Items with BN/BBD"

Request Parameters

#	Name	Type	Required	Example	Description
1	DateFrom	string	0	YYYY-MM-DD hh:mm:ss	Start of stock movement peroid
2	DateTo	string	0	YYYY-MM-DD hh:mm:ss	End of stock movement peroid
3	SMTKey	integer	0	123	Search by stock movement ID
4	UserName	string	0	asdf	Search by user name
5	LocID	string	0	001	Search by location ID
6	ItemTag	integer	0	-6 (Batch Number) or -7 (Best Before Date)	Search by item tag ID
7	Category	string	0	12ab	Search by category
8	SupplNr	string	0	12ab	Search by Supplier

Request body

<soapenv:Envelope xmlns:soapenv="http://schemas.xmlsoap.org/soap/envelope/" xmlns:dem="https://api.pixi.eu/soap/demosandbox/">
   <soapenv:Header/>
   <soapenv:Body>
      <dem:pixiReport_StockMovementsForItemsWithBnBbd>
         <dem:DateFrom>YYYY-MM-DD hh:mm:ss</dem:DateFrom>
         <dem:DateTo>YYYY-MM-DD hh:mm:ss</dem:DateTo>
         <dem:SMTKey>123</dem:SMTKey>
         <dem:UserName>asdf</dem:UserName>
         <dem:LocID>001</dem:LocID>
         <dem:ItemTag>-6 (Batch Number) or -7 (Best Before Date)</dem:ItemTag>
         <dem:Category>12ab</dem:Category>
         <dem:SupplNr>12ab</dem:SupplNr>
      </dem:pixiReport_StockMovementsForItemsWithBnBbd>
   </soapenv:Body>
</soapenv:Envelope>

Response

Body 1: Report "Stock Movements for Items with BN/BBD" output columns

#	Name	Type	Description
1	EANUPC	string	Item barcode
2	ItemName	string	Item name
3	BinName	string	Bin name
4	Stock	integer	Physical stock of the item
5	MovedQty	integer	Quantity of moved item
6	HistTotalSupplPrice	number	Historical supplier price times quantity of moved item
7	Date	string	Date of stock movement
8	SMTType	string	Stock movement type code
9	SMTName	string	Stock movement type name
10	BatchNumber	string	Batch number of the item
11	BestBeforeDate	string	Best before date of the item
12	UserName	string	User that made the stock movement
20	DatabaseCurrencyCode	string	Database currency code
21	SupplNr	string	Supplier number (code)

Body 2: Error response

#	Name	Type	Description
1	Status	string	Status of the responce
2	Message	string	Description of the error response

Additional Notes

This report shows the history of stock movements per bin and item with TAG for batch number and/ or best before date in custom time frame.
With the different filter parameters you have the possibility to see stock movements of a certain location or stock movement type. 
Additionally you can select a user and the report will show you all stock movements of items that were made by one of your employees. Supplier price is from the time of the stock movement. Column "Summe EK" displays supplier price multiplied by moved stock quantity.