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

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Finance | Project Operations, Human Resources, ...
Answered

Validation error with GP Web Services - Multicurrency

(0) ShareShare
ReportReport
Posted on by 203

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:
I have the same question (0)
  • Verified answer
    Isaac Olson Profile Picture
    Microsoft Employee on at

    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

  • Ron Alexander Profile Picture
    203 on at

    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

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

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Stars!

Meet the Microsoft Dynamics 365 Contact Center Champions

We are thrilled to have these Champions in our Community!

Congratulations to the March Top 10 Community Leaders

These are the community rock stars!

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

#1
Giorgio Bonacorsi Profile Picture

Giorgio Bonacorsi 733

#2
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 461 Super User 2026 Season 1

#3
Syed Haris Shah Profile Picture

Syed Haris Shah 278 Super User 2026 Season 1

Last 30 days Overall leaderboard

Product updates

Dynamics 365 release plans