Skip to Content
0
Former Member
Apr 06, 2011 at 12:03 PM

GR for PO in forex resulted in currency conversion rounding difference

57 Views

Hi,

I have created a PO in foreign currency and when I perform a GR in MIGO, it created the following 4 FI postings:

1) DR Stock - Amount in Forex, Amount in Local Curx

2) CR GR/IR - Amount in Forex, Amount in Local Curx

3) DR Rounding Diff 0.00 in Forex, 0.01 in Local Curx

4) CR Rounding Diff 0.00 in Forex, 0.01 in Local Curx.

Below are the information for the PO item:

Quantity = 350

Unit Price in EUR = 10.39. ==> Amount in forex = 350 * 10.39 = 3,636.50

Conversion rate = 10.61 ==> Amount in local curx = 350 * 10.39 * 10.61 = 38,583.265 rounded to 28,583.27.

Line 1 & line 2 ==> Rounded amount = 28,583.27.

Question: Why is the additional lines (3) & (4) being generated ?

When I did the MIGO posting, the system ask for the additonal account keys PRD and KDM in OBYC which I have supplied with "Rounding Diff" Account.

We have tried with different quantities and this problem so far only happens when the quantiy = 350. (Incidently, the rounding diffence for quantity 350 is exactly 0.005 and the same rounding difference of 0.005 is also applies to quantity 1050, 1750, 2450 etc at every 700 units increment; BUT the 0.01 rounding difference only happeded for quantity 350. Very strange ??)

Additional Info:

No special rounding rules is configured in the system.

Please advice.

Thanks and regards,

Hu Ghee.