Skip to content
+1-888-319-3663

COMMUNITY FORUM

Missing stored procedures for the GP Intercompany Node

Leh asked 9 months ago
I am designing the map for Dynamics GP GL Transaction with Intercompany and was using the eOne Intercompany Node.
When I ran the map, I received the error messages that both E1_GL_INTERCOMPANY_HEADER and E1_GL_INTERCOMPANY_LINES are missing.  I checked the company databases and confirmed that none of the company databases has the two stored procedures.
 
How can I recreate these two stored procedures? 
Answers
Best Answer
Leh answered 8 months ago
Please disregard.
 
I was able to run the system maintenance by creating a copy of the DYNAMICS database to a different database name and repointed the Dynamics GP Connector to the new database.
 
I had to manually run an update script as shown below to make it work. 
UPDATE SmartConnect.dbo.[MsGpConnector] SET [DynamicsDbName] = ‘New Database Name’ 

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