AX 2012 Accounts Payable Currency Revaluation picking up some invoices but not others

(0) Share

Report

Posted on by howalker

1,212

I cannot figure out why the AX 2012 R2 Accounts Payable foreign currency revaluation process picks up some invoices but not others for the same vendor. This happens both when simulating and posting. I have compared the two invoices and don't understand the difference. The first invoice was created and posted December 2014. The second I created today (this is the one the revaluation process won't pick up). Here are some facts on today's invoice:

Transaction currency = CAD
Accounting currency = USD
Invoice document date = 1/1/2015
Invoice posting date = 1/20/2015
This invoice has not been paid
The vendor is not on hold
This invoice is posted and can be seen in the trial balance for the AP liability account and the offsetting expense account

Configuration facts:
AP main account currency conversion checkbox = checked
CAD currency online numeric conversion tool checkbox = checked
Exchange rates from USD to CAD are set up with start dates of 1/1/2015 and 1/20/2015
Currency revaluation accounts are set up with main account numbers for both gain and loss

Selection criteria for Accounts Payable currency revaluation:
Method = standard
Considered date = 2/28/2015
Date of rate = 1/31/2015
No other selections are made
(I get the same result if I run it for both considered date and date of rate 1/31/2015)
(I get the same result if I run it for considered date of 3/15/2015 and date of rate 2/28/2015)

I have created other invoices in ZAR and EUR currencies that this revaluation process is not picking up either. I have double checked all the config and the statements above about config facts applies to these ZAR and EUR invoices, too, except I'm using two different vendors.

Any ideas? What am I missing?

Thanks,

Howard

*This post is locked for comments

I have the same question (0)

All responses (10)

Answers (0)

André Arnaud de Cal... 301,134 Super User 2025 Season 2 on at

Like (0)

Report

Hi Howard,

You mentioned a lot of currency codes and dates, but you did not mention the exchange rates entered on several dates and transactions. If you have posted the invoice on 1/20/2015 it used that exchange rate. If you don't have another rate between 1/21/2015 and 1/31/2015 there will be no revaluation for that invoice on the considered date 1/31/2015.

So check the exchange rate used on the transactions and the exchange rate known on the date of rate.

Was this reply helpful? Yes No
Suggested answer

Chandu Naresh 982 on at

Like (0)

Report

The AP foreign currency revaluation is based on the posting profile.

There could be a chance that the transactions, which are revalued belong to another posting profile.

You need to run revaluation separately for each posting profiles on the given date.

Hope this helps.

Was this reply helpful? Yes No
André Arnaud de Cal... 301,134 Super User 2025 Season 2 on at

Like (1)

Report

Hi Chandu,

The posting profile selection on the dialog (Parameters group) is not filtering the transactions. It will tell the system which posting profile to use when posting the exchange adjustment. You can run it for all posting profiles at once. Another posting profile selection enables the opportunity to use e.g. another Summary balance account for the unrealized exchange loss/profit.

This reply is based on my experience. Can you indicate if your answer is related to e.g. a localization or did I miss something?

Was this reply helpful? Yes No
Chandu Naresh 982 on at

Like (1)

Report

You are right Andre! We customized it this way and forgot the original functionality.

Thanks for refreshing my knowledge

Was this reply helpful? Yes No
howalker 1,212 on at

Like (1)

Report

Thank you everyone! I guess I was tired last night (it was a very long consulting day, including travel) and neglected to add in a set of exchange rates for 1/31/2015. You also helped me realize that I did not back date my test invoices. I let them post on 1/20/2015. Lesson learned!

Was this reply helpful? Yes No
Chandu Naresh 982 on at

Like (0)

Report

Thats good news, Howard.

Was this reply helpful? Yes No
André Arnaud de Cal... 301,134 Super User 2025 Season 2 on at

Like (1)

Report

Hi Howard,

Let us know when you need another wake-up call ;)

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

You can run it for all posting profiles at once. Another posting profile selection enables the opportunity to use e.g. another Summary balance account for the unrealized exchange loss/profit.

Hi Andre, don't we setup the realized/unrealized-gain/loss accounts in the ledger form?.

how can changing the posting profile in AP/AR revaluation change the accounts to post gain/loss?

Can you please explain further on this?

Was this reply helpful? Yes No
André Arnaud de Cal... 301,134 Super User 2025 Season 2 on at

Like (0)

Report

Hi Ron666,

During the revaluation there will be accounting transactions created on unrealized gain/loss accounts, but also on the vendor balance account as offset. Using another posting profile would enable you to use another balance account.

Usually for a gain you have the next posting:

Vendors 20

Unrealized gain -20

To have the original vendor balance untouched for unrealized exchange results, you can have e.g.

Vendor unrealized revaluation 20

Unrealized gain -20

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

Thanks for the quick reply Andre,

One more doubt though......... What if we have multiple vendor groups in each vendor posting profile and have different "summary account" for each group?

Was this reply helpful? Yes No