Rounding Problem in Rate Calculations

[ravintag]

Hi All,

In response to client requirement I am suppose to configure Accessorial Cost - Rate Cost screen in such a way that
if the Accessorial cost is 4259.29 the rounded cost should be 4259.00 and
if the Accessorial cost is 4259.86 the rounded cost should be 4260.

I have tried using Rounding Interval but could not figure out if it was working correctly. Can you please advise the correct setting.

In the settings tried some setting were rounding value above 0.5 and some settings working correcting for values less than 0.5, but none of the settings satisfied my condition as explained above.

Thanks in advance for the help.

regards

Ravee

[cool_brat]

Re: Rounding Problem in Rate Calculations

Hi Ravi,

Have you tried using the nearest Interval option in the rate cost screen. Check with :

Rounding type = Nearest Interval
Rounding Interval = 1.0
Rounding fields Level = All fields
Rounding Application = Always.

Regards
Vipin

[ravintag]

Re: Rounding Problem in Rate Calculations

Hi,

Yes I tried with that setting but it does not suffice, please find below the detailed observation i have done a short while ago:

when the Accessorial cost calculation was for discount (a negative calculation), the calculation is done as below in the log:

Operand.round(): mod (value % interval) = -0.865 RMICallHandler-17
Operand.round(): NEAREST_INTERVAL RMICallHandler-17
Operand.round(): value = -5,244 RMICallHandler-17
In case where the accessorial cost is for charging (+ve calculation), the calculation is done as below in the log:

Operand.round(): mod (value % interval) = 0.865 RMICallHandler-39
Operand.round(): NEAREST_INTERVAL RMICallHandler-39
Operand.round(): value = 5,245 RMICallHandler-39

I had a discussion with customer and understand that he needs the result to be 5245 in case of negative costs.

Can anyone of you advice me how the same can be achieved.

Thanks and regards,

Ravee