cancel
Showing results for 
Search instead for 
Did you mean: 

Calculation Sheet : SUM amount not updated

Former Member
0 Kudos

Dear all,

I have an issue with a Calculation sheet that I created for which the Sum Item amount is always on 0 Athough a prices is defined on items 20 and 30.

The Calculation Sheet structure is the following :

SUM (Item 10)

     FB00 (Item 20)

     FUEL (Item 30)

I trigger the Charge calculation for a Freight Order, the system calculate the prices in Items 20 and 30 but the SUM item is not updated with the total amount?

Have you any idea or suggestion?

Thanks!

Kind regards,

JP

Accepted Solutions (1)

Accepted Solutions (1)

tarunkumar
Active Participant
0 Kudos

Hi JP,

Your question is not very clear, it's better if you could post screen shot of result of charge calculation from 'charges' tab of your freight order.

It is also good if you specify the TM release you are working on because this problem is already fixed long back.

Thanks & Regards,

Tarun Kumar

Former Member
0 Kudos

Hello Tarun,

I'm working with the 9.0 TM release version. You will find enclosed a prinscreen of the Freight order Charge Tab.

The system found the Right Basis Rate of 150 Eur on which a fuel Surcharge of 3% must be calculated but the Total Amount is on 0...

Thanks for your advice!

Kr,

JP

tarunkumar
Active Participant
0 Kudos

Hi JP,

In your case problem is with the calculation rules, either you have not maintained calculation rules in your TCCS or there is no logistical data in your order to produce amount.

You can select the "BASIC RATE" charge line and see the calculation rule tab by clicking "show/hide details" button.

To solve your problem quickly you may consider posting screenshot of "calculation rule" tab, also screenshot of your TCCS.

Thanks & Regards,

Tarun Kumar

Former Member
0 Kudos

Hi Tarun,

In the "Basic Raté Condition I defined a Rate Table that we cannot see on the Printscreen. Normally if a rate table is assign to the charge type no Calculation rule must be maintained. Can you confirm me that point?

If it's true. I means that the issue comes form the rate table in which I defined two Scales : Source Location and Destination Region.

The aim is to have one fixed amount by Source Location and Destination Region.

Then, in the Dates and Values Tab, I defined a Fixed Rate value for the Source Location and Destination Location.

This fixed amount is well found during the calculation Charge of the FO but not in the Total Cost.

Thanks in advance for your comments and feedback.

Kr,

JP

tarunkumar
Active Participant
0 Kudos

Hi JP,

It is very surprising that your rate table is not yet released for use and you are getting a rate in freight order.

To answer your question on calculation rule:

1) System does not allow you to maintain a rate table and a calculation rule simultaneously in your TCCS. You can only maintain an amount and calculation rule in TCCS in conjunction OR a rate table.

2) If you have a rate table in your TCCS then also you can have a calculation rule defined in your rate table directly. This calculation rule is used at run time to derive a final amount.

To check it correctly I need a screen shot of "Calculation rule" tab form Freight order.... steps to reach calculation rule tab:

1) go to freight order.

2) select the "BASIC RATE" charge line and see the calculation rule tab by clicking "show/hide details" button.

In general: If you are using SP00 of TM 9.0 then it is better to upgrade to SP01 because it gives you more stability and better performance.

Thanks & Regards,

Tarun Kumar


Former Member
0 Kudos

Hi Tarun,

Thanks for your input. Indeed, I figured out that in the calculation rules of the Basic Freight no calculation Base is defined because I didn't maintain it in the rate table.

But what could be the calculation Base for A fixed price that I have between a source and a destination Location?

Kr,

JP

Former Member
0 Kudos

Hi Tarun,

I noticed an error in the rate table assigned to the Charge type FB00. An empty calculation rules item was  defined. So I removed it and released the rate table.

Thanks for your help!

Kr,

JP

Answers (0)