Pricing - Scale with minimum value

[Former Member]

Hi People

I need to create a condition based on gross weight.

For the first 8 kg the price must be fixed without scale, this is minimum value.

Above 8 kg the price must be calculated with scale.

Price Table Example:

8 KG = $ 80,00

1 KG = $ 10,00

Calculation Example:

3 KG = $ 80,00

8 KG = $ 80,00

9 KG = $ 90,00

8.5 KG = $ 85,00

9.5 Kg = $ 95,00

Does anyone have an idea?

Thanks!

Emerson

[Former Member]

Hi

Using SCALES in VK11 will not be the perfect solution for your query as in that case you have to maintain amount for each possible quantity.

The BEST practice to do it is, use of VOFM routine for price calculation (VOFM-->Formulae).

Take help from ABAPer and write a routine such that

if qty = 1

price = 10,00.

else if qty > 8.

price = qty * 10,00.

else

price = 80,00.

end if.

try and revert.

[Former Member]

Hi People

I always have to charge the minimum value (in this case 80,00), and if the net gross is heavier than 8 kg I have to charge 10,00 for each additional kg.

I'm thinking to use two conditions, one for the minimum value and another one for charging the additional kg, but the problem is that I don't know how to configure the condition to consider only the kg above 8.

Example:

Mininum Value = $ 80,00

Additional kg above 8kg = $ 10,00 kg

Calculation:

3 KG = $ 80,00 (minimum value)

8 KG = $ 80,00 (minimum value)

9 KG = $ 80,00 (minimum value) + $ 10,00 (1kg extra) = $ 90,00

8.5 KG = $ 80,00 (minimum value) + $ 5,00 (0.5 kg extra) = $ 85,00

9.5 Kg = $ 80,00 (minimum value) + $ 15,00 (1.5 kg extra) = $ 95,00

Regards,

Emerson

[Former Member]

Now this is the different case.In this case, you have to create a New Condition type for Additional KG which would be entered manually or can create a Condition record & the other condition Type will have Condition record with the Condition record as mentioned.

Best Regards,

Ankur

[Former Member]

Hi

I need the conditon for additonal KG determined automatically.

How can I configure to make this condition consider only the extra KG above the 8 KG? Because the 8 KG was already charged in the condition of minimum value.

Regards,

Ankur

[Former Member]

Create the Condition Record with Quantity from 0KG - Rate XYZ , 9KG & above - Rate ... & try.

Best Regards,

Ankur

[Former Member]

Hi

I created the conditon record like that:

ds 8 KG 10,00 BRL 1 KG

Until 8 KG the condition value is 0 and is correct, but above 8 KG the conditon is charged for the total KG, and I want to charge only the addtional KG above 8.

Example:

gross weight = 9, the condition value calculated was 90 and should be 10.

gross weight = 8, the condition value calculated was 0 and is ok.

Regards,

Emerson

[Former Member]

Hi Emerson

There is no other way to achieve your requirement. Please look at my post and follow.

With configuration you CAN'T get the proper solution.

USE VOFM routine to calculate price based on weight.

[Former Member]

In that case , in VK11 > Scales ,mention 1KG as $10,00 , 2 KG - 8KG as $80,00 & 8.5KG - $85,00 & 9.0KG as $90,00 ...

Best Regards,

Ankur

[Former Member]

Hi,

Goto VK11 / VK12 , Select the line item and Press (Details) F6

Maintain Lower Limit and upper limit for the condition record.

Regards

Senya

[Former Member]

Hi,

Yes it is possible.

COnsider a condition Type with Scales option available with it.

Then go to VK11 and create the condition records. Double click on the first line itema dn you will see the scaling as FROM...

So there you can maintain your requirement like:

FROM ...8 KG ... Rs.X

Regards