Charge Calculation Freight Agreement

[01a02b03c]

Hello,

At the end of the transportation the carrier can send additional kilometer information that was needed that reach the customer in the fastest way. We need to have a predefined value like 1 euro for each additional kilometer, so that the TM users only has to fill manual the additional kilometers. How can I set a predefined value for each kilometer? What is the best way to set this up? In case of a manual charge type I'm not able to set a predefined value of 1 euro. In case I use a Rate Table the correct Scale and Calculation Base is missing.

Any help is welcome!

Regards,

René

[n_knerlein · Accepted solution]

Make sure that the price unit is 1 km, not 0.8. This way the system would charge 0.80 EUR for every 800 meters. The amount has to be 0,8 EUR. The formula is:

(Quantity / Price Unit) * Amount

In the calculation sheet, it should look exactly like this:

When I set it up like that, I am able to fill in the additional kilometers and the system calculates the right amount:

Does it work for you that way?

[01a02b03c]

Get it now 🙂 It works perfectly!!

[01a02b03c]

Do you have quantities in your Freight Order like pallets? (General Data Tab)

I haven't a calculation Resolution Base defined. Only a Calculation Rule is defined.

Regards,

René

[n_knerlein]

Yes, I've tried it with similar properties:

I don't know what the reason for your result could be.

[01a02b03c]

Hi Nadine,

Do you have the same result?

Regards,

René

[n_knerlein]

Hi René,

I've tested it with similar data and it still works with my freight order.

What is the calculation resolution base of the charge line? Have you created a new freight order or tried it with an existing one?

Regards

[01a02b03c]

Hi Nadine,

The quantity field will be filled automatically with total quantity of packages in the Freight Order. It was look like it was solved but now I'm testing it with real Freight Orders and the Quantity field will not be blank as expected. Example there are created 25 pallets so the quantity is set automatically to 25, see screenshot. Do you also have this result?

quantityfield.jpg

quantityfield2.jpg

[01a02b03c]

You are completely true!
Created a new Agreement and it works as expected.

Thanks a lot for your help.

Kind Regards,

René

[n_knerlein]

I'm glad I could help.

Regards,

Nadine

[01a02b03c]

Yes I see, but the field Quantity will be filled automatically with the calculated distance.

Source location> Destination location.

The quantity field must not be filled. Did you set this up?

[n_knerlein]

Yes, I filled in the quantity 100 manually as an example. For me it does work, the quantity appears blank and can be changed.

That is odd, the system should not be able to fill the quantity with the calculated distance as the new calculation base ZDIST has no field assignment that the system could retrieve information from.

[01a02b03c]

Hi Nadine,

I have set-up a new calculation base. But in case I insert a quantity then this will not be multiplied with the Price Unit. Is that also in your set-up?

Input: Quantity 100 (red arrow)
Output: must be 100x 0.8 = 80 Eur (Green Circle)

But missing the output value.faperkm.jpg

[n_knerlein]

Hi René,

set up a new calculation base in Customizing, like this:

Use that for the calculation rule instead of ACTUAL_DIST. Works for me:

Regards,

Nadine

[01a02b03c]

Hello Nadine,

Thanks for your help. I already did that. What is prefer is that the Rate Amount field will be Empty after charge calculation. In case carrier send the additional km, the user only need to insert the additional km's. Price Unit is already predefined.

In the screenshot you see quantity 29.51 km as calculated distance between the location. That field I want to use for the additional km quantity. Then Price Unit field is already defined as I prefer. After insert a quantity the Rate Amount must be filled. Now (Rate Amount) 0.80 eur, but that field must be filled after insert a quantity.

I'm don't think I can use Calculation Base: ACTUAL_DIST for my requirement.

Any suggestion?

Regards,

René

[n_knerlein]

Hello René,

my suggestion is this workaround: In the calculation sheet, set the carge line as manual charge item. Then you define the amount of 1 EUR in conjuction with the calculation rule as shown below:

In the costs tab of the freight document, the system pre-fills the mileage as calculated, but the user is able to overwrite that value with the actual number of additional kilometers. The system then recalculates that carge line. I recommend to set this charge line as statistical costs, so the user activates it only when needed.

Hope that helps.

Regards,

Nadine

[01a02b03c]

Hello Rajesh,

Yes, that's the first step calculation of the planned kilometers.
Second step (after delivery) is calculating the real kilometers, this can be difference because of multiple reason like avoid traffic jam etc etc. The difference between calculated and real kilometers can be charged. An additional kilometer must be predefined as for example 1 euro, so the user of TM only has to fill the additional km and TM will calculate the additional Kilometer charges. Question is: how can I predefine costs of 1 euro per kilometer so that a user only need to fill the quantity of additional kilometers for calculation.

Regards,

René

[former_member600396]

There are many software solution available which can let you know exact milage carrier need to travel instead of getting correct milage from carrier like PCMILER . That would be right approach in my opinion .