Urgent Please help......... Condition Formula

[Former Member]

Hi all,...

Can you pkeae help me with what i have to do with this requirement,.. Please give me the fields to update in the condition routine.

For a material i have to take the order quantity ( VBAP - KWMENG ) / Pallet Qty ( MARM -UMREZ ).,

Here is how it should work... I did not understand what field to update... What should i assign Order Qty / Pallet Qty ...

Here’s an example of how it should work: If the pallet quantity is 25 and the order quantity is 55

Price for each unit is $2.00

Total price = 55 * 2.00 = $110.00

Total number of pallets = 2.2 (55/25)

The % discount from the condition record should be applied on only 2 pallet quantities for 50 units.

The condition value would be 50 * $2 = $100 and the % is applied on the $100. So if the % was 3.00

the condition value is $3.00. The net value of the line is at subtotal 2 or KZWI2.

Thank you all.. I ll surely reward points..

[jiteshmehta]

Hi Soniya

Why don't you copy KP00- Pallet Discount and change in V/06 calculation type to A-Percentage instead of C-Quantity.

Now your concern is % is on Order Quantity and Not on Pallet Quantity???

Then you can have AltCBV as Order quantity and check

If it doesn't satisfy than AltCTY has to be created

Regards

Jitesh