on 11-12-2009 4:58 AM
Hi,
I would like to seek suggestions on how to add a pricing formula in variant configuration. The scenario for material Elevator is as below
Characteristics:
1. Stops (N) = 3
2. Rope(R) = 5
pricing for characteristic A = 200 + 10 * N + 5* R
Result = $ 255
Please advice how I can maintain this formula and how to populate value from VK11 as the pricing value(200) can also change .
Regards
Rasheed
Hi
Characteristics:
1. Stops (N) = 3
2. Rope(R) = 5
pricing for characteristic A = 200 + 10 * N + 5* R
Result = $ 255
If 200 is not a fixed price, means coming from VK11, then its not possible to code this logic in Variant configuration.
Alternative solution is:
let the system fetch 200 from Vk11 with pricing variant 'P1'.
And goto VOFM>formulae>condition value.
Write a new routine to fetch variant char value for 1. Stops (N) = 3
2. Rope(R) = 5, store it in local variable.
Calculate pricing for characteristic A = P1 + 10 * N + 5* R.
Assign this routine to your condition type in your pricing procedure.
try and revert
Edited by: Yadav on Nov 12, 2009 8:22 AM
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Yadav,
I shall try the method you have mentioned when my value 200 is coming from VK11
there are some cases where the value might be constant. So how do i calculate that value and push it to the pricing condition.
In the same case, is there a possibility where the characteristic value entered by the user goes straight to the pricing condition.
Regards
Rasheed
Hi Raseed
Best practice is to use routine for your requirement.
Alternative solution is:
let the system fetch 200 from Vk11 with pricing variant 'P1'.
And goto VOFM-->formulae-->condition value.
Write a new routine to fetch variant char value for 1. Stops (N) = 3
2. Rope(R) = 5, store it in local variable.
Calculate pricing for characteristic A = P1 + 10 * N + 5* R.
Assign this routine to your condition type in your pricing procedure.
It will work 100%.
Hi Yadav,
Thank you for reply.
Based on the given example
Calculate pricing for characteristic A = P1 + 10 * N + 5* R.
Case 1.
P1= 200 is maintained in vk11 and your solution can be adopted.will try and let you know.
Case 2.
Like case 1, i have to maintain p2=10 and p3=5 in vk11 so that
pricing for characteristic A = P1 + P2* N + P3* R. Please advise if there is any structured manner in which variant prices can be maintained
Case 3.
User Enters the price in the configuration and that price appears in pricing procedure.
Regards
Rasheed
Hi
Case 1.
P1= 200 is maintained in vk11 and your solution can be adopted.will try and let you know.
Ok I agree.
Case 2.
Like case 1, i have to maintain p2=10 and p3=5 in vk11 so that
pricing for characteristic A = P1 + P2* N + P3* R. Please advise if there is any structured manner in
which variant prices can be maintained
Lets say condition type is PR00 and P1, P2, P3 are variants for that.
So the formula should be A = PR00 + 2* N + 3* R.
Case 3.
User Enters the price in the configuration and that price appears in pricing procedure.
You mean to say price is variable, then you should go for routine, assign that char value to condition type.
Hi Rasheed,
You have to add these characters to the pricing structure KOMG and other user exit like MV45AFZZ . Then create the condition table as per your requirement . Assign it to the access sequence. Assign access sequence to condition type. Create variant conditions(Discount and surcharge) to accommodate your need and assign this to your pricing procedure.
You have to define base price condition to calculate price as 200.
Feel free to revert back to forum in case of any doubts you have.
Regards,
Atul
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
99 | |
11 | |
11 | |
6 | |
6 | |
4 | |
4 | |
3 | |
3 | |
3 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.