SmartConnect Archives - FMT
Search Archive
Dynamics GP Bank Transfer Node for SmartConnect using Multi-Entity Management
Why should you care about a Bank Transfer Node for SmartConnect? If you ever run into the need to create a map in SmartConnect for Bank Transfers you will notice there isn’t a node available for that. You can create your stored procedure and register the Bank Transfer Node. In this blog, we will go over a quick guide to help get you started on what you would need to register the Bank Transfer Node for SmartConnect. Create your procedure with the validations, inserts, and updates needed on your environment. The one I created was for Dynamics GP 2016 R2 using Multi-Entity Management (MEM). Here is a list of the tables affected by the stored procedure: Insert into the following tables: Depending on the table you’re inserting and the intercompany distributions, you might need to insert one, two or four lines. I would suggest that you create a test transfer […]
Microsoft Dynamics GP Integration Tools Guaranteed to Make Your Life Easier
Integration tools can be used to incorporate data from a variety of sources into Dynamics GP. They can also export data from Dynamics GP into many different file types such as text, Excel and XML. For some integrations, you will simply be moving data straight into Dynamics GP. For others, you will want to convert or manipulate the data prior to integrating it. Simple or complex, integration tools can make the whole process easier! The backbone of these tools is eConnect, a set of SQL stored procedures that can be installed for Dynamics GP. They are used to accept data and integrate it into the appropriate database tables. The eConnect stored procedures use business rules to validate the data before integrating it to GP, thus protecting the integrity of the data and only allowing you to insert valid data. Using eConnect without integration tools can be a complicated process. Which […]