SLSRPT (Sales Report)
The SLSRPT message intent is to provide sales information for one or more locations for a series of products within a specified time period.
General usage
- The message is transmitted either from a seller to its supplier or from a headquarters, coordination or distribution centre to a manufacturer, supplier or a third party for statistical analysis.
- It allows the recipient to know for a specific product, for example the Location of the sale, Period in which it was sold, Product selling price, quantity and value of the sales etc.
Fields used in the SLSRPT message
| Name | Required | Description | Examples | XPATH | Type | Limits | Sort | Id |
|---|---|---|---|---|---|---|---|---|
| Sender | Yes | The sender of the EDI message, identified by a GLN. |
|
/b24Message/salesReport/sender/#gln |
100 | 100 | ||
| Recipient | Yes | The recipient of the EDI message, identified by a GLN. |
|
/b24Message/salesReport/recipient/#gln |
200 | 200 | ||
| Document Number | Sales report ID for the whole transaction. |
|
/b24Message/salesReport/documentReference[@documentType="salesReport"]/@id |
300 | 300 | |||
| Document Date | Sales report date. |
|
/b24Message/salesReport/documentReference[@documentType="salesReport"]/@date |
400 | 400 | |||
| Buyer | Yes | The buyer, identified by a GLN. |
|
/b24Message/salesReport/buyer/#gln |
500 | 500 | ||
| Site | Yes | The store in which the goods were sold, identified by a GLN. |
|
/b24Message/salesReport/site/location/#gln |
600 | 600 | ||
| Sale Date | Date and time when the sale took place. |
|
/b24Message/salesReport/site/sale/#date |
700 | 700 | |||
| Sale ID | Unique ID of the sale transaction, (typically including terminal+receipt-number). |
|
/b24Message/salesReport/site/sale/#id |
800 | 800 | |||
| Sales Associate | ID/Reference of the associate/representative selling the goods to the consumer at the terminal/counter. |
|
/b24Message/salesReport/site/sale/#salesAssociate |
900 | 900 | |||
| SKU Description | The supplier's SKU description for the product. Preferably including: model name, colour and size. |
|
/b24Message/salesReport/site/sale/item/property[@name="description"] |
1000 | 1000 | |||
| Brand | The brand name of the product. |
|
/b24Message/salesReport/site/sale/item/property[@name="brand"] |
1100 | 1100 | |||
| Model Number | The model number of the product. (suppliers model number) |
|
/b24Message/salesReport/site/sale/item/property[@name="modelNo"] |
1200 | 1200 | |||
| Model Color | The supplier's unique model and color ID of the product. |
|
/b24Message/salesReport/site/sale/item/property[@name="modelColor"] |
1300 | 1300 | |||
| Gender Category | The gender category, such as: Men, Woman, Unisex, Boys/Girls or Kids. |
|
/b24Message/salesReport/site/sale/item/property[@name="gender"] |
1400 | 1400 | |||
| Goods Class | The goods class of the product - either FEDAS, B24 Product Category Keys, Supplier or Customer. |
|
/b24Message/salesReport/site/item/[@set="goods class type" and @code="goods class code"] |
1500 | 1500 | |||
| Supplier | Yes | GLN of the supplier/brand of the sold/returned item. |
|
/b24Message/salesReport/site/sale/item/supplier/#gln |
Number | 1600 | 1600 | |
| Color Code | The code of the product colour. |
|
/b24Message/salesReport/site/sale/item/dimension[@name="color" and @code="colorCode"] |
1700 | 1700 | |||
| Size | The size of the item. |
|
/b24Message/salesReport/site/sale/item/dimension[@name="size"] |
1800 | 1800 | |||
| Barcode with Type | Yes | The supplier's EAN/UPC code of the product. |
|
/b24Message/salesReport/site/sale/item/itemReference[@registry="Supplier" and @coding="EAN13"] |
1900 | 1900 | ||
| Gross Sales Amount | The total Sales Amount for the sold quantity of the product, excluding discount/markdown, including VAT. |
|
/b24Message/salesReport/site/sale/item/price[@type="grossSalesAmount" and @value] |
2000 | 2000 | |||
| Gross Sales Price | The Sales Price for one unit of the sold product, excluding discount/markdown, including VAT. |
|
/b24Message/salesReport/site/sale/item/price[@type="grossSalesPrice" and @value] |
2100 | 2100 | |||
| Net Sales Amount | The total Sales Amount for the sold quantity of the product after deducted discount/markdown, including VAT. |
|
/b24Message/salesReport/site/sale/item/price[@type="netSalesAmount" and @value] |
2200 | 2200 | |||
| Net Sales Price | The Sales Price for one unit of the sold product after deducted discount/markdown, including VAT. |
|
/b24Message/salesReport/site/sale/item/price[@type="netSalesPrice" and @value] |
2300 | 2300 | |||
| Cost Amount (Sales) | The retailer's total Cost Of Goods Sold (COGS) for the sold quantity of the product, including VAT. |
|
/b24Message/salesReport/site/sale/item/price[@type="costAmountSales" and @value] |
2400 | 2400 | |||
| Cost Price (Sales) | The retailer's Cost Of Goods Sold (COGS) for one unit of the sold product, including VAT. |
|
/b24Message/salesReport/site/sale/item/price[@type="costPriceSales" and @value] |
2500 | 2500 | |||
| Retail Price | The set Retail Price for the product at the sales site, including VAT. (used for concession/consignment) |
|
/b24Message/salesReport/site/sale/item/price[@type="retailPrice" and @value] |
2600 | 2600 | |||
| Recommended Retail Price | The supplier's Recommended Retail Price for the item at the sales site, including VAT. (used for wholesale) |
|
/b24Message/salesReport/site/sale/item/price[@type="recRetailPrice" and @value] |
2700 | 2700 | |||
| Net Return Price | The Return Price for one unit of the returned product after deduction for (possible) fees/charges, including VAT. |
|
/b24Message/salesReport/site/sale/item/price[@type="netReturnPrice" and @value] |
2800 | 2800 | |||
| Net Return Amount | The total Return Amount for the returned quantity of the product after deduction for (possible) fees/charges, including VAT. |
|
/b24Message/salesReport/site/sale/item/price[@type="netReturnAmount" and @value] |
2900 | 2900 | |||
| Gross Return Price | The Return Price for one unit of the returned product excluding (possible) fees/charges, including VAT. |
|
/b24Message/salesReport/site/sale/item/price[@type="grossReturnPrice" and @value] |
3000 | 3000 | |||
| Gross Return Amount | The total Return Amount for the sold quantity of the product excluding (possible) fees/charges, including VAT. |
|
/b24Message/salesReport/site/sale/item/price[@type="grossReturnAmount" and @value] |
3100 | 3100 | |||
| Cost Amount (Return) | The retailer's total Cost Of Goods Sold (COGS) for the returned quantity of the product, including VAT. |
|
/b24Message/salesReport/site/sale/item/price[@type="costAmountReturn" and @value] |
3200 | 3200 | |||
| Cost Price (Return) | The retailer's Cost Of Goods Sold (COGS) for one unit of the returned product, including VAT. |
|
/b24Message/salesReport/site/sale/item/price[@type="costPriceReturn" and @value] |
3300 | 3300 | |||
| Gross Sales Amount Ex. VAT | The total Sales Amount for the sold quantity of the product, excluding discount/markdown, including VAT. |
|
/b24Message/salesReport/site/sale/item/price[@type="grossSalesAmountExVAT" and @value] |
3400 | 3400 | |||
| Gross Sales Price Ex. VAT | The Sales Price for one unit of the sold product, excluding discount/markdown, excluding VAT. |
|
/b24Message/salesReport/site/sale/item/price[@type="grossSalesPriceExVAT" and @value] |
3500 | 3500 | |||
| Net Sales Amount Ex. VAT | The total Sales Amount for the sold quantity of the product after deducted discount/markdown, excluding VAT. |
|
/b24Message/salesReport/site/sale/item/price[@type="netSalesAmountExVAT" and @value] |
3600 | 3600 | |||
| Net Sales Price Ex. VAT | The Sales Price for one unit of the sold product after deducted discount/markdown, excluding VAT. |
|
/b24Message/salesReport/site/sale/item/price[@type="netSalesPriceExVAT" and @value] |
3700 | 3700 | |||
| Cost Amount (Sales) Ex. VAT | The retailer's total Cost Of Goods Sold (COGS) for the reported quantity of the product, excluding VAT. |
|
/b24Message/salesReport/site/sale/item/price[@type="costAmountSalesExVAT" and @value] |
3800 | 3800 | |||
| Cost Price (Sales) Ex. VAT | The retailer's Cost Of Goods Sold (COGS) for one unit of the sold product, excluding VAT. |
|
/b24Message/salesReport/site/sale/item/price[@type="costPriceSalesExVAT" and @value] |
3900 | 3900 | |||
| Retail Price Ex. VAT | The set Retail Price for the product at the sales site, excluding VAT. (used for concession/consignment) |
|
/b24Message/salesReport/site/sale/item/price[@type="retailPriceExVAT" and @value] |
4000 | 4000 | |||
| Recommended Retail Price Ex. VAT | The supplier's Recommended Retail Price for the item at the sales site, excluding VAT. (used for wholesale) |
|
/b24Message/salesReport/site/sale/item/price[@type="recRetailPriceExVAT" and @value] |
4100 | 4100 | |||
| Net Return Price Ex. VAT | The Return Price for one unit of the returned product after deduction for (possible) fees/charges, excluding VAT. |
|
/b24Message/salesReport/site/sale/item/price[@type="netReturnPriceExVAT" and @value] |
4200 | 4200 | |||
| Net Return Amount Ex. VAT | The total Return Amount for the returned quantity of the product after deduction for (possible) fees/charges, excluding VAT. |
|
/b24Message/salesReport/site/sale/item/price[@type="netReturnAmountExVAT" and @value] |
4300 | 4300 | |||
| Gross Return Price Ex. VAT | The Return Price for one unit of the returned product excluding (possible) fees/charges, excluding VAT. |
|
/b24Message/salesReport/site/sale/item/price[@type="grossReturnPriceExVAT" and @value] |
4400 | 4400 | |||
| Gross Return Amount Ex. VAT | The total Return Amount for the sold quantity of the product excluding (possible) fees/charges, excluding VAT. |
|
/b24Message/salesReport/site/sale/item/price[@type="grossReturnAmountExVAT" and @value] |
4500 | 4500 | |||
| Cost Amount (Return) Ex. VAT | The retailer's total Cost Of Goods Sold (COGS) for the returned quantity of the product, excluding VAT. |
|
/b24Message/salesReport/site/sale/item/price[@type="costAmountReturnExVAT" and @value] |
4600 | 4600 | |||
| Cost Price (Return) Ex. VAT | The retailer's Cost Of Goods Sold (COGS) for one unit of the returned product, excluding VAT. |
|
/b24Message/salesReport/site/sale/item/price[@type="costPriceReturnExVAT" and @value] |
4700 | 4700 | |||
| VAT Amount | Specified VAT-amount for the referred price element with type. |
|
/b24Message/salesReport/site/sale/item/price/property[@name="vatAmount"] |
4800 | 4800 | |||
| Quantity Sales | Yes | The quantity of the item sold at the site. |
|
/b24Message/salesReport/site/sale/item/quantity[@type="Sales" and @value] |
4900 | 4900 | ||
| Quantity Return | Yes | The quantity of the item returned at the site. |
|
/b24Message/salesReport/site/sale/item/quantity[@type="Return" and @value] |
5000 | 5000 | ||
| Quantity Cancel | The quantity of the item cancelled at the site. |
|
/b24Message/salesReport/site/sale/item/quantity[@type="Return" and @value] |
5100 | 5100 |