Foreign Consolidation Exception

(0) Share

Report

Posted on by JGarcia123

590

We've setup some consolidated statements for one of our clients within Management Reporter. They have 4 foreign companies that consolidate into a US company. The reports work well and the foreign entities translate appropriately into US dollars.

That said, there appear to be a few exception accounts that the client does not want to translate. Is it possible to enter a row modifier, column restriction or print control feature that would suppress the currency translation for that line?

Please advise. Look forward to a response.

Categories:

Microsoft Dynamics GP

All responses (2)

Answers (0)

JGarcia123 590 on at

Like (0)

Report

RE: Foreign Consolidation Exception

Hello Greg,

Appreciate the feedback. I had been looking for a solution in MR, when the answer was in GP. In the foreign company we just had to turn off the US currency for the desired account. That prevented the account from translating, while the others remained subject to translation.

JG
Greg Byer 2,586 on at

Like (0)

Report

RE: Foreign Consolidation Exception

Unfortunately, there is not a modifier or control we can place on an account that will prevent it from translating. There are a couple of ways you could work around this. If you are not using the Historical or Average methods, you could assign that to the account. Let's say you are only translating using the Current method. You could assign Average to this account and then not assign a rate table to Average. If you did use Average at some point, then the account would translate using the Average rates.

Another option would be to add an FD column in MR that does not have a Currency Display. Then in the row definition, restrict this row to that column. All the other rows that should translate could be restricted to the FD column that does have the Currency Display. The problem with is that you'll have one amount in one column and the other in a different column.