Dynamics Community Forum Thread Details

Foreign Company: Account with Zero balance translates with balance in USD

I have a Dynamics GP (2018) site with 4 separate foreign companies and a US company. All companies are operated entirely in their base or home currency. We then have consolidated reports in Management Reporter that consolidate into US dollars.

All seems to work OK, except we have two GL accounts, where in their foreign company they have a zero balance. Yet when translated into US dollars a balance then displays. I've tried to remedy as follows:

1) Checked the Foreign GL Account and related currency setup, but saw no difference between a working account and the one with the problem.

2) Confirmed the foreign GL account had zero balance.

2) Rebuilt the Management Reporter datamart.

3) Ran reconcile procedures in the affected foreign company for the prior and current year. (Also checked for datamart updates afterwards)

Each with no affect. There seems to be a similar case posted, but it had no resolution.

https://community.dynamics.com/gp/f/microsoft-dynamics-gp-forum/205976/mr-translating-a-usd-amount-for-a-eur-account-with-zero-ytd-balance/1052514#1052514

In our case we are experiencing the issue with a South African company and an Australian company, There is one affected account in each. All other accounts seem to translate OK.

I am open to any suggestions or advice as to how to troubleshoot and fix. Look forward to a response.

Categories:

Microsoft Dynamics GP

Usually if there is a Translation issue it is due to setup in GP. The following link is recommended as it goes over setup windows to make sure things are setup correctly. Also, it has links to show how Current, Average, and Historical are calculated in Management Reporter.

https://support.microsoft.com/en-us/help/2986068/currency-translation-for-microsoft-management-reporter-2012-with-micro

However, with that being said Historical and Average can have this scenario that you mentioned above, but the Current rate will not.

For example you have $100 debit entry that is posted in Jan, and a $100 credit entry in February, so you functional will be $0. However, you rate was 1.1 in January, and then went to 1.2 in February.

Functional =

$100 debit - $100 credit = $0 functional

Translated amount =

$100 functional x 1.1 rate in January = $110 Translated, Then in February is $100 functional x 1.2 rate in February = $120 translated

Translated = $110 - $120, so you have a translated balance of a $10 Credit

The rules of translation are not ignored when a functional balance is $0 as there technically is still a translated balance when using Average or Historical.

Quick Links

Leaderboard > Finance | Project Operations, Human Resources, AX, GP, SL