Skip to content
+1-888-319-3663

COMMUNITY FORUM

Microsoft Dynamics GP Node Maintenance not saving changes

paul asked 8 years ago
I am trying to add a mapping to the USRDEFND1 field (e.g. one the eConnect user-defined fields that get sent to the post procs) within the Create employee node. I have attempted to add the field, applying the directions in this KB article: http://support.eonesolutions.com/Support/Knowledge-Base/Knowledge-Base-Article.aspx?articleid=208

 However, although I can click Save in the Create / Update Node window and then see my changes when re-opening that window by double-clicking on the node, after I click Save in the Microsoft Dynamics GP Node Maintenance window and re-open the node, my change is gone. It is also not appearing in the mapping window for an integration.

I am not getting any error messages or any other indication that I am doing something wrong. Anyone have any ideas?

I am using SmartConnect version 20.13.1.89 with SmartConnect Dynamics GP Connector version 20.13.1.89 for GP 12.
Answers
Best Answer
Chris Dew answered 8 years ago
It has been logged as an issue with the release and we have already tested the fix for the new release coming out later this month. For now we can insert the values into SQL directly.
 
In the script below you can change the descriptions to whatever you want for the user defined fields. The example script here is specifically for Binary Stream MEM.
 
–taCreateEmployee
INSERT INTO SmartConnect..[Field] VALUES('USRDEFND1','taCreateEmployee',(select MAX(ParameterNumber)+1 from SmartConnect..Field where Node='taCreateEmployee'),'Pay Facility ID','String',0,'taCreateEmployee')
INSERT INTO SmartConnect..[Field] VALUES('USRDEFND2','taCreateEmployee',(select MAX(ParameterNumber)+1 from SmartConnect..Field where Node='taCreateEmployee'),'User ID','String',0,'taCreateEmployee')

Thanks,
Chris
 
Janeece Moreland replied 6 years ago

Please tell me where the smartconnect node scripts are for MEM. Thx


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