Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
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 185

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 185 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

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Top 10 leaders for November!

Congratulations to our November super stars!

Tips for Writing Effective Suggested Answers

Best practices for providing successful forum answers ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,269 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,198 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

End-of-life Announcement for Microsoft Dynamics GP

Product updates

Dynamics 365 release plans