web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

Season of Giving Solutions is Here!
News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Microsoft Dynamics AX (Archived) / AX 2012 Project Hrs Fo...
Microsoft Dynamics AX (Archived)

AX 2012 Project Hrs Forecast: An exchange rate cannot be found for exchange rate type Average between currencies USD and CAD on exchange date .

(0) ShareShare
ReportReport
Posted on by Marni McKnight 110

1. Our Company currency is CAD

2. Customer A currency is USD

3. Customer A has a Fixed Price Project, Estimate Project is USD

4. When add line to 'Project Hours Forecast'; receive error 'An exchange rate cannot be found for exchange rate type Average between currencies USD and CAD on exchange date .'

5. Exchange rates have been set for USD to CAD, EUR to CAD. EUR is checked for 'reference currency for triagulation'.

Any help greatly appreciated...

 

 

*This post is locked for comments

I have the same question (0)
  • Verified answer
    Community Member Profile Picture
    Community Member on at

    Hi Marni...

    Just came across this post. We are having the same issue - did you ever determine a solution?

  • Suggested answer
    Community Member Profile Picture
    Community Member on at

    Hello Marni & Dave.

    I might have the answer to your "little" problem. I assume it's not a problem with expiration dates on the exchange rates.

    The problem might be that the exchange rates that has been defined isn't the same default exchange type setup in the finance parameters. If this is the case then the system will try to retrieve the values from an empty table which naturally would create an error of the type mentioned.

  • Marni McKnight Profile Picture
    Marni McKnight 110 on at

    Hi Dave..

    I never received any responses to my question, so gave it to our Partner. It has not been fixed to date, however the last information I received was that our partner determined it to be a 'bug' and were looking for a 'hot fix'. They indicated it was an issue in the AOT reference ID for Average Exchange Rate type vs Default Exchange Rate ID.  I believe the case is still with Microsoft.

  • Community Member Profile Picture
    Community Member on at

    Hi Jesper...

    Thank you for your suggestion. I did check the default currency setup and it appears to be per requirements. Note also that I can create, ship and invoice a sales order for the same customer/currency without issue. The only currency error we are receiving is when we are entering project forecasts.

    Marni... thanks for the followup. I also believe it is a bug and will add our voice to the issue at MS.

  • David Bader Profile Picture
    David Bader on at

    Hi Marni,

    I just worked with Dave Blanchard on this issue and we did find out how to resolve this issue. Many thanks to him for going through all the troubleshooting steps I sent his way.

    You should be able to resolve the error with the following steps.

    1. Go to GL > Setup > Currency Exchange Rates

    2. Select Average as the type.

    3. Highlight the USD to CAD combination.

    4. Click Add to add a new exchange rate.

    5. DO NOT enter a start date.

    6. Enter an exchange rate.

    7. Test.

    If you still encounter issue try unmarking the the triangulation checkbox for the EUR currency.

    Have a great day!

    Dave B,

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

News and Announcements

Season of Giving Solutions is Here!

Quick Links

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Neeraj Kumar – Community Spotlight

We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…

Congratulations to the November Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics AX (Archived)

#1
Martin Dráb Profile Picture

Martin Dráb 4 Most Valuable Professional

#2
TAHER Mehdi Profile Picture

TAHER Mehdi 3

#3
Nakul Profile Picture

Nakul 2

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans