xml Business Intelligence Sales

The Business Intelligence Sales message intent is to provide sales information for one or more locations for a series of products within a specified time period.

General usage

- It allows 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 Business Intelligence Sales message

# Field Name Required Field Description Xpath Example
1 Sender Yes The sender of the EDI message, identified by a GLN. /b24Message/salesReport/sender/#gln 
<sender gln="1111111111111">
2 Recipient Yes The recipient of the EDI message, identified by a GLN. /b24Message/salesReport/recipient/#gln 
<recipient gln="2222222222222">
3 Document Number   Sales report ID for the whole transaction. /b24Message/salesReport/documentReference[@documentType="salesReport"]/@id 
<documentReference documentType="salesReport" id="SALES-123" date="2018-03-21">
4 Document Date   Sales report date. /b24Message/salesReport/documentReference[@documentType="salesReport"]/@date 
<documentReference documentType="salesReport" id="SALES-123" date="2018-03-21">
5 Buyer Yes The reseller group/HQ, identified by a GLN. /b24Message/salesReport/buyer/#gln 
<buyer gln="1111111111111">
6 Site Yes The store in which the goods were sold, identified by a GLN. /b24Message/salesReport/site/location/#gln 
<location gln="3333333333333">
7 Sales date Yes Date and time when the sale took place. /b24Message/salesReport/site/sale/#date 
<sale date="2018-03-21T13:31:20" id="XY1234567">
8 Sales ID   ID of the sale transaction, receipt/terminal number. /b24Message/salesReport/site/sale/#id 
<sale date="2018-03-21T13:31:20" id="XY1234567">
9 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"] 
<property name="description">Sun Cap-Yellow-OneSize</property>
10 Brand   The brand name of the product /b24Message/salesReport/site/sale/item/property[@name="brand"] 
<property name="brand">BrandWear</property>
11 Model number   The model number of the product. (suppliers model number) /b24Message/salesReport/site/sale/item/property[@name="modelNo"] 
<property name="modelNo">45678</property>
12 Model color   The supplier's unique model and color ID of the product. /b24Message/salesReport/site/sale/item/property[@name="modelColor"] 
<property name="modelColor">45678-511</property>
13 Gender category   The gender category, such as: Men, Woman, Unisex, Boys/Girls or Kids. /b24Message/salesReport/site/sale/item/property[@name="gender"] 
<property name="gender">UNISEX</property>
14 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"] 
<property name="goodsClass" set="Fedas" code="275011">275011 </property>
15 Supplier Yes The supplier/brand, identified by a GLN. /b24Message/salesReport/supplier/#gln 
<supplier gln="2222222222222">
16 Color code   The code of the product colour. /b24Message/salesReport/site/sale/item/dimension[@name="color"] 
<dimension name="color">Yellow</dimension>
17 Size   The size of the item. /b24Message/salesReport/site/sale/item/dimension[@name="size"] 
<dimension name="size">ONESIZE</dimension>
18 Barcode with type   The supplier's EAN/UPC code of the product. /b24Message/salesReport/site/sale/item/itemReference[@registry="Supplier" and @coding="EAN13"] 
<itemReference registry="Supplier" coding="EAN13">1234567891112</itemReference>
19 Gross sales amount   The total sales amount for the sold quantity of the product, including VAT- /b24Message/salesReport/site/sale/item/price[@type="grossSalesAmount" and @value] 
<price type="grossSalesAmount" value="100.00" currency="SEK">
20 Gross sales price   The sales price for one unit of the sold product, including VAT /b24Message/salesReport/site/sale/item/price[@type="grossSalesPrice" and @value] 
<price type="grossSalesPrice" value="100.00" currency="SEK">
21 Net sales amount   The total sales amount for the sold quantity of the product, ?excluding VAT. /b24Message/salesReport/site/sale/item/price[@type="netSalesAmount" and @value] 
<price type="netSalesAmount" value="75.00" currency="SEK">
22 Net sales price   The sales price for one unit of the sold product, including VAT /b24Message/salesReport/site/sale/item/price[@type="netSalesPrice" and @value] 
<price type="netSalesPrice" value="75.00" currency="SEK">
23 Cost amount   The total cost for sold quantity of the product. /b24Message/salesReport/site/sale/item/price[@type="costAmount" and @value] 
<price type="costAmount" value="50.00" currency="SEK">
24 Cost price   The cost price for one unit of the sold quantity of the product. /b24Message/salesReport/site/sale/item/price[@type="costPrice" and @value] 
<price type="costPrice" value="50.00" currency="SEK">
25 Recommended retail price   Recommended retail price including VAT /b24Message/salesReport/site/sale/item/price[@type="recRetailPrice" and @value] 
<price type="recRetailPrice" value="100.00" currency="SEK">
26 Net return price   The return price for one unit of the sold product, including VAT /b24Message/salesReport/site/sale/item/price[@type="netReturnPrice" and @value] 
<price type="netReturnPrice" value="75.00" currency="SEK">
27 Net return amount   The total return amount for the sold quantity of the product, ?excluding VAT. /b24Message/salesReport/site/sale/item/price[@type="netReturnAmount" and @value] 
<price type="netReturnAmount" value="75.00" currency="SEK">
28 Gross return price   The return price for one unit of the sold product, including VAT /b24Message/salesReport/site/sale/item/price[@type="grossReturnPrice" and @value] 
<price type="grossReturnPrice" value="100.00" currency="SEK">
29 Gross return amount   The total return amount for the sold quantity of the product, including VAT- /b24Message/salesReport/site/sale/item/price[@type="grossReturnsAmount" and @value] 
<price type="grossReturnAmount" value="100.00" currency="SEK">
30 Quantity Sales   The quantity of the item sold at the site. /b24Message/salesReport/site/sale/item/quantity[@type="Sales" and @value] 
<quantity type="Sales">1</quantity>
31 Quantity Return   The quantity of the item returned at the site. /b24Message/salesReport/site/sale/item/quantity[@type="Return" and @value] 
<quantity type="Return">1</quantity>
32 Quantity Cancel   The quantity of the item cancelled at the site. /b24Message/salesReport/site/sale/item/quantity[@type="Cancel" and @value] 
<quantity type="Cancel">1</quantity>