Former Member

# Logic to write routine

Dear Experts,

Need your help too write routing below is my requirmment.

Condition Type Description Amount ZTAG Tag Price 1,200 ZDIV Normal Discount -840 PR00 Price 360

Where in ZDIV = PR00- ZTAG.

Please Note: When customer is putting ZTAG value and PR00 value then ZDIV condition with value should automaticaly update while creating order.

Kindly guid me with coding detail for the same.

Thanks & Regards,

Geeta Singh.

Conatct No:- +919820051350.

10|10000 characters needed characters exceeded

### Related questions

Posted on May 02, 2012 at 09:57 AM

Have you assigned any Sub totals for PR00 & ZTAG ? First, you need to create ZDIV as formula based condition type. You can write a logic " Sub total of PR00 - Subtotal of ZTAG should be the value of ZDIV.

Regards, Krishna.

10|10000 characters needed characters exceeded
• Former Member Former Member

Thanks Mr Sridhar. im very happy i applied your logic and it is successful ..

Thanks & Regards,

Geeta Singh.

One more query i have in same pricing procedure ...

Beloe is my Pricing procedure :

Condition Type Description Amount Reference KE24 ZTAG Tag Price 1,200 Tag Price ZDIV Normal Discount -840 Trade Discount PR00 Price 360 Revenue RP00 Repair Charges 100 Repair Charges RDIV Repair Charges - Discounts -20 Repair Chgs - Discount ZNRA Free Goods -90 Free Goods Net Value 1 350 ZHA0 Additional Discount (%) -20 Spl Offer Discount ZHB0 Volume Discount -50 Material Discount Gross Value 280 ZH01 Freight Charge 30 DSC Frieght ZH02 Insurance Charge 45 DSC Insurance ZH03 Packing Charge 30 DSC Packing ZH04 Courier Cost 25 DSC Frieght ZH05 Miscellaneous Charges 20 DSC Misc Charges Net Value 2 430 MWST Output Tax 30 Total 460 VPRS Internal Price 180 Stock Value Net Difference 280 Gross Margin 100 Gross Margin % 36%

1:- ANet Difference: bove is my requirment where in NET difference is : Total(460) - VPRS (180) = 280, to get this value i have created another condition type ZVRS (copy of VPRS) and maintained condition records as -100% (To get value of VPRS as Negative) BUT THIS LOGIC IS NOT WORKING.

2:- Gross Margin: Gross Value (280) - VPRS (Internal price-180) = 100.Kindly provide the logic.

3:- Gross Margin % : Gross Margine/ Gross value .

Thanks & Regards,

Geeta Singh.

Contact number: +919820051350