Issue with new scale basis ROUTINE

[former_member227920]

Hello All

we have an requirement to determine 3 new condition types CONB,CONC and COND when partner function is V1- commission agent1.

for this we created new requirement routine-852 and given the logic to determine these  new three condition types its working fine.

now the actual requirement is to give the special discount to the commission agents(V1).

we have already a condition type e.g. CONA (modifiable)

1.the value of  CONA will be determined from condition records (25 $)

2.for CONB we use ref cond type as CONA so the value of the CONB will be  same as maintained for CONA (25 $) from condition records (not modifiable)

3. the value of CONC will be based on the logic given in the calculation type 801

calculation is  (CONB-CONA)*100/CONA

to understand this see the below example

condition type      val               val. after change Eg1                         val. after change Eg2                          

CONA                    25                30 (I changed in the order )                    40

CONB                    25                25(since its not modifiable)                    25

CONC                    0                  20(since calc type 801)                          60

COND                    0                   2.4  (but its 2 which is wrong)               3.2 (but I am getting 6 which is wrong)

* As per my under standing the value getting is CONC/10 which is wrong

4.COND should be determined from condition records

as per the requirement the condtion records are (base scale)

from          amount

0               5%

0.1            6%

8               8%

here From is the value of CONC and amount should be % of CONA i.e. in our example it should be 8% of 30=2.4            

** I have created and assigned new scale base routine 909 for COND I have given the Scale type as G= Scales based on formula for COND

I have also activated the routine through the program RV80HGEN

* As per my understanding the value of COND calculating as CONC/10 which is wrong

please suggest me to give the correct LOGIC in the routine 909.

Thanks in advance for your Help

MS

[VeselinaPeykova]

I am a bit confused - if CONC_KWERT = (CONB_KWERT - CONA_KWERT)*100 / CONA_KWERT, then (25-30)*100/30 = -500/30 = 16.67, but you show 20 as correct.

Get the KNUMV for your sales order from VBAK, use KNUMV in KONV and get the values of KWERT, KAWRT and KBETR for your condition records.

Then start checking your calculations (or if you are extremely lazy - debug the routine). A typical mistake is to forget that in the database the values are stored differently to how they are displayed in the pricing condition screen.

Never forget that percentage is stored as decimal*10 (3% is actually 30 in KONV), currencies are always stored with 2 decimals even when they have 0 (1235 IDR is stored as 12.35, but 1235.00 EUR is stored as 1235.00), KAWRT can be in KONV the same as in VA03, but it can be divided by 10 - it depends on your condition type setup.

You can get rounding errors - I try to minimize them as much as possible by multiplication/division - each case is individual, but usually, I use division at the last possible step.

[former_member227920]

Hi veselina

thanks for your reply

the conc is = 20. the formula I gave above has small mistake

conc= conb-cona*100/conb

the issue is its showing 0 at value afterchange eg1