Calculate a value automatically

[Former Member]

Dear all,

I want a value to be automatically calculated and put it to a certain condition.

P001 Basic Price = 500

ZPP1 Price 1 = 100

ZPP2 Price 2 = 700

ZPP3 = AUTO

Now, the ZPP3 should be auto calculated on this formula =  700 - (500-100)

ZPP3 - Calculation type used is G Formula.

Can this be done through any routine?

Regards,

Lakhya

[BijayKumarBarik]

Hi,

You know your formula of  calculation  with result, so you can design a routine( where you have formula for calculation) and  assign to ZPP3 condition type by keeping that routine in BaseType or CalType Column in your MM Pricing procedure(M/08). For detailed design  of your routine,better discuss with technical consultant.

Regards,

Biju K

[joao_sousa2]

 assign to ZPP3 condition type by keeping that routine in BaseType or CalType Column in your MM Pricing procedure(M/08)

He wants to calculate the end value so he should use CalType, not BaseType. Although in some situations the end result is the same, it's very important that people know the difference.

You should use BaseType when you want to determine the base value for a calculation, as is usual with percentage conditions, or when you want to define the distribution criteria for header conditions.

Let's say I have a 10% discount which is determined automatically using access sequences, but I need to programmatically set the base value on which the 10% will be calculated. That's when you use BaseType formulas.

[kunal_ingale]

Hi Lakhya ,

This can be done by placing the negative signs in the conditions and then applying the form and to filed along with subtotals.

or you can use Subtotals like D , E and 12

Try below solution ,

Take subtotal of con1 assign the subtotal as D then con2 and subtotal as E then in alt cal as 12 .

you can search on net for Substracting conditions in schema

thanks

Kunal

[Former Member]

Thanks Kunal. Sometimes, our brain becomes dead...........

However, can a real value be negative?

I have a antidumping duty say $700, Now the Applicable dumping duty will be equal to

antidumping duty - basic price*Basic Custom.

I was wandering if I can bring the Applicable anti dumping value automatically.

However, your answer will help. I will take one value to D another to E (basic price*Basic Custom) and do the subtraction.

Hope it is correct.

Regards,

[Former Member]

Hi,

yes this can be dome in calculation schema i think you want to use this calculation procedure in Purchasing document . please refer this very use full document .

Regards,

mukesh

[Former Member]

Thanks Mukesh. Very nice document indeed.

"yes this can be dome in calculation schema" - Could you please let me know how to calculate a value automatically through a formula and auto fill the value.

[Former Member]

HI,

you have to configure calculation schema as follows

step

1.      P001 Basic Price = 500

2.     ZPP1 Price 1 = 100(this condition should be negative as you can see in first screen)

3.     newcondition=from step1 to step2(this should also be negative)

4.     ZPP2 Price 2 = 700

5.     ZPP3 = from step4 to step3

[Former Member]

Does Step no 3 and No 5 having a condition type will calculate value automatically?