Skip to content
+1-888-319-3663

COMMUNITY FORUM

SmartConnect mappings error

Danmoore asked 8 years ago
When we run a SmartConnect mapping that is used to import journal entires from a subsidiary system like payroll or billing, we are getting an error.  However, SmartConnect mappings that are used to import other items like account numbers work correct.
 
The SmartConnect mappings are giving us the following error:
SQL procedure error codes returned:
Error Number = 11985 Stored Procedure= Error Description = Error Codes were not found in table DYNAMICS..taErrorCode.  Please insure that the table taErrorCode is up to update.  11985
<taGLTransactionHeaderInsert>
  <REFRENCE>AOD-11181349</REFRENCE>
  <USRDEFND2>1</USRDEFND2>
  <JRNENTRY>137915</JRNENTRY>
  <TRXTYPE>0</TRXTYPE>
  <USRDEFND1>109</USRDEFND1>
  <BACHNUMB>AOD109</BACHNUMB>
  <TRXDATE>2012-12-13</TRXDATE>
</taGLTransactionHeaderInsert>
Our current SmartConnect Code: 20.10.11.39

Please help!

Thanks you 🙂
Answers
Best Answer
Lorren answered 8 years ago
What version of Dynamics GP are you running this against?

Do you have any custom logic that is part of the taGLTransactionInsert, like a modified pre or post procedure?  The procedure would be taGLTransactionInsert_Post or taGLTransactionInsert_Pre.  I just searched my instance and do not have an error number 11985 either.



If you would like to submit an answer or comment, please sign in to the eOne portal.