This error occurs in all the modules, we've included two specific here but If you're getting 'a valid exchange rate' in the error, this is the solution.
Sql procedure error codes returned:
Error Number = 537 Stored Procedure= taRMTransaction Error Description = An error occurred in the taMCCurrencyValidate proc
Error Number = 9389 Stored Procedure= taMCCurrencyValidate Error Description = A valid Exchange Rate could not be found for the Document Date specified Node Identifier Parameters: taMCCurrencyValidate DOCDATE = 11/4/2014 Related Error Code Parameters for Node : taMCCurrencyValidate EXGTBLID = Note: This parameter was not passed in, no value for the parameter will be returned.
DOCDATE = 11/4/2014
<taRMTransaction>
<RMDTYPAL>7</RMDTYPAL>
<DOCNUMBR>SUM5007-001</DOCNUMBR>
<DOCDATE>11/4/2014</DOCDATE>
<BACHNUMB>CONSOL1104</BACHNUMB>
<CUSTNMBR>CD204 </CUSTNMBR>
<DOCAMNT>3155.41000</DOCAMNT>
<SLSAMNT>3155.41000</SLSAMNT>
<DOCDESCR>SH14/13841 </DOCDESCR>
<CSTPONBR>SUM5007 </CSTPONBR>
<PYMTRMID>1% 30 NET 31</PYMTRMID>
<CURNCYID>Z-EURO </CURNCYID>
</taRMTransaction>
====================================================================
Action:
Service Create Transaction
Current User Name:
INFINITY\LSwann_Admin
Input parameters:
Exception type:
Microsoft.Dynamics.GP.eConnect.eConnectException
Exception message:
Sql procedure error codes returned:
Error Number = 537 Stored Procedure= taRMTransaction Error Description = An error occurred in the taMCCurrencyValidate proc
Error Number = 9389 Stored Procedure= taMCCurrencyValidate Error Description = A valid Exchange Rate could not be found for the Document Date specified
Node Identifier Parameters: taMCCurrencyValidate
DOCDATE = 10-JAN-19
Related Error Code Parameters for Node : taMCCurrencyValidate
EXGTBLID = Note: This parameter was not passed in, no value for the parameter will be returned.
DOCDATE = 10-JAN-19
<taRMTransaction>
<RMDTYPAL>7</RMDTYPAL>
<DOCNUMBR>CM19/00002A</DOCNUMBR>
<DOCDATE>10-JAN-19</DOCDATE>
<BACHNUMB>IGIS</BACHNUMB>
<CUSTNMBR>CD650A</CUSTNMBR>
<DOCAMNT>62.56</DOCAMNT>
<SLSAMNT>62.56</SLSAMNT>
<CURNCYID>INR</CURNCYID>
<USRDEFND1>IGIPL</USRDEFND1>
<USRDEFND2>IG19/00007A</USRDEFND2>
<USRDEFND3></USRDEFND3>
<USRDEFND4>Dynamics test - create AJ and CM xml for integration</USRDEFND4>
</taRMTransaction>
Exception message:
Error Number = 537 Stored Procedure taRMTransaction Error Description = An error occurred in the taMCCurrencyValidate proc
Error Number = 9389 Stored Procedure taMCCurrencyValidate Error Description = A valid Exchange Rate could not be found for the Document Date specified