Commission calculation in pricing procedure

[Former Member]

Hi friends,

There is a formula calculating commission how to do

1.price 10000

- Discount for commission agent

20% 2000 (Depending upon commission agent)

-

---

price 8000

Commission 7.5 % 600 8000*7.5%

-

---

7400

If he sells 8000 then commission agent will get fixed 600 rs.

Suppose if he sells more than 8,000 then commission formula has to work.

1.Mrp price- 10000

Discount for

commission agent20 % 2000

-

---

2.Comission agent price 8000

3.Customer rate 9000

Then commission structure will change

(Customer rate - Commission agent price)*100/ customer rate =

9000-8000*100/9000= 11.11 %

Extra commission to commission agent=(11.11-7.5)/2 = 1.80 %

Total commission for commission agent =7.5+1.8=9.3 %

9.3 % on customer rate 9000*9.3%=837.00 rs.

Commission will calculate in pricing procedure also commission has to post

GL account.

[Former Member]

hi

use scales in condition records creation and mainatain the formula in alternative caluculation type in pricing procedure for the discounts

hope it helps

giri

[Former Member]

Hi friend,

I know using alternative calculation type it is possible

but there are 3 prices

1.Mrp price

2.Commission agent price

3.Cusomer rate

If i maintain condition record for Mrp price then i will get commission agent price

then based on that customer rate i will enter manually then how to create routine.