Logic to write routine

[Former Member]

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.

[former_member184080 · Accepted solution]

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.

[Former Member · Accepted solution]

Hi,

To add what Mr. Krishna said, Assign Subtotal 'D' to ZTAG, subtotal 'E' to PR00,

Step     Cn Typ                              From     To          Amount        Subtotal       Alt Cal Typ

10          ZTAG                                                              1200          D

20          PR00                                                                360           E

30                         Difference          10          20             840                                  12

40          ZDIV                                  30         30             -840                                 80

If ZDIV has to be populated automatically maintain a condition record with 100% for lets say Sales org acc seq.

Hope this will help.

Regards,

Sridhar.

[Former Member · Accepted solution]

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