on 04-12-2014 6:32 AM
Dear Gurus,
I have the following scenario,
Retail price of a material is $50.25/kg and customer is order 10,000kg of the material, but freight that amount $1000 (fix amount) is included in the retail price.
Client wants initially he put $50.25/kg in the system and when user enter freight charges $1000 at header, system will re determine the amount of price (50.25$) and set it to as per freight amount like $50.15/kg.
Looking for gurus response.
regards,
Imran khan
Hi,
You maintain your Freight Condition Type with calculation type "B".
So your pricing will be like (Quantity = 10000 Kg)
Step Condition Type Text Rate Amount
100 Z900 Price 50.25 per KG 502500
200 Z901 Freight 1000 1000
300 Z902 Net Price 501500
For condition type Z902 will be calculated by reducing the Amount of Z901 from Z900, for this you may use some Routine or even by manipulating the steps you can achieve the same.
Regards,
Amitesh
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Imran,
Assuming your requirement you have given .You can use scales for this.
Maintain your freight as if quantity from 10,000kg then $1000.
Similarly for retail price if quantity is 10,000kg then $50.15/kg.
I am not sure if this is your requirement. If not can you please explain your requirement a bit.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Imran,
As per my understanding your requirement is :-
if the material price is $50.25/Kg, which is including the Freight price,
But while we will put the freight price at header, then it will show the break up (i.e
Material price is $50.15/Kg
Freight is $0.10/kg
If this is the requirement, then
Remember:- all the header conditions are used in discounts only.
So it will show you the breakup , but the freight will show as discount instead of surcharge.
Regards
Pitabash
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Sorry your requirement is not clear to me. You need to elaborate more on this. When you say
but freight that amount $1000 (fix amount) is included in the retail price
I dont understand why your client want to key in at header level?
G. Lakshmipathi
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Perfect, you can go ahead with this scenario.
What is your doubt in this scenario?
Anandkumar KS
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
95 | |
11 | |
11 | |
6 | |
6 | |
4 | |
3 | |
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.