Description

Returns a stock evaluation report for all items currently in stock, including pricing, stock quantities, total purchase value, days in stock, last order date, and sold quantities over configurable time ranges. Results can be filtered to a single supplier. Only items with a current positive stock quantity are included.

Request Parameters

#	Name	Type	Required	Example	Description
1	SupplNr	string	0	MGS	Supplier number to filter results by. If NULL or omitted, all suppliers are included.
2	SoldRange1	int	0	30	Number of days for the first sold quantity range. Default: 30.
3	SoldRange2	int	0	90	Number of days for the second sold quantity range. Default: 90.
4	SoldRange3	int	0	120	Number of days for the third sold quantity range. Default: 120.

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:pixiReportGetStockItems>
         <dem:SupplNr>MGS</dem:SupplNr>
         <dem:SoldRange1>30</dem:SoldRange1>
         <dem:SoldRange2>90</dem:SoldRange2>
         <dem:SoldRange3>120</dem:SoldRange3>
      </dem:pixiReportGetStockItems>
   </soapenv:Body>
</soapenv:Envelope>

Response

Body 1: Stock Items

One row per item currently in stock. Returns an empty result set if no items match.

#	Name	Type	Description
1	ItemKey	int	Internal pixi item ID.
2	Artikelnummer	string	Supplier article number (item number at supplier).
3	EANUPC	string	EAN/UPC barcode of the item.
4	Lieferant	string	Supplier number.
5	Artikelname	string	Item name.
6	VK	money	Selling price (Verkaufspreis).
7	EK	money	Average purchase price (Einkaufspreis).
8	AnzahlArtikelAufLager	int	Current quantity in stock.
9	EKGesamt	money	Total purchase value of current stock (quantity × average purchase price).
10	AufLagerSeit	datetime	Date the item was first put into stock.
11	AufLagerSeitTage	int	Number of days the item has been in stock (since first stock date).
12	LetzteBestellung	datetime	Date of the most recent order for this item.
13	LetzteBestellungTage	int	Number of days since the most recent order.
14	soldRange1	int	Total quantity sold within the SoldRange1 period (default: last 30 days).
15	soldRange2	int	Total quantity sold within the SoldRange2 period (default: last 90 days).
16	soldRange3	int	Total quantity sold within the SoldRange3 period (default: last 120 days).

Additional Notes

All parameters are optional. When SupplNr is omitted, items from all suppliers are returned.

Only items with a current positive stock quantity are included in results.
Items with zero stock are excluded.

soldRange1, soldRange2, soldRange3 return the total quantity sold within the number
of days defined by the corresponding SoldRange1, SoldRange2, SoldRange3 parameters,
counting back from the current date.

Response field names are in German as originally defined in the procedure.