Rounding Problems

Rounding problems may also occur when using currency translation code D, if you, for example, spread a yearly budget over the months.

In the next example, the local amount, 120, is spread over the months with an increase of 10 per month. The average period rate is 7.95 each month. The account used is a main account with no decimals defined.

Table 1. Example, rounding problems when using currency translation code D
Period LC LE  
0301AC 10 80 (Calculated as 10 * 7.95 = 79.5 = 80)
0302AC 20 160 (Calculated as: 80 + ((20 - 10) * 7.95) = 160)
0303AC 30 240  
0304AC 40 320  
etc. etc. etc.  
0312AC 120 960  

If currency translation code M with average year rate 7.95 is used instead, the translated value as per 0312AC is 954, calculated as 120 * 7.95 = 954. The rounding difference when using currency translation code D in the example is 6.