foreign currency revaluation in AP - dimension option NONE

(0) Share

Report

Posted on by JuleWergne

Hi all,

I have another question - about foreign currency revaluation in AR/AP Modules.

In AR module it is working correctly in both cases, whether I chose the dimension option NONE or POSTING:

7824.dimension.png

But when I am trying to run a revaluation in AP with the Option NONE, I get first a warning

2548.warning.png

which is correct. I click then OK, and get the following error:

Account number for transaction type Exchange rate gain does not exist.

Actually we have the account number for exchange rate gains/losses in the setup:GL-->Setup-->Ledger.

Additionally i set the gain/loss accounts in the GL-->Setup-->Currency revaluation accounts-->for the currency USD.

But somehow the system doesn't find the Exchange rate gain account, when I try dimension option "none". This is strange, because it is working with the same setup in AR module.

(Option "Posting" in AP module works also, but i don't know whether it is the best way for currency revaluation).

What setup should I check else?

Many thanks in advance!

I have the same question (0)

All responses (3)

Answers (1)

Verified answer

Ludwig Reinhard Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

Hi Jule,

Does it work if you select table or posting?

In addition, have you checked that the account is not suspended and included in your account structure?

Best regards,

Ludwig

Was this reply helpful? Yes No
JuleWergne 12 on at

Like (0)

Report
Copy link

Link copied!

Hi Ludwig,

thank you, that was correct - the account was not configured in account structure.Now it works.

I have another two questions:

1)what is actually the best and more transparent way of revaluation: option None or Posting?

2)i don't quite understand why the amounts in the column "amount in reporting currency" stand in different rows than amounts in column "amount"?

In our case: the accounting and reporting currency in this legal entity is EUR, and the test transaction was in USD.

Thank you!

Was this reply helpful? Yes No
Suggested answer

Ludwig Reinhard Microsoft Employee on at

Like (1)

Report
Copy link

Link copied!

Hi Jule,

For No 1:

I once created a blog post with some examples that explain you the different options (none, posting, table). Please see:

dynamicsax-fico.com/.../

For No 2:

The 'shifted' view that you see in the amount column shall represent debits and credits in a more accountant like way. (debit on the left, credit on the right). Personally, I am not a fan of that and prefer the plus/minus (positive/negative) number illustration but that's the way it is.

Best regards,

Ludwig

Was this reply helpful? Yes No