Group Reporting - Currency Translation Adjustment - Not Posting

[pspay01]

Hi all,

I've set up my consolidation units to read from the universal journal. Pull the data at local currency (EURO) and the sender currency at group currency which is USD. My consolidation books are also at USD.

When I release the data from the universal journal. I see both local and group pulling at the correct amounts.

Let's say.. A/R account 3000 EURO (local) and 3500 USD for group currency

When I run translation in the data monitor, it shows the same local amount (3000 EURO) and now the group has changed into 3800 USD for group currency causing a change of $300. (Obviously due to the exchange rate)

The CT Key is 5

The column with translation difference shows 0. (even though it went from $3500 to $3800 USD in group currency)

Reference amount shows $3800.

I would have expected to see a CTA posting of $300 so that my group currency in the reports matches this new amount but its no where to be found. If I run the group data analysis tile, its still reading the initial group currency. $3500. If I run Balance Sheet ... still reading at original group currency. The task in itself reads successful but I don't see this posting. I should see $3800 in this example.

What am I missing? Any ideas?

I've also put the FS item in the translation method for entries on each of the sequences.

Thanks!!

[former_member610357]

Hi William,

If after run balances sheet able to see original group currency amount. Go to Display IMG- then consolidation FS item configuration --then specify selected fS item for automatic posting--in item role give your FS item debit and credit in B/S sheet tab and save it. then run your task and check whether it should come 3800 amount USD. it should work i think so.

[former_member623610]

Hello,

In CT method configurations you can define a reference exchange rate indicator e.g. Closing rate 1,1 result 3300 which will apply for all FS items. Now in each translation sequence you can define a specific exchange rate indicator e.g. Average rate 1,2 result 3600 now the translation difference is basically the difference between the results of using two different rates in this case 300.

If you release group currency amount to universal journal, you can either keep these amounts by using CT key 6 or retranslate them using different CT keys. If you choose to retranslate and use the same ERI on method level as well as sequence level, you will get no CTA posted as there is no difference in the used rate for translation.

You can check this in GR help portal.

Best regards
Mazen