Description

API call that exposes pixi* report: "Items on stock with BN/BBD"

Request Parameters

#	Name	Type	Required	Example	Description
1	BatchNumber	string	0	asdf1234	Search by Batch number
2	BestBeforeDateFrom	string	0	YYYY-MM-DD hh:mm:ss	Search by Best Before Date - From
3	BestBeforeDateTo	string	0	YYYY-MM-DD hh:mm:ss	Search by Best Before Date - To
4	LocId	string	0	001	Search by Location ID
5	Ean	string	0	12345fd343	Search by barcode
6	ItemTag	integer	0	-6 (Batch Number) or -7 (Best Before Date)	Search by Tag Key
7	SupplierNr	string	0	ABCD	Search by Supplier Nr.
8	BinGroup	string	0	sdfds223	Search by BinGroup
9	Category	string	0	123	Search by Category
10	ItemNrInt	string	0	123	Search by Shop item number

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_ItemsOnStockWithBatchManagement>
         <dem:BatchNumber>asdf1234</dem:BatchNumber>
         <dem:BestBeforeDateFrom>YYYY-MM-DD hh:mm:ss</dem:BestBeforeDateFrom>
         <dem:BestBeforeDateTo>YYYY-MM-DD hh:mm:ss</dem:BestBeforeDateTo>
         <dem:LocId>001</dem:LocId>
         <dem:Ean>12345fd343</dem:Ean>
         <dem:ItemTag>-6 (Batch Number) or -7 (Best Before Date)</dem:ItemTag>
         <dem:SupplierNr>ABCD</dem:SupplierNr>
         <dem:BinGroup>sdfds223</dem:BinGroup>
         <dem:Category>123</dem:Category>
         <dem:ItemNrInt>123</dem:ItemNrInt>
      </dem:pixiReport_ItemsOnStockWithBatchManagement>
   </soapenv:Body>
</soapenv:Envelope>

Response

Body 1: Report "Items on stock with BN/BBD" output columns

#	Name	Type	Description
1	ItemKey	integer	pixi* item ID
2	ItemNrSuppl	string	Item number supplier
3	ItemNrInt	string	Shop item number
4	EANUPC	string	Item barcode
5	ItemName	string	Item name
6	BatchNumber	string	Item batch number
7	BestBeforeDate	string	Item best before date
8	BinName	string	Bin name where the item is located
9	BinGroup	string	Bin group
10	QtyInBin	integer	Item quantity in specified bin place

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 all items with TAGs for batch number or best before date that are currently on stock.
It is possible to filter according to a certain time frame for best before date so that you can check which items on which bin places will expire soon. If you want to check the items with a specific batch number use the filter parameter for batch number.
Filters for location and bin group allow to get a list of items for specific areas in your warehouse, TAG, category and supplier for a specific set of items.