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 | Edifact Path | Edifact Qualifiers | Edifact Sample | Type | Limits | Sort | Id |
---|---|---|---|---|---|---|---|---|---|---|---|
(Header) : Date From | Yes | The first date the SalesReport covers |
|
/b24Message/salesReport/@dateFrom | Number | None |
1000 | 1 | |||
(Header) : Date To | Yes | The last date the SalesReport covers |
|
/b24Message/salesReport/@dateTo | Number | None |
1100 | 2 | |||
(Header) : Sender gln | Yes | The sender of the EDI message, identified by a GLN. |
|
/b24Message/salesReport/sender/@gln | Number | Must be a valid EAN13 GLN |
1200 | 3 | |||
(Header) : Recipient gln | Yes | The recipient of the EDI message, identified by a GLN. Please note that for the Sales Report message the recipient must always be Btwentyfour. The supplier of the sold/returned goods is specified on each item. |
|
/b24Message/salesReport/recipient/@gln | Number | Must be a valid EAN13 GLN |
1300 | 4 | |||
(Header) : Salesreport Number | Yes | Sales report ID for the EDI transaction. |
|
/b24Message/salesReport/documentReference[@documentType="salesReport"]/@id | Text | Must be unique for the business relaitonship |
1400 | 5 | |||
(Header) : SalesReport Date | Yes | Sales report date. |
|
/b24Message/salesReport/documentReference[@documentType="salesReport"]/@date | Date/Time | Must be in the format "YYYY-MM-DD" in C21, and in "YYYYMMDD" in B24s D01B format |
1500 | 6 | |||
(Header) : Buyer gln | Yes | The buyer, identified by a GLN. |
|
/b24Message/salesReport/buyer/@gln | Number | Must be a valid EAN13 GLN |
1600 | 7 | |||
(Site) : Site gln | Yes | The store in which the goods were sold, identified by a GLN, Global Location Number Retailer Location Number) |
|
/b24Message/salesReport/site/location/@gln | Number | Must be a valid EAN13 GLN |
1700 | 8 | |||
(Site) : Sale Date | Yes | Date and time when the sale took place. |
|
/b24Message/salesReport/site/sale/@date | Date/Time | Must be in the format "YYYY-MM-DD" in C21, and in "YYYYMMDD" in B24s D01B format |
1800 | 9 | |||
(Sale) : Sale ID | Yes | Unique ID of the sale transaction, (typically including terminal+receipt-number). |
|
/b24Message/salesReport/site/sale/@id | Text | None |
1900 | 10 | |||
(Sale) : Sales Associate | No | ID/Reference of the associate/representative selling the goods to the consumer at the terminal/counter. |
|
/b24Message/salesReport/site/sale/@salesAssociate | Text | None |
2000 | 11 | |||
(Item/Line) : SKU Description | No | The supplier's SKU description for the product. Preferably including: model name, colour and size. |
|
/b24Message/salesReport/site/sale/item/property[@name="description"] | Text | None |
2100 | 12 | |||
(Item/Line) : Brand | No | The brand name of the product. |
|
/b24Message/salesReport/site/sale/item/property[@name="brand"] | Text | None |
2200 | 13 | |||
(Item/Line) : Model Number | No | The model number of the product. (suppliers model number) |
|
/b24Message/salesReport/site/sale/item/property[@name="modelNo"] | Text | None |
2300 | 14 | |||
(Item/Line) : Model Color | No | The supplier's unique model and color ID of the product. |
|
/b24Message/salesReport/site/sale/item/property[@name="modelColor"] | Text | None |
2400 | 15 | |||
(Item/Line) : Gender Category | No | The gender category, such as: Men, Woman, Unisex, Boys/Girls or Kids. |
|
/b24Message/salesReport/site/sale/item/property[@name="gender"] | Text | None |
2500 | 16 | |||
(Item/Line) : Supplier's Internal Goodsclass | No | The Supplier's own internal goodsclass code, mapped in the portal |
|
/b24Message/salesReport/site/stock/item/property[@name = "goodsClass" AND @registry = "Supplier" AND @set = "suppliergc"]/@code | Text | None |
2600 | 17 | |||
(Item/Line) : Buyer's Internal Goodsclass | No | The Buyer's own internal goodsclass code, mapped in the portal |
|
/b24Message/salesReport/site/stock/item/property[@name = "goodsClass" and @set = "buyergc" and @registry = "Buyer"]/@code | Text | None |
2700 | 18 | |||
(Item/Line) : Fedas Goodsclass | No | Fedas Goodsclass assigned to the product, with 3 different possible registries(party/system that assigned the value), Supplier and Buyer are the only expected registries in a Stockreport |
|
/b24Message/salesReport/site/stock/item/property[@name = "goodsClass" and @set = "Fedas"]@code | Text | None |
2800 | 19 | |||
(Item/Line) : Item Supplier | Yes | GLN of the supplier/brand of the sold/returned item. |
|
/b24Message/salesReport/site/sale/item/supplier/@gln | Number | None |
2900 | 20 | |||
(Item/Line) : Color Code | No | The code of the product colour. |
|
/b24Message/salesReport/site/sale/item/dimension[@name="color" and @code="colorCode"] | Text | None |
3000 | 21 | |||
(Item/Line) : Size | No | The size of the item. |
|
/b24Message/salesReport/site/sale/item/dimension[@name="size"] | Text | None |
3100 | 22 | |||
(Item/Line) : Barcode | Yes | The supplier's EAN/UPC code of the product. |
|
/b24Message/salesReport/site/sale/item/itemReference[@registry="Supplier" and @coding!=""] | Number | None |
3200 | 23 | |||
(Item/Line) : Currency | No | The currency in which the referenced unit price or amount has been specified. All price types reported for the item should be accompanied by an ISO 4217 currency code. |
|
/b24Message/salesReport/site/sale/item/price[@type=""]@currency | Text | *Required if price is included. |
3250 | 69 | |||
(Item/Line) : Gross Sales Amount | No | The total Sales Amount for the sold quantity of the product, excluding discount/markdown, including VAT. |
|
/b24Message/salesReport/site/sale/item/price[@type="grossSalesAmount"]@value | Number | Must equal to gross Sales price times the Sales quantity |
3300 | 24 | |||
(Item/Line) : Gross Sales Price | No | The Gross Retail Sales Price for one unit of the sold product, excluding discount/markdown, including VAT. |
|
/b24Message/salesReport/site/sale/item/price[@type="grossSalesPrice"]@value | Number | None |
3400 | 25 | |||
(Item/Line) : Net Sales Amount | No | The total Retail Sales Amount for the sold quantity of the product after deducted discount/markdown, including VAT. |
|
/b24Message/salesReport/site/sale/item/price[@type="netSalesAmount"]@value | Number | Must be equal to net sales price times the Sales quantity |
3500 | 26 | |||
(Item/Line) : Net Sales Price | No | The Retail Sales Price for one unit of the sold product after deducted discount/markdown, including VAT. |
|
/b24Message/salesReport/site/sale/item/price[@type="netSalesPrice"]@value | Number | None |
3600 | 27 | |||
(Item/Line) : Cost Amount (Sales) | No | 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"]@value | Number | Must be equal to cost sales price times the sales quantity |
3700 | 28 | |||
(Item/Line) : Cost Price (Sales) | No | 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"]@value | Number | None |
3800 | 29 | |||
(Item/Line) : Recommended Retail Price | No | 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"]@value | Number | None |
4000 | 31 | |||
(Item/Line) : Net Return Price | No | 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"]@value | Number | None |
4100 | 32 | |||
(Item/Line) : Net Return Amount | No | 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"]@value | Number | None |
4200 | 33 | |||
(Item/Line) : Gross Return Price | No | The Return Price for one unit of the returned product excluding (possible) fees/charges, including VAT. |
|
/b24Message/salesReport/site/sale/item/price[@type="grossReturnPrice"]@value | Number | None |
4300 | 34 | |||
(Item/Line) : Gross Return Amount | No | 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"]@value | Number | None |
4400 | 35 | |||
(Item/Line) : Cost Amount (Return) | No | 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"]@value | Number | None |
4500 | 36 | |||
(Item/Line) : Cost Price (Return) | No | 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"]@value | Number | None |
4600 | 37 | |||
(Item/Line) : Gross Sales Amount Ex. VAT | No | The total Sales Amount for the sold quantity of the product, excluding discount/markdown, excluding VAT. |
|
/b24Message/salesReport/site/sale/item/price[@type="grossSalesAmountExVAT"]@value | Number | None |
4700 | 38 | |||
(Item/Line) : Gross Sales Amount's VAT amount | No | The gross Sales Amount's VAT Amount |
|
/b24Message/salesReport/site/sale/item/price[@type="grossSalesAmountExVAT"]/property[@name = "vatAmount"] | Number | None |
4800 | 39 | |||
(Item/Line) : Gross Sales Price Ex. VAT | No | The Gross Retail Sales Price for one unit of the sold product, excluding discount/markdown, excluding VAT. |
|
/b24Message/salesReport/site/sale/item/price[@type="grossSalesPriceExVAT"]@value | Number | None |
4900 | 40 | |||
(Item/Line) : Gross Sales Price's VAT amount | No | The Gross Retail Sales Price's VAT Amount |
|
/b24Message/salesReport/site/sale/item/price[@type="grossSalesPriceExVAT"]/property[@name = "vatAmount"] | Number | None |
5000 | 41 | |||
(Item/Line) : Net Sales Amount Ex. VAT | No | 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"]@value | Number | None |
5100 | 42 | |||
(Item/Line) : Net Sales Amount's VAT Amount | No | The net Sales Amount's VAT Amount |
|
/b24Message/salesReport/site/sale/item/price[@type="netSalesAmountExVAT"]/property[@name = "vatAmount"] | Number | None |
5200 | 43 | |||
(Item/Line) : Net Sales Price Ex. VAT | No | The Retail Sales Price for one unit of the sold product after deducted discount/markdown, excluding VAT. |
|
/b24Message/salesReport/site/sale/item/price[@type="netSalesPriceExVAT"]@value | Number | None |
5300 | 44 | |||
(Item/Line) : Net Sales Price's VAT Amount | No | The net Retail Sales Price's VAT Amount |
|
/b24Message/salesReport/site/sale/item/price[@type="netSalesPriceExVAT"]/property[@name = "vatAmount"] | Number | None |
5400 | 45 | |||
(Item/Line) : Cost Amount (Sales) Ex. VAT | No | 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"]@value | Number | None |
5500 | 46 | |||
(Item/Line) : Cost Price (Sales) Ex. VAT | No | 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"]@value | Number | None |
5600 | 47 | |||
(Item/Line) : Recommended Retail Price Ex. VAT | No | 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"]@value | Number | None |
5800 | 49 | |||
(Item/Line) : Net Return Price Ex. VAT | No | 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"]@value | Number | None |
5900 | 50 | |||
(Item/Line) : Net Return Amount Ex. VAT | No | 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"]@value | Number | None |
6000 | 51 | |||
(Item/Line) : Gross Return Price Ex. VAT | No | The Return Price for one unit of the returned product excluding (possible) fees/charges, excluding VAT. |
|
/b24Message/salesReport/site/sale/item/price[@type="grossReturnPriceExVAT"]@value | Number | None |
6100 | 52 | |||
(Item/Line) : Gross Return Amount Ex. VAT | No | 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"]@value | Number | None |
6200 | 53 | |||
(Item/Line) : Cost Amount (Return) Ex. VAT | No | 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"]@value | Number | None |
6300 | 54 | |||
(Item/Line) : Cost Price (Return) Ex. VAT | No | 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"]@value | Number | None |
6400 | 55 | |||
(Item/Line) : Gross Sales Minus Return Amount | No | The total Sales Amount (including VAT) for the sold quantity of the product after deduction for Returns, before deduction for discounts/markdowns/fees/charges. (grossSalesAmount - grossReturnAmount) Negative amount indicates more returns than sales for the item. |
|
/b24Message/salesReport/site/sale/item/price[@type="grossSalesMinusReturnAmount"]@value | Number | 6450 | 66 | ||||
(Item/Line) : Gross Sales Minus Return Amount Ex. VAT | No | The total Sales Amount (excluding VAT) for the sold quantity of the product after deduction for Returns, before deduction for discounts/markdowns/fees/charges. (grossSalesAmountExVAT - grossReturnAmountExVAT)�Negative amount indicate more returns than sales for the item. |
|
/b24Message/salesReport/site/sale/item/price[@type="grossSalesMinusReturnAmountExVAT"]@value | Number | 6460 | 67 | ||||
(Item/Line) : Net Sales Minus Return Amount | No | The total Net Sales Amount (including VAT) for the sold quantity after deductions for sale discounts/markdowns AND Returns with possible charges/fees. (netSalesAmount - netReturnAmount) �Negative amount indicates more returns than sales for the item. |
|
/b24Message/salesReport/site/sale/item/price[@type="netSalesMinusReturnAmount"]@value | Number | 6490 | 64 | ||||
(Item/Line) : Net Sales Minus Return Amount Ex. VAT | No | The total net Sales Amount (excluding VAT) for the sold quantity after deductions for discounts/markdowns AND Returns with possible charges/fees. (netSalesAmountExVAT - netReturnAmountExVAT) Negative amount indicates more returns than sales for the item. |
|
/b24Message/salesReport/site/sale/item/price[@type="netSalesMinusReturnAmountExVAT"]@value | Number | 6495 | 65 | ||||
(Item/Line) : VAT Amount | No | Specified VAT-amount for the referred price element with type. |
|
/b24Message/salesReport/site/sale/item/price/property[@name="vatAmount"] | Number | None |
6500 | 56 | |||
(Item/Line) : Quantity Sales | Yes | The gross sales quantity of the item at the site/store. |
|
/b24Message/salesReport/site/sale/item/quantity[@type="Sales"]@value | Number | None |
6600 | 57 | |||
(Item/Line) : Quantity Return | Yes | The returned quantity of the item at the site/store. |
|
/b24Message/salesReport/site/sale/item/quantity[@type="Return"]@value | Number | None |
6700 | 58 | |||
(Item/Line) : Quantity Sales Minus Return | No | The total transaction�net quantity for the item at the site/store Sales quantity - Return quantity). Negtative quantity indicates more returns than sales for the item. |
|
/b24Message/salesReport/site/sale/item/quantity[@type="SalesMinusReturn"]@value | Number | 6750 | 60 | ||||
(Item/Line) : Quantity Cancel | No | The quantity of the item cancelled at the site. |
|
/b24Message/salesReport/site/sale/item/quantity[@type="Cancel"]@value | Number | None |
6800 | 59 | |||
(Item/Line): Discount Amount | No | The deducted discount amount incl. VAT for the reported transaction (difference between grossSalesAmount - netSalesAmount or grossSalesPrice -netSalesPrice). |
|
/b24Message/salesReport/site/sale/item/price[@type="discountAmount"]@value | Number | None |
7100 | 62 | |||
(Item/Line): Discount Amount Excluding VAT | No | The deducted discount amount excl. VAT for the reported transaction (difference between grossSalesAmountExVAT - netSalesAmountExVAT or grossSalesPriceExVAT - netSalesPriceExVAT) |
|
/b24Message/salesReport/site/sale/item/price[@type="discountAmountExVAT "]@value | Number | None |
7200 | 63 |