When two conditions are linked together in condition definitions, "&" and "|" operators meaning (and) and (or) respectively must be used.
"10% discount" campaign for SANA (a margarine brand) lines
Conditioning Material Code |
Condition |
Formula |
Type |
Material (Class) Code |
Unit |
Type |
SANA |
1 |
P1*0,10 |
- |
|
|
To Line |
"1 SANA for 7 SANA" campaign (The condition is met if there are more than 7 SANA products in one line. The campaign is applied to and the campaign link is kept in all lines with Quantity>=7.)
Conditioning Material Code |
Condition |
Formula |
Type |
Material (Class) Code |
Unit |
Type |
SANA |
P4>=7 |
1 |
P |
SANA |
QUANTITY |
To Line |
"1 SANA for 7 SANA" campaign (The condition is met if there are more than 7 SANA products in the slip bottom and the promotion is applied to the slip bottom. The campaign is linked to SANA lines only.)
Conditioning Material Code |
Condition |
Formula |
Type |
Material (Class) Code |
Unit |
Type |
|
FICLC ("SANA", 1)>=7 |
1 |
P |
SANA |
QUANTITY |
To Bottom |
"1 SANA for 7 SANA" campaign (The condition is met if there are more than 7 SANA products in the slip bottom and the promotion is applied to the slip bottom. The campaign is linked to SANA lines only.)
Conditioning Material Code |
Condition |
Formula |
Type |
Material (Class) Code |
Unit |
Type |
|
FICLC ("SANA", 1)>=7 |
1 |
P |
RAMA |
QUANTITY |
To Bottom |
"1 IRON for 7 SANA" campaign (The condition is met if there are more than 7 SANA products in the slip bottom and the promotion is applied to the slip bottom. The campaign is linked to SANA lines only.)
Conditioning Material Code |
Condition |
Formula |
Type |
Material (Class) Code |
Unit |
Type |
|
FICLC ("SANA", 1)>=7 |
1 |
P |
IRON |
QUANTITY |
To Bottom |
10% discount of the slip gross total for 7 SANA products campaign (The condition is met if there are more than 7 SANA products in the slip bottom and 10% discount is applied. The campaign is linked to SANA lines only.)
Conditioning Material Code |
Condition |
Formula |
Type |
Material (Class) Code |
Unit |
Type |
|
FICLC ("SANA", 1)>=7 |
P20*0,10 |
- |
|
|
To Bottom |
"10% discount of the line amount for 7 SANA product" campaign (The condition is met if there are more than 7 SANA products in the slip bottom and 10% discount is applied. The campaign is linked to SANA lines only.)
Conditioning Material Code |
Condition |
Formula |
Type |
Material (Class) Code |
Unit |
Type |
SANA |
FICLC ("SANA", 1)>=7 |
P1*0,10 |
- |
|
|
To Line |
1 IRON for all purchases of 3 SANA, 2 OMO and 2 of the materials belonging to BUTTERS Parent Material Class Code (If the condition is met in the slip bottom, the IRON promotion is applied to the slip bottom. The campaign link is kept only for the material lines belonging to OMO, SANA and BUTTER classes.)
Conditioning Material Code |
Condition |
Formula |
Type |
Material (Class) Code |
Unit |
Type |
|
(FICLC ("SANA", 1)>=3) & (FICLC("OMO",1)>=2) & (FPCLC("YAĞLAR",1)>=2) |
1 |
P |
IRON |
QUANTITY |
To Bottom |
1 IRON for all purchases of 3 SANA, 2 OMO and 2 of the materials belonging to BUTTERS Parent Material Class Code (If the condition is met in the slip bottom, the IRON promotion is applied to all the slip lines and the campaign link is kept for all the lines.)
Conditioning Material Code |
Condition |
Formula |
Type |
Material (Class) Code |
Unit |
Type |
* |
(FICLC ("SANA", 1)>=3) & (FICLC("OMO",1)>=2) & (FPCLC("YAĞLAR",1)>=2) |
1 |
P |
IRON |
QUANTITY |
To Line |
Line amount* 0.10 discount if SANA or OMO quantity is bigger than 3 (The discount is applied to every line once the condition is met in the Slip Bottom.)
Conditioning Material Code |
Condition |
Formula |
Type |
Material (Class) Code |
Unit |
Type |
* |
(FICLC ("SANA", 1)>=3) ׀ (FICLC("OMO",1)>=3) |
P1*0,10 |
- |
|
|
To Line |
Line amount* 0.10 discount if SANA or OMO quantity is bigger than 3 (For the discount to be applied to this line, at least one of the two conditions must be met.) In this case, if the slip contains both materials, and the material quantities are bigger than 3, the discount is applied to only SANA line.)
Conditioning Material Code |
Condition |
Formula |
Type |
Material (Class) Code |
Unit |
Type |
SANA |
FICLC ("SANA", 1)>=3 |
P1*0,10 |
- |
|
|
To Line |
OMO |
(FICLC("OMO",1)>=3) & (FICLC ("SANA", 1)<3) |
P1*0,10 |
- |
|
|
To Line |
1% discount of the AR/AP debit balance for all purchases of 3 SANA, 2 OMO and 2 of the materials belonging to BUTTERS Parent Material Class Code (If the condition is met in the slip bottom, the IRON promotion is applied to the slip bottom. The campaign link is kept only for the material lines belonging to OMO, SANA and BUTTER classes.)
Conditioning Material Code |
Condition |
Formula |
Type |
Material (Class) Code |
Unit |
Type |
|
(FICLC ("SANA", 1)>=3) & (FICLC("OMO",1)>=2) & (FPCLC("YAĞLAR",1)>=2) |
P44*0,01 |
- |
|
|
To Bottom |
1% discount if the AR/AP debit balance is higher than 100.000.000 (The lines are not linked to the campaign.)
Conditioning Material Code |
Condition |
Formula |
Type |
Material (Class) Code |
Unit |
Type |
|
P44>100,000,000 |
P44*0,01 |
- |
|
|
To Bottom |
1% discount if the Slip Amount is higher than 100.000.000 (The lines are not linked to the campaign.)
Conditioning Material Code |
Condition |
Formula |
Type |
Material (Class) Code |
Unit |
Type |
|
P20>100,000,000 |
P20*0,01 |
- |
|
|
To Bottom |
1% discount if the Slip Amount is higher than 100.000.000 (All lines are linked to the campaign.)
Conditioning Material Code |
Condition |
Formula |
Type |
Material (Class) Code |
Unit |
Type |
|
FICLC("*",3)>=2 |
P20*0,01 |
- |
|
|
To Bottom |
"1 toothbrush+1 toothpaste for 3 SANA" campaign (The promotion is applied to the slip bottom once the condition is met in the slip bottom. The SANA lines are linked to the campaign.)
Conditioning Material Code |
Condition |
Formula |
Type |
Material (Class) Code |
Unit |
Type |
|
FICLC ("SANA", 1)>=3 |
1 |
P |
Toothbrush |
QUANTITY |
To Bottom |
|
FICLC ("SANA", 1)>=3 |
1 |
P |
Toothpaste |
QUANTITY |
To Bottom |
"1 IRON if the sales amount in the slip bottom is 20.000.000" campaign (The promotion is applied to the slip bottom. All lines are linked to the campaign.)
Conditioning Material Code |
Condition |
Formula |
Type |
Material (Class) Code |
Unit |
Type |
|
FICLC ("*",3) >= 20,000,000 |
1 |
P |
IRON |
QUANTITY |
To Bottom |
"1 IRON if the sales amount in the OMO slip bottom is 20.000.000" campaign (The promotion is applied to the slip bottom. OMO lines are linked to the campaign.)
Conditioning Material Code |
Condition |
Formula |
Type |
Material (Class) Code |
Unit |
Type |
|
FICLC("OMO",3)=20,000,000 |
1 |
P |
IRON |
QUANTITY |
To Bottom |
Although this example is quite similar with the previous one, it would generate incorrect results since the campaign type is selected as To Line. In this way, once the condition is met in the slip bottom, the IRON promotion will be applied to all lines.
Conditioning Material Code |
Condition |
Formula |
Type |
Material (Class) Code |
Unit |
Type |
* |
FICLC("OMO",3)=20,000,000 |
1 |
P |
IRON |
QUANTITY |
To Line |
"1 Iron if the line sales amount of OMO is 20.000.000" campaign (This can be considered as an example of incorrect line parameter usage. For any OMO line with an amount higher than 20.000.000 an IRON will be given to the slip bottom as promotion.)
Conditioning Material Code |
Condition |
Formula |
Type |
Material (Class) Code |
Unit |
Type |
OMO |
P1=20,000,000 |
1 |
P |
IRON |
QUANTITY |
To Bottom |
1 IRON for all purchases of 3 SANA, 2 OMO and 2 of the materials belonging to BUTTERS Parent Material Class Code, provided that the total sales amount is more than 20.000.000 (If the condition is met the promotion is applied to the slip bottom and the campaign link is kept only for the related material lines.)
Conditioning Material Code |
Condition |
Formula |
Type |
Material (Class) Code |
Unit |
Type |
|
(FICLC ("SANA", 1)>=3) & (FICLC("OMO",1)>=2) & (FPCLC("YAĞLAR",1)>=2) & ((FICLC("OMO",2)FCLC("SANA",2) FPCLC("YAĞLAR",2))=20,000,000) |
1 |
P |
IRON |
QUANTITY |
To Bottom |
1 IRON for all purchases of 3 SANA, 2 OMO and 2 of the materials belonging to BUTTERS Parent Material Class Code, provided that the total sales amount is more than 20.000.000 (The promotion is applied to the slip bottom and the campaign is linked to all the lines.)
Conditioning Material Code |
Condition |
Formula |
Type |
Material (Class) Code |
Unit |
Type |
|
(FICLC ("SANA", 1)>=3) & (FICLC("OMO",1)>=2) & (FPCLC("YAĞLAR",1)>=2) & (P20=20,000,000) |
1 |
P |
IRON |
QUANTITY |
To Bottom |
Gross total* 0.10 discount for slips meeting the general criteria of the campaign (The lines are not linked to the campaign.)
Conditioning Material Code |
Condition |
|
Formula |
Type |
Material (Class) Code |
Unit |
Type |
|
|
1 |
P20*0,10 |
- |
|
|
To Bottom |
A discount of 1.000.000 for slips meeting the general criteria of the campaign (The lines are not linked to the campaign.)
Conditioning Material Code |
Condition |
Formula |
Type |
Material (Class) Code |
Unit |
Type |
|
1 |
1,000,000 |
- |
|
|
To Bottom |
A discount of 10% of the gross total in groceries (The lines are not linked to the campaign.)
Conditioning Material Code |
Condition |
Formula |
Type |
Material (Class) Code |
Unit |
Type |
|
((P106= "BAKKALLAR") ׀ (P106= "MARKETLER")) |
P20*0,10 |
- |
|
|
To Bottom |
10% discount for slips of which the AR/AP is "ALİ BAKKAL" or "VELİ BAKKAL" (the names of the grocery stores) (The discount is applied to the slip bottom, and the lines are not linked to the campaign.)
Conditioning Material Code |
Condition |
Formula |
Type |
Material (Class) Code |
Unit |
Type |
|
P105= "ALİ BAKKAL" ׀ P105= "VELİ BAKKAL" |
P20*0,10 |
- |
|
|
To Bottom |
10% discount for slips of which the AR/AP is "ALİ BAKKAL" or "VELİ BAKKAL" (the names of the grocery stores) (The discount is applied to all the lines, and the lines are not linked to the campaign.)
Conditioning Material Code |
Condition |
Formula |
Type |
Material (Class) Code |
Unit |
Type |
|
P105= "ALİ BAKKAL" ׀ P105= "VELİ BAKKAL" |
P20*0,10 |
- |
|
|
To Line |
"A RADIO if the Slip Amount is 20.000.000 and a TV if the Slip Amount is 40.000.000" campaign
Conditioning Material Code |
Condition |
Formula |
Type |
Material (Class) Code |
Unit |
Type |
|
P20>=40,000,000 |
Div(V2/40,000,000) |
P |
TV |
QUANTITY |
To Bottom |
|
P20>=20,000,000 |
Div((V2- |
P |
RADIO |
QUANTITY |
To Bottom |
For instance, if the slip amount is 150.000.000, the gifts won as a result of formula application would be:
Div (P20/40,000,000)= Div (150,000,000/40,000,000)=3 TVs
Div ((P20- Div (P202/40,000,000)*40,000,0000)/20,000,000)=
Div ((150,000,000- Div (150,000,000/40,000,000)*40,000,0000)/20,000,000)=
Div ((150,000,000 – 3*40,000,000)/20,000,000) =
Div ((150,000,000-120,000,000)/20,000,000) = Div (30,000,000/20,000,000)=1 RADIO
Point Promotion
Conditioning Material Code |
Condition |
Formula |
Type |
Material (Class) Code |
Unit |
Type |
OMO |
1 |
P4*1 |
Point |
|
QUANTITY |
|
SANA |
1 |
P4*2 |
Point |
|
QUANTITY |
|
RAMA |
1 |
P4*3 |
Point |
|
QUANTITY |
|
OILS |
1 |
P4*10 |
Point |
|
QUANTITY |
|
|
1 |
P4*100 |
Point |
TV |
QUANTITY |
|
The point campaign is different from other campaign types. The points of the materials within the campaign, and the gifts to be won with these points are defined in the campaign. The user must select the line type as Point for materials generating points, and indicate the material code in the Conditioning Material (Class) Code column. The Point
is selected while the points of the gifts are defined, and the code of the gift is specified in the Material (Class) Code column.