Discussion:
US Dollar Amounts in Foreign Company
(too old to reply)
Sandeep
2010-08-16 21:28:03 UTC
Permalink
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.
Sandeep
2010-08-18 15:00:03 UTC
Permalink
Any thoughts please? Not sure if its a bug, so any comments are welcome.

Thanks,

Sandeep.
Post by Sandeep
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.
Penny
2010-08-18 19:35:03 UTC
Permalink
Hi Sandeep,
From what you describe FRx is functioning as designed. All FRx can do is
take the Euro (functional) amount from the gl and translate it with the
amount you designed the report to use from the DAX table.
--
Penny Watts


**This posting is provided "AS IS" with no warranties, and confers no
rights.**
Post by Sandeep
Any thoughts please? Not sure if its a bug, so any comments are welcome.
Thanks,
Sandeep.
Post by Sandeep
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.
Sandeep
2010-08-19 14:34:03 UTC
Permalink
Thanks for the response Penny.

Agree to what you say. The reason i reached out was because FRx does provide
means to fetch the amounts in the originating currency - using the Currency
Code and Display options. But this does not work if the Column layout uses
DAX.

Thanks,

Sandeep.
Post by Penny
Hi Sandeep,
From what you describe FRx is functioning as designed. All FRx can do is
take the Euro (functional) amount from the gl and translate it with the
amount you designed the report to use from the DAX table.
--
Penny Watts
**This posting is provided "AS IS" with no warranties, and confers no
rights.**
Post by Sandeep
Any thoughts please? Not sure if its a bug, so any comments are welcome.
Thanks,
Sandeep.
Post by Sandeep
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.
Penny
2010-08-19 15:24:03 UTC
Permalink
You are correct FRx can either do Multi-Currency which tells FRx to pull
Funtional or Natural (originating) or Currency Translation but not both. Once
you select the currency trans on the column layout multi-currency does not
work.
This is by design. I wonder if you could pull the originating currency for
this account in a single one line report, export it to excel and then link to
this worksheet for the value in the main report which uses the currency
translation.
Just a thought....
--
Penny Watts
Microsoft Corp

**This posting is provided "AS IS" with no warranties, and confers no
rights.**
Post by Sandeep
Thanks for the response Penny.
Agree to what you say. The reason i reached out was because FRx does provide
means to fetch the amounts in the originating currency - using the Currency
Code and Display options. But this does not work if the Column layout uses
DAX.
Thanks,
Sandeep.
Post by Penny
Hi Sandeep,
From what you describe FRx is functioning as designed. All FRx can do is
take the Euro (functional) amount from the gl and translate it with the
amount you designed the report to use from the DAX table.
--
Penny Watts
**This posting is provided "AS IS" with no warranties, and confers no
rights.**
Post by Sandeep
Any thoughts please? Not sure if its a bug, so any comments are welcome.
Thanks,
Sandeep.
Post by Sandeep
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.
Sandeep
2010-08-19 17:35:03 UTC
Permalink
Thank you again Penny.

Let me look at that. Hopefully, when FP1 for MR is released, something like
this would be possible.
Post by Penny
You are correct FRx can either do Multi-Currency which tells FRx to pull
Funtional or Natural (originating) or Currency Translation but not both. Once
you select the currency trans on the column layout multi-currency does not
work.
This is by design. I wonder if you could pull the originating currency for
this account in a single one line report, export it to excel and then link to
this worksheet for the value in the main report which uses the currency
translation.
Just a thought....
--
Penny Watts
Microsoft Corp
**This posting is provided "AS IS" with no warranties, and confers no
rights.**
Post by Sandeep
Thanks for the response Penny.
Agree to what you say. The reason i reached out was because FRx does provide
means to fetch the amounts in the originating currency - using the Currency
Code and Display options. But this does not work if the Column layout uses
DAX.
Thanks,
Sandeep.
Post by Penny
Hi Sandeep,
From what you describe FRx is functioning as designed. All FRx can do is
take the Euro (functional) amount from the gl and translate it with the
amount you designed the report to use from the DAX table.
--
Penny Watts
**This posting is provided "AS IS" with no warranties, and confers no
rights.**
Post by Sandeep
Any thoughts please? Not sure if its a bug, so any comments are welcome.
Thanks,
Sandeep.
Post by Sandeep
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.
Loading...