Description

Returns warehouse stock replenishment recommendations by comparing stock levels between a source and a destination location (and optional additional source). For each item that needs replenishing, it reports source and destination bins, current quantities, the missing quantity needed to reach minimum stock, supplier price, open and on-hold order demand, and target stock. Results can be sorted by source or destination bin order.

Request Parameters

#	Name	Type	Required	Example	Description
1	FromLocID	string	1	001	Location where stock is taken from.
2	ToLocID	string	1	002	Location where stock is put to.
3	AdditionalLocID	string	0	003	Additional location where stock is taken from. Optional (default NULL).
4	SortBy	string	0	0	Bin sort order. 0 = bins on the source location, 1 = bins on the destination location. Default 0.

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:pixiInventoryItemsToRefill>
         <dem:FromLocID>001</dem:FromLocID>
         <dem:ToLocID>002</dem:ToLocID>
         <dem:AdditionalLocID></dem:AdditionalLocID>
         <dem:SortBy>0</dem:SortBy>
      </dem:pixiInventoryItemsToRefill>
   </soapenv:Body>
</soapenv:Envelope>

Response

Body 1: Inventory refill report

#	Name	Type	Description
1	FromLocIDbinName	string	Source bin name
2	FromLocIDbinSortNum	integer	Source bin sorting number
3	ToLocIDbinName	string	Destination bin name
4	ToLocIDbinSortNum	integer	Destination bin sorting number
5	EanUpc	string	Item barcode
6	ItemName	string	Item name
7	ToLocQty	integer	Quantity at destination location
8	FromLocQty	integer	Quantity at source location
9	FromBinqty	integer	Quantity at source bin
10	MissingQty	integer	Quantity needed to reach minimum stock
11	MinStockQty	integer	Minimum stock quantity for the item
12	SupplPrice	money	Supplier price of the item
13	OpenCustOrdersQty	integer	Quantity reserved for open customer orders
14	OrdersOnHoldQty	integer	Quantity reserved for orders on hold
15	ParFromLocID	string	Echo of the source location parameter
16	ParToLocID	string	Echo of the destination location parameter
17	SortBy	string	Echo of the sort order parameter
18	PicLinkSmall	string	URL to picture of the item (small size)
19	PicLinkLarge	string	URL to picture of the item (large size)
20	ItemNrInt	string	Shop item number
21	TargetStock	integer	Item target stock quantity

Additional Notes

Report procedure to refill/relocate stock. The procedure delegates to the core inventory analysis routine and compares stock between the source and destination locations, optionally including an additional source location, to recommend replenishment quantities.