Sandeep
2010-08-16 21:28:03 UTC
Hi,
We have a multiple companies in GP, that we consolidate using FRx. The
parent is a USD company, where as each Sub is setup in the respective foreign
currency. We also use DAX in FRx to convert the foreign currency amounts from
each company into USD when printing the consolidated financials.
One of our Subs maintain a USD bank account. The sub itself has Euro as the
functional currency. All entries for that bank account are made in USD and
converted to Euros. Problem is when consolidating, the system takes the Euro
amounts, than converts it back to USD at the month-end rate. This is causing
the balance reporrted in FRx to be over stated and different from what is
actually in that account.
Is there a way to get around this issue? I tried using the Currency Code and
Currency Display options in the column layout, but it does not seem to work
if DAX is enabled.
Any help is greatly appreciated.
Thanks,
Sandeep.
We have a multiple companies in GP, that we consolidate using FRx. The
parent is a USD company, where as each Sub is setup in the respective foreign
currency. We also use DAX in FRx to convert the foreign currency amounts from
each company into USD when printing the consolidated financials.
One of our Subs maintain a USD bank account. The sub itself has Euro as the
functional currency. All entries for that bank account are made in USD and
converted to Euros. Problem is when consolidating, the system takes the Euro
amounts, than converts it back to USD at the month-end rate. This is causing
the balance reporrted in FRx to be over stated and different from what is
actually in that account.
Is there a way to get around this issue? I tried using the Currency Code and
Currency Display options in the column layout, but it does not seem to work
if DAX is enabled.
Any help is greatly appreciated.
Thanks,
Sandeep.