Skip to Content
author's profile photo Former Member
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.

Add a comment
10|10000 characters needed characters exceeded

Related questions

1 Answer

  • Best Answer
    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.

    Hope this will help you.

    Regards, Krishna.

    Add a comment
    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

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.