on 10-15-2013 6:56 AM
Dear All,
The requirement is, how's two positive condition type makes subtract in sales order.
e.g: suppose in first condition type rate is rs 100
In second condition type rate is rs 50
Net amount should be 50 (100-50)
Please suggest.
Thanks to all,
As jitendra told right but want to confirm is there any standard process?
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Deepak,
In the definition of the condition type subtraction calculation is not available hence you need to assign the routine only to calculate the value.
you may need to use standard routine 11 in Alt cal type field in pricing procedure,you may try with that.
I assume you know how profit margin is calculated.
Similarly you can assign the routine 11 against the ZZ13 condition type in Alt cal type in the pricing procedure.
Check and let me know.
Srinu.
Hi Deepak,
This is very well possible in Standard process.
Condition 1 = ZZ11 = 100 INR (+ Ve)
Condition 2 = ZZ12 = 50 INR ( + Ve)
Another way is to Use Standard Alt Cal Type Routine 12 (XWORKD-XWORKE)
You will achieve desired result.
Regards,
MJ.
Hi Deepak,
Can you share Screenshot of Pricing Procedure where you have done mentioned settings and then in Sales Order Condition Tab where respective conditions are determined?
Based on that we can check why it is not working.
In Normal way, by FROM and TO fields, you can have addition of condition type values. By creation of New condition type with (- Ve) sign and 100 % value referring we have made it negative, so now by FROM and TO fields (Steps) we can have addition of condition type values where it will consider now (-Ve) value.
Regards,
MJ.
Just to add to Mathur, you need to assign the newly developed routine in field Alt Cal type against the condition type ZZ13 in the relevant pricing procedure.
Srinu.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Deepak,
The first condition type can be the base pricePR00 say 100 rs & the second one can be your discount. This discount can be k004.....or any when you define your records, you can have a gross price & then the 2nd condition type as discount & then Net value which is 1 minus 2 the you can do this.
Can you elaborate your query .
Thanks
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Deepak,
In your case mentioned above you will need three condition types
E.g.
Condition 1 = ZZ11
Condition 2 = ZZ12
Condition 3 = ZZ13
Where ZZ11 - ZZ12 = ZZ13
To achieve the above result a new VOFM routine will required to be developed which will take the value from ZZ11 and ZZ12, Calculate the difference and provide that as value to the condition type ZZ13.
Hope this helps.
Jitendra
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
85 | |
7 | |
6 | |
4 | |
3 | |
3 | |
3 | |
3 | |
3 | |
2 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.