Body

xml 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.

 <sender gln="1111111111111"> 

/b24Message/salesReport/sender/#gln

100 100
Recipient Yes

The recipient of the EDI message, identified by a GLN.

 <recipient gln="2222222222222"> 

/b24Message/salesReport/recipient/#gln

200 200
Document Number

Sales report ID for the whole transaction.

 <documentReference documentType="SalesReport" id="SAL-123" date="2022-03-21"> 

/b24Message/salesReport/documentReference[@documentType="salesReport"]/@id

300 300
Document Date

Sales report date.

 <documentReference documentType="SalesReport" id="SAL-123" date="2022-03-21"> 

/b24Message/salesReport/documentReference[@documentType="salesReport"]/@date

400 400
Buyer Yes

The buyer, identified by a GLN.

 <buyer gln="1111111111111"> 

/b24Message/salesReport/buyer/#gln

500 500
Site Yes

The store in which the goods were sold, identified by a GLN.

 <location gln="3333333333333"> 

/b24Message/salesReport/site/location/#gln

600 600
Sale Date

Date and time when the sale took place.

 <sale date="2022-03-21T13:31:20" id="XY1234567"> 

/b24Message/salesReport/site/sale/#date

700 700
Sale ID

Unique ID of the sale transaction, (typically including terminal+receipt-number).

 <sale date="2022-03-21T13:31:20" id="XY1234567"> 

/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.

 <sale date="2022-03-21T13:31:20" id="XY1234567" salesAssociate="987879"> 

/b24Message/salesReport/site/sale/#salesAssociate

900 900
SKU Description

The supplier's SKU description for the product. Preferably including: model name, colour and size.

 <property name="description">Sun Cap-Yellow-OneSize</property> 

/b24Message/salesReport/site/sale/item/property[@name="description"]

1000 1000
Brand

The brand name of the product.

 <property name="brand">BrandWear</property> 

/b24Message/salesReport/site/sale/item/property[@name="brand"]

1100 1100
Model Number

The model number of the product. (suppliers model number)

 <property name="modelNo">45678</property> 

/b24Message/salesReport/site/sale/item/property[@name="modelNo"]

1200 1200
Model Color

The supplier's unique model and color ID of the product.

 <property name="modelColor">45678-511</property> 

/b24Message/salesReport/site/sale/item/property[@name="modelColor"]

1300 1300
Gender Category

The gender category, such as: Men, Woman, Unisex, Boys/Girls or Kids.

 <property name="gender">UNISEX</property> 

/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.

 <property name="goodsClass" set="Fedas" code="275011">275011 </property> 

/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.

 <supplier gln="2222222222222"> 

/b24Message/salesReport/site/sale/item/supplier/#gln

Number 1600 1600
Color Code

The code of the product colour.

 <dimension name="color" code="511">Yellow</dimension> 

/b24Message/salesReport/site/sale/item/dimension[@name="color" and @code="colorCode"]

1700 1700
Size

The size of the item.

 <dimension name="size">ONESIZE</dimension> 

/b24Message/salesReport/site/sale/item/dimension[@name="size"]

1800 1800
Barcode with Type Yes

The supplier's EAN/UPC code of the product.

 <itemReference registry="Supplier" coding="EAN13">1234567891112</itemReference> 

/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.

 <price type="grossSalesAmount" value="897.00" currency="SEK"> 

/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.

 <price type="grossSalesPrice" value="299.00" currency="SEK"> 

/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.

 <price type="netSalesAmount" value="747.51" currency="SEK"> 

/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.

 <price type="netSalesPrice" value="249.17" currency="SEK"> 

/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.

 <price type="costAmountSales" value="180.00" currency="SEK"> 

/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.

 <price type="costPriceSales" value="90.00" currency="SEK"> 

/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)

 <price type="retailPrice" value="299.00" currency="SEK"> 

/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)

 <price type="recRetailPrice" value="300.00" currency="SEK"> 

/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.

 <price type="netReturnPrice" value="271.82" currency="SEK"> 

/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.

 <price type="netReturnAmount" value="543.64" currency="SEK"> 

/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.

 <price type="grossReturnPrice" value="299.00" currency="SEK"> 

/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.

 <price type="grossReturnAmount" value="598.00" currency="SEK"> 

/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.

 <price type="costAmountReturn" value="180.00" currency="SEK"> 

/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.

 <price type="costPriceReturn" value="90.00" currency="SEK"> 

/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.

 <price type="grossSalesAmountExVAT" value="717.60" currency="SEK"> 

/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.

 <price type="grossSalesPriceExVAT" value="239.20" currency="SEK"> 

/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.

 <price type="netSalesAmountExVAT" value="598.01" currency="SEK"> 

/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.

 <price type="netSalesPriceExVAT" value="199.34" currency="SEK"> 

/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.

 <price type="costAmountSalesExVAT" value="144.00" currency="SEK"> 

/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.

 <price type="costPriceSalesExVAT" value="72.00" currency="SEK"> 

/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)

 <price type="retailPriceExVAT" value="239.20" currency="SEK"> 

/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)

 <price type="recRetailPriceExVAT" value="240.00" currency="SEK"> 

/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.

 <price type="netReturnPriceExVAT" value="217.46" currency="SEK"> 

/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.

 <price type="netReturnAmountExVAT" value="434.91" currency="SEK"> 

/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.

 <price type="grossReturnPriceExVAT" value="239.20" currency="SEK"> 

/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.

 <price type="grossReturnAmountExVAT" value="478.40" currency="SEK"> 

/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.

 <price type="costAmountReturnExVAT" value="144.00" currency="SEK"> 

/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.

 <price type="costPriceReturnExVAT" value="72.00" currency="SEK"> 

/b24Message/salesReport/site/sale/item/price[@type="costPriceReturnExVAT" and @value]

4700 4700
VAT Amount

Specified VAT-amount for the referred price element with type.

 <property name="vatAmount">49.83</property> 

/b24Message/salesReport/site/sale/item/price/property[@name="vatAmount"]

4800 4800
Quantity Sales Yes

The quantity of the item sold at the site.

 <quantity type="Sales">3</quantity> 

/b24Message/salesReport/site/sale/item/quantity[@type="Sales" and @value]

4900 4900
Quantity Return Yes

The quantity of the item returned at the site.

 <quantity type="Return">2</quantity> 

/b24Message/salesReport/site/sale/item/quantity[@type="Return" and @value]

5000 5000
Quantity Cancel

The quantity of the item cancelled at the site.

 <quantity type="Cancel">1</quantity> 

/b24Message/salesReport/site/sale/item/quantity[@type="Return" and @value]

5100 5100