Condition Type Calculation

[former_member301027]

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

[former_member188076]

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

[kyusufzai]

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.

[Former Member]

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

[Lakshmipathi]

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

[former_member184966]

Perfect, you can go ahead with this scenario.

What is your doubt in this scenario?

Anandkumar KS

[former_member301027]

Dear Anand,

Please read the thread again.