Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Finance | Project Operations, Human Resources, ... / Validation error with ...
Finance | Project Operations, Human Resources, ...
Answered

Validation error with GP Web Services - Multicurrency

(0) ShareShare
ReportReport
Posted on by Ron Alexander 193

Hello

A customer is attempting to import a Receivables transaction into GP through a web service connection.  Unfortunately I don't have a copy of the data at this moment.  Trying to understand what might cause this type of error.  The transaction data supposedly has Z-US$ as the Currency, and Z-US$ is the Functional Currency in GP.  Multicurrency is not activated in the registration window - the functional currency was filled in to allow Management Reporter to work.

This is the error:

Validation Errors:

- An error occurred in the taMCCurrencyValidate procedure

- An Exchange Table Id default was not foundfor the CurrencyKey and RateType Id. Please check the setup in Great Plains.

Any thoughts on what might cause this type of error?  Does MC need to be activated to clear this issue?

Best Regards - Ron

Categories:
Microsoft Dynamics GP
  • Ron Alexander Profile Picture
    Ron Alexander 193 on at
    RE: Validation error with GP Web Services - Multicurrency

    Thanks for the information.  Just this morning we discovered the Customer Card in GP had an incorrect Currency ID on it, so it appears Web Services was looking at the Customer Card first and seeing the invalid Currency.  We thought it would be first looking at the Functional Currency in GP.

    Your information was verify helpful in understanding why the taMC... Validate procedure was being called in the first place.

    Best Regards - Ron

  • Verified answer
    Isaac Olson Profile Picture
    Isaac Olson on at
    RE: Validation error with GP Web Services - Multicurrency

    Hi Ron,

    In support we always recommend having Multicurrency enabled for anyone on GP 2013 and higher just because we only test functionality and new features with MC enabled and we don't see many cases where it's not enabled any more.  

    (+) Multicurrency Management: Should I enable it? - Microsoft Dynamics GP Community

    In your case it may not be required, but in generally I just wanted to recommend it.  

    With Web Services we only hit the taMCCurrencyValidate procedure if it finds a mismatch between the currency id on the transaction and the currency id on the company for functional currency.  

    1. I would make sure that the Currency ID and the Currency Index in the MC40000 match the Currency ID and Currency Index in the MC40200 for Z-US$.  

    select FUNLCURR,FUNCRIDX,* from COMPANY..MC40000
    select CURNCYID,CURRNIDX,* from DYNAMNICS..MC40200 

    2. I would pass in the Z-US$ currency on your Receivables transactions coming in from Web Services so that it can find a match right away and not have to use additional logic such as looking at the Customer ID in the RM00101 for the currency id and falling back to the MC40000 to pull the functional. 

    I hope this helps!  Web Services would have also required a Functional Currency when it was installed, so if they changed that after the install for Management Reporter, maybe Web Services needs to be reinstalled to pick up the change too.  

    Isaac Olson

    Microsoft Support

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

Quick Links

Daivat Vartak – Community Spotlight

We are honored to recognize Daivat Vartak as our March 2025 Community…

Announcing Our 2025 Season 1 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Kudos to the February Top 10 Community Stars!

Thanks for all your good work in the Community!

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 293,025 Super User 2025 Season 1

#2
Martin Dráb Profile Picture

Martin Dráb 231,837 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156 Moderator

Leaderboard

Featured topics

End-of-life Announcement for Microsoft Dynamics GP

Product updates

Dynamics 365 release plans