on 11-02-2012 8:05 AM
Hi,
We have a requirement where based on a combination of price list type in header and material code in line item, the pricing should be as follows:
"Flat Rate of 395 USD upto 3 units and 125 dollar for every additional unit after 3 units."
For eg : if qty is 4, charge should be 395 +125= 520 USD
and if qty is 2, charge should be 395 USD since there is a flat rate upto 3 units.
This pricing package has to be maintained for unique combination of price list and material code.
We have explored using graduated scales but condition records donot allow us to maintain a fixed charge upto certain quanity in particular slab.
Please help if someone knows the solution to this problem.
Regards,
Kunal
Hi Experts,
Many Thanks for your inputs. I have gone with an option of using two condition types: a fixed amount (for charging the flat rate) and scale condition type ( for further price slabs).
Regards,
kunal
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
hi
in condition type pl maintain calculation type B
and in scales (scale basis -B,check value -B scale type B)
in condition record
in scales maintain to 3 maintain 395
for 4 - 520
for 5- 645 like wise you maintain and check
regards
Ajith
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi,
Write routine for particular condition type and maintained in required column, If item will exceeds min quantity calculate the each quantity as mainted in condition regards(125USD) and keep that condition type as manually.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Pavan,
As per initial Understanding, I think there are 3 cases in this
1. if Qty < a Base Unit then an item wise price is applicable
2. if Qty = a base unit (like 3 EA in case explained by Kunal) then a Base Package Price i.e. 395
3. for every unit exceeding the Base Unit, a Price of 125 per Unit needs to be added.
so the routine has to take all these 3 cases in consideration for pricing to remain coherant.
ZPR1 | 150 | for Qty ❤️ | ||||||
ZPR2 | 395 | for Qty=3 | ||||||
ZPR3 | 125 | for Qty>3 | ||||||
basic Price (ZPR00) | (using Routine) select the correct the Condition from the 3 above based on logic below | |||||||
for a BASE CHARGE Qty Take Scale Value from ZPR2 this will act as your base price for a fixed charge Qty. | ||||||||
so if Material Qty = BASE CHARGE Qty from Above use condition ZPR2 | ||||||||
if Material Qty > BASE CHARGE Qty from above use Condition (ZPR3*(Qty-Scale Value)+ZPR2) | ||||||||
if Materail Qty<BASE CHARGE Qty use ZPR1*Qty. |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi T W, this flat rate qty will actually depend on the material and price package I use in my document. I amusing a combination of a fixed amount and scale condition type. But I have now another issue whihc I have posted http://scn.sap.com/thread/3270613. An example is also shown there.
Thanks for you help!
Kunal
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Kunal,
I have replied to your "other" post.
To narrow down your issue, is the part with price (PR00) solved? (for below 3 units and for above 3 units).
And is the only issue now w.r.t. the surcharge?
Please give examples of the surcharge in various situations.
FYI: With surcharge condition type you can have all the functionalities e.g. scales etc. etc.
I am using scale type D but I have another problem there now. Have posted that as well below.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
This message was moderated.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Thanks for the reply.
For the second condition type, for quantity above 3 units, using a surcharge might work but this flat rate quantity level will change for combination of different materials and price list maintained at header level.
So I have opted to use a combination of fixed amount and a scale condition type which gives me the intended result. But now I have another issue with graduated scales which I have posted at http://scn.sap.com/thread/3270613
Regards,
Kunal
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Kunal,
"Flat Rate of 395 USD upto 3 units and 125 dollar for every additional unit after 3 units."
For the minimum 395USD you could use PMIN condition type (Functionality of minimum price at line item level), for a condition table of Price list & material code.
For each additional unit simply maintain the condition record (e.g. for PR00), for a condition table of Price list & material code = 125USD
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Kunal,
Thank you for your example!
I believe there are 2 cases to consider:
1. Quantity Below or equal to 3 Units - Use functionality PMIN = 395.
Explanation for 3 Units
PR00 = 3*125 = 375USD which is less than 395USD, thus the line item value shall become 395USD.
2. Quantity Above 3 Units
Have a surcharge condition type which shall trigger if the quantity > 3
The value of this surcharge would be = 20USD
Explanation for 10 Units
2.1 Your way of calculating -
For 3 units = 395, for the rest 7 units = 125*7= 875
Total = 1270USD
2.2 My way of calculating -
PR00 = 125
Thus total = 125*10 =1250USD
PLUS surcharge = 20USD because the quantity > 3
Thus GRAND total = 1270USD
Side comment -
So total price will become 500(from PR00) + 395( from PMIN)= 895
PMIN functionality does not work the way you have mentioned.
If the line item value is less than 395, then the line item value during saving changes to 395USD
If the line item value is 500, then the line item value shall remain 500USD.
User | Count |
---|---|
95 | |
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.