DynDeveloper.com

DynDeveloper.com

Sign Up Now!Log In
AbrahamA 11/6/2014 12:53:30 PM

A valid Exchange Rate could not be found for the Document Date

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 
 
 


4Penny.net
Version: All
Section: Dynamics GP