Scale formula for shipment costs

[jsousa1]

Hello,

I'm facing an issue doing the configuration for shipment costs creation.

I have a scenario where I have a condition scale, for example:

From: 1 PAL -> 2 EUR/PAL

From: 2 PAL -> 1,9 EUR/PAL

FROM: 3 PAL -> 1,8 EUR/PAL

.....

But the system need to check how many PAL we have to the same ship-to, meaning that the system needs to check all the deliveries with the same ship-to and sum all the PAL's.

For that I defined the condition type as "group condition" and created a "group condition routine" to group by KUNWE.

The problem is that the system are calculating the number of PAL for the 1st delivery of this ship-to and assume the number of PAL to all the others deliveries of this ship-to (As scale picking value).

I assume the best approach to calculate the number of PAL of all the deliveries is using a Scale formula, but I'm quiet lost if this is really the best approach and how to do it? Which field should I change to get the correct scale condition?

Any help?

Thank you in advance!

[Lakshmipathi]

I am not sure, for what combination, you maintain condition record for this - may be you can consider vendor code as one of the key combinations to your condition record. By doing so, while creating shipment cost document with reference to shipment, system can consider that vendor and fetch the value.

[jsousa1]

Hello,

Thank you for your coment, but does not working.

I made a configuration for the condition with vendor + tarif zone destination and also ship-to, but the system again calculate the number of PAL for the 1st delivery of this ship-to and apply the value for the others.

Imagine to be more clear:

Shipment number: XXX

With deliveries:

1 - For ship-to: 123 With 3 PAL

2 - For ship-to: 345 With 2 PAL

3 - For ship-to: 123 With 2 PAL

4 - For ship-to: 123 With 1 PAL

5 - For ship-to: 786 With 1 PAL

The system when creating the shipment costs for the deliveries of the ship-to 123 should pick the scale value for 6 PAL that is the sum of the 3 deliveries of this ship-to.