Skip to content
+1-888-319-3663

EONE BLOG

Tech Tuesday : What Data Can SmartConnect Integrate in Dynamics GP (eConnect)


A question that comes up many times each month is whether SmartConnect can integrate to specific tables or tables in Dynamics GP, whether it’s Human Resources, Manufacturing, Void Payables, Apply Payables, and many other modules. Typically, we will point them to the eConnect documentation, the Microsoft API for data integrations, but it probably doesn’t provide a clear understanding of what is available. I did a search for eConnect on our website to see if we provide a comprehensive list of what is available within SmartConnect 20.18+, but did not find any such list.

If you would like to go through the eConnect documentation instead or to get what data is expected for each node, follow this link.

Below is a list of the standard Dynamics GP nodes available with eConnect along with the Node Type and the individual nodes within each Node type. For example, Customer Master in Receivables consists of Create Customer, Create Customer Address, Create Internet Address, Create Parent ID and Create Parent-Child ID.

Any node can be duplicated within the node type or to another node type using the SmartConnect Node Maintenance window in the Maintenance->Dynamics GP section. For example, I can combine add the Receivables Apply Node to the Receivables Transaction Node. An example of how to duplicate a node can be found here.

The order of the existing Dynamics GP Nodes within the Node Type must be maintained for eConnect to work successfully. For example, the Analytics Distribution Node must come after the Distribution Node for all Transactions.

 

Out of the Box Nodes

Group

Node Type

Nodes/Notes

Analytical Accounting

Dimension Code Maintenance

AA Transaction Dimension Code Maintenance

   

Bank Reconciliation

Bank Deposits

  • Not able to update existing transactions

     

Bank Deposits Line

Bank Deposits Header

Post Bank Deposits

 

Bank Transaction

  • Not able to update existing transactions

 

Bank Transaction

Analytics Distribution

Bank Transaction Header

 

Bank Transaction Void

Bank Transaction Distribution

Analytics Distribution

Bank Transaction Void

 

Delete Bank Deposits

Delete Bank Deposits

 

Post Bank Deposits

Post Bank Deposits

   

Company

Create Bank

Create Bank

 

Create Country

Create Country

 

Credit Card

Create Credit Card

 

Internet Address

Create Internet Address

 

Shipping Method

Create Shipping Method

   

Field Service

Equipment

Equipment Master

Equipment Reading

 

RMA

RMA Line

RMA Line Serial

RMA Master

 

RTV

RTV Line

RTV Line Serial

RTV Master

 

Service Call

Service Call Codes Equipment

Service Call Line

Service Call Line Serial

Service call Master

Service Call Multi-Tech

   

Fixed Assets

Create Account Group

Create Account Group

 

Create Asset Book ID

  • Can use this one or the Create Asset Book ITC but not both

 

Create Asset Book

 

Create Asset Book ITC

  • Can use this one or the Create Asset Book ID but not both

 

Create Asset Book ITC

 

Create Asset Class ID

Create Asset Class ID

 

Create Asset ID

  • Does not allow updates to existing Assets

 

Create Asset ID

 

Create Asset Insurance

Create Asset Insurance

 

Create Asset Lease

Create Asset Lease

 

Create Asset Purchase

Create Asset Purchase

 

Create Asset User Data

Create Asset User Data

 

Create Book Class

Create Book Class

 

Create Book ID

Create Book ID

 

Create Insurance Class ID

Create Insurance Class ID

 

Create Lease Company

Create Lease Company

 

Create Location ID

Create Location ID

 

Create Physical Location ID

Create Physical Location ID

 

Create Retirement Code

Create Retirement Code

 

Create Structure

Create Structure

   

General Ledger

Account

 

Update Create Account

Create Variable Allocation Account

Create Fixed Allocation Account

 

Checkbook Master

Create Checkbook

 

Create Account Category

Create Account Category

 

Create Account Currency

Create Account Currencies

 

Fixed Allocation Account

Update Create Account

Create Fixed Allocation Account

 

Transaction

  • Not able to update existing transactions
  • Includes Intercompany nodes with SmartConnect since SmartConnect release 20.16 and newer

 

GL Transaction Line Insert

Analytics Distribution

GL Transaction Header Insert

MDA Update

 

Variable Allocation Account

Update Create Account

Create Variable Allocation Account

   

Human Resources

HR Applicant Education

Create Applicant Education

 

HR Applicant Interview

Create Applicant Interview

Applicant Interview Update

 

HR Applicant Reference

Create Applicant References

 

HR Applicant Skill

Create Applicant Skills

 

HR Applicant Test

Create Applicant Tests

 

HR Applicant

Create Applicant

 

HR Applicant Work History

Create Applicant Work History

 

HR Create Skill Set

Create Skill Sets

Create Skill Sets Line

 

HR Create Test

Create Tests

 

HR Delete Applicant Application

Delete Applicant Application

 

HR Delete Applicant Education Line

Delete Applicant Education Line

 

HR Delete Applicant Education

Delete Applicant Education

 

HR Delete Applicant Interview

Delete Applicant Interview

 

HR Delete Applicant Reference Line

Delete Applicant References Line

 

HR Delete Applicant Reference

Delete Applicant References

 

HR Delete Applicant Requisition

Delete Applicant Requisitions Line

 

HR Delete Applicant Test Line

Delete Applicant Tests Line

 

HR Delete Applicant Test

Delete Applicant Tests

 

HR Delete Applicant

Delete Applicant

 

HR Delete Applicant Work History Line

Delete Applicant Work History Line

 

HR Delete Applicant Work History

Delete Applicant Work History

 

HR Delete Requisition

Delete Requisition

 

HR Delete Skill Set Line

Delete Skill Sets Line

 

HR Delete Skill Set

Delete Skill Sets

 

HR Delete Skill

Delete Skills

 

HR Delete Test

Delete Tests

 

HR Requisition

Create Requisitions

 

HR Skill

Create Skills

   

Inventory

Create Item Currency

Update Create Item Currency

 

Create Item Price List

Create item Price List Line

Create Item Price List Header

 

Create IV Item Class

Create IV Item Class

 

Create Planner

Create Planner

 

Create Price Group

Create Price Group

 

Create Price Level

Create Price Level

 

Create Site Bin

Create Site Bin

 

Create U OF M Schedule

Create U of M Schedule Line

Create U of M Schedule Header

 

Inventory Item Site

Item Site

 

Inventory Site

Create Inventory Site

 

Inventory Transaction

  • Not able to update existing transactions

     

Update Create Item

Transaction Serial Insert

Transaction Lot Insert

Transaction Line Insert

Analytics Distribution

Transaction Multi-Bin Insert

Transaction Header Insert

 

Inventory Transfer

  • Not able to update existing transactions

 

Update Create Item

Transfer Serial Insert

Transfer Lot Insert

Transfer Line Insert

Analytics Distribution

Transfer Multi-Bin Insert

Transfer Header Insert

 

Item Master

Update Create Item

Update Create Item Currency

Create Item Price List Line

Create Item Price List Header

Item Site

Create Item Vendors

Create Kit Item

Create Internet Addresses

 

Lot Category

Create Lot Category

 

Multi-bin Bin to Bin Transfer

Multi-Bin Bin to Bin Transfer

 

Vendor Item

Create Item Vendors

   

Lockbox

Create Lockbox Bank Details

Create Lockbox Bank Details

 

Create Lockbox

Create Lockbox

   

Payroll

Computer Transaction

  • Not able to update existing transactions

 

Create Payroll Batch Header

Create Computer Check Line Insert

 

Create Benefit

Create Benefit

Create Benefit Based on Pay Deduction Codes

 

Create Deduction

Create Deduction

Create Deduction Based on Pay Codes

 

Create Department

Create Department

 

Create Employee

  • Using the Class Roll Down option does not roll down Benefits, Deductions or Pay Codes. A post document task would be used to roll down additional information

 

Create Employee

Create Internet Addresses

 

Create Employee Address

Create Employee Address

Create Internet Addresses

 

Create Employee Benefit

Create Employee Benefit

Create Employee Benefit Based on Pay Deduction Codes

 

Create Employee Class

Create Employee Class

 

Create Employee Deduction

Create Employee Deduction

Create Employee Deduction Based on Pay Codes

 

Create Employee Local Tax

Create Employee Local Tax

 

Create Employee Pay Code

Create Employee Pay Codes

 

Create Employee State Tax

Create Employee State Tax

 

Create Employee Tax

Create Employee Tax

 

Create Local Tax

Create Local Tax

Create Local Tax Detail

 

Create Location

Create Location

 

Create Pay Code

Create Pay Code

 

Create Position

Create Position

 

Create Shift Code

Create Shift Code

 

Create Supervisor

Create Supervisor

 

Create Workers Compensation

Create Workers Compensation Code

 

Delete Employee Address

Delete Employee Address

 

Delete Employee Pay Code

Delete Employee Pay Code

 

Delete Employee

Delete Employee

 

Manual Check Transaction

Create Payroll Batch Header Insert

Create Manual Check Line Insert

Create Manual Check Header Insert

   
Project AccountingAccounts SetupAccounts Setup
 

Change Order

Change Order Entry Budget
Change Order Entry Fee Schedule
Change Order Entry Fee Detail
Change Order Entry Fee Header
Change Order Entry Header

 

Contract Billing Cycle

Contract Billing Cycle

 

Contracts

Contracts
Contract Billing Cycle
Accounts Setup
Projects
Project Billing Cycle
Project Access
Project Equip
Project Fee Schedule
Project Fee
Project Budget

 

Employee Expense

Create Vendor
Create Vendor Address
Employee Expense Line
Employee Expense Tax
Employee Expense Header

 

Equipment Log Transaction

Equipment Log Line
Equipment Log Header

 

Miscellaneous Log Expense Transaction

Miscellaneous Log Line
Miscellaneous Log Header

 

Project Access

Project Access

 

Project Billing Cycle

Project Billing Cycle

 

Project Budget Master

Project Budget Master

 

Project Equipment

Project Equipment

 

Project Fees

Project Fee
Project Fee Schedule

 

Projects

Projects
Project Billing Cycle
Accounts Setup
Project Access
Project Equipment
Project Fee
Project Fee Schedule
Project Budget Master

 

Time Sheet Transactions

Time Sheet Line
Time Sheet Header

   

Purchase Order Processing

Document Delete

PO Delete

 

Document Void

PO Void

 

Enter Match Invoice

  • Not able to update existing transactions

     

Update Create Item

Update Create Vendor

Create Vendor Address

Receipt Line Tax Insert

Distribution

Analytics Distribution

Enter Match Lot Insert

Enter Match Serial Insert

Enter Match Invoice Line

Enter Match Invoice to Shipment Multi-Line

Enter Match Invoice Header

MDA Update

 

Map Sites

Map Sites

 

Receivings

  • Not able to update existing transactions

 

Update Create Item

Update Create Vendor

Create Vendor Address

Receipt Lot Insert

Receipt Serial Insert

Receipt Line Insert

Receipt Multi-Bin

Receipt Line Tax Insert

Receipt User Defined

Distribution

Analytics Distribution

Receipt Header Insert

MDA Update

 

POP to SOP Link Remove

Remove SOP Link

 

Purchase Order

  • Can update existing purchase orders

 

Update Create Item

Update Create Vendor

Create Vendor Address

Update Create Customer

Create Customer Address

Invoice Tax Insert

Distribution

Analytics Distribution

Purchase Order Line

Purchase Order Header

   

Purchasing

Create Buyer

Create Buyer

 

Delete Vendor Address

Delete Vendor Address

 

Manual Check

Update Create Vendor

Create Vendor Address

Distribution

Analytics Distribution

Manual Check

MDA Update

 

Scheduled Payments

Scheduled Payments

 

Transaction

  • Not able to update existing transactions
  • Includes Intercompany nodes with SmartConnect since SmartConnect release 20.16 and newer

     

Update Create Vendor

Create Vendor Address

Transaction Tax Insert

Add Distribution

Analytics Distribution

Transaction Insert

MDA Update

 

Vendor Address

Create Vendor Address

Create Internet Addresses

 

Vendor Master

Update Create Vendor

Create Vendor Address

Create Internet Addresses

Update Create Project Accounting Vendor

   

Receivables

Apply

Analytics Distribution

Apply

 

Cash Receipts

Update Create Customer

Create Customer Address

Distribution

Analytics Distribution

Cash Receipt Insert

 

Create Customer Items

Create Customer Items

 

Create Parent ID

Create Parent ID

Parent ID Child

 

Customer Address

Create Customer Address

Create Internet Addresses

 

Customer Class

Create Customer Class

 

Customer Master

Update Create Customer

Create Customer Address

Create Internet Addresses

Create Parent ID

Parent ID Child

 

Delete Customer

Delete Customer

 

Delete Customer Address

Delete Customer Address

 

Delete Salesperson

Delete Salesperson

 

Parent ID Child

Parent ID Child

 

Prospect Master

Create Prospect

 

Salesperson Master

Create Salesperson

Create Internet Addresses

 

Scheduled Payments

Scheduled Payments

 

Territory Master

Create Territory

 

Transaction

  • Not able to update existing transactions

 

Update Create Customer

Create Customer Address

Commissions

Transaction Tax Insert

Distribution

Analytics Distribution

Transaction

MDA Update

 

Unapply Transaction

Analytics Distribution

Unapply Transaction

 

Void Transaction

Void Transaction

   

Sales Order Processing

Delete Document

Analytics Distribution

SOP Delete Document

 

Delete Line

SOP Line Delete

 

Distributions

SOP Distribution

Analytics Distribution

 

Line Component

SOP Line Invoice Insert Component

 

Process Hold

SOP Update Create Process Hold

 

Process Hold Master

Create Process Hold

 

Serial

SOP Serial

 

SOP To POP

  • Creates a new purchase order

     

SOP to POP Link

 

Transaction

  • Can update existing transactions

     

Update Create Item

Update Create Customer

Create Customer Address

SOP Serial

SOP Lot Auto

SOP Line Invoice Insert

SOP Line Invoice Insert Component

SOP Tracking Number

SOP Commissions

SOP Line Invoice Tax Insert

Create SOP Payment Insert

SOP User Defined

SOP Distribution

Analytics Distribution

SOP Multi-Bin

SOP Header Invoice Insert

SOP to POP

SOP Update Create Process

Create SOP Tracking Info

MDA Update

 

Void Document

SOP Void

   

Shared

MDA

  • Only allows for update to an existing MDA transaction record

     

MDA Update

 

Transaction Batch

Create Update Batch Header

   

 

Dynamics GP 3rd Party Products

Nodes or services that are available from ISV’s or Dynamics GP Partners.

We apologize for any that may not be listed. If you find one that we are missing please let us know and we will get it included.

ISV

Product

Method

Notes

    

Binary Stream

MEM

Download from Binary Stream.

Installs modified Post eConnect procedures.

https://www.eonesolutions.com/tech-tuesday-using-binary-stream-econnect-procedures-with-smartconnect/

 

    

Key2Act

Job Cost

Key2Act Integration Manager

Purchase from Key2Act.

Installs nodes into SmartConnect for quick mapping.

 

https://www.key2act.com/

Service Management

Equipment Management

    

MC2 Visions

Advanced Intercompany

Wizard installs additional nodes

http://mc2visions.com/knowledge-base/using-smartconnect-with-ait/

    

Precipio Services

PM Apply

Additional Purchase

https://precipioservices.com/products

Additional logic added to a SmartConnect Post document script to call the Precipio Library for Payables Apply.

 

https://www.eonesolutions.com/applying-payables-documents-in-smartconnect-integrations/

    

 

eOne Nodes

The Nodes below have been written by eOne and will be provided by the professional services team with the purchase of eOne’s Node Builder and the purchase of professional services. Please send an email to services@eonesolutions.com if you are interested in implementing one of these nodes. The effort required to implement each node will vary.

Window/Area

Notes

GL Budget

 

In-Transit Inventory

 

Inventory Assembly

 

Inventory Bill of Materials

 

Project Accounting Billing Type Notes

 

Project Accounting Cost Category Budget

 

Project Accounting Inventory Transfer

 

Purchase Order Returns

 

Revenue/Expense Deferral

Includes all supported RED modules

Vendor EFT

 
 Document Attachment Would apply to all of the GP Document Attachment from any supported window.

 

4 Comments

  1. Cindi Todd on May 3, 2019 at 7:55 am

    Thanks for this list. Any plans to add the purchasing apply (like sales apply) anytime soon?

  2. Patrick Roth on May 6, 2019 at 4:53 pm

    No, no plans to make a custom PM Apply node for GP.
    The current solution/workaround for PM Apply is to use the PM Apply assembly from Precipio as noted in the 3rd Party Products section and then write a bit of code per the blog article.

  3. Lisa Sorensen on November 21, 2019 at 2:53 pm

    Starting in GP 2013, there is an INACTIVE field on the Item Maintenance window and a Boolean field in the IV00101 table. I want to be able to use the Item node to update existing Items to Inactive, as necessary.

    I don’t see the INACTIVE field available in the existing SC Item Node nor in the eConnect documentation.

    Is it feasible to add the INACTIVE field to the existing Item node using the Node Maintenance window?

    Are there any issues with this process to be able to update items to inactive?

  4. Patrick Roth on November 21, 2019 at 4:35 pm

    Lisa,

    Well you COULD use Node Maintenance to add the INACTIVE field so you can map it on the SC UI but it isn’t going to work.

    The reason is that the fields on the node that SC has match the field parameters to the underlying MSFT eConnect proc.

    And if they don’t exist in the proc, adding them to the sc node map isn’t going to make it work.

    From a SC perspective, easiest/best solution is to use an ‘after document’ script to update it via script task. Or else possibly use “direct to table” if you are just marking that one field (and hope there isn’t any business logic around this in GP either way)

Leave a Comment





RECENT POSTS


Employee Spotlight: Cameron Hagstrom, Partner Development Manager
eOne welcomes SpotDev, an Everybody Smile More brand, as a new eOne iPaaS Partner.
Tech Tuesday: New Feature Spotlight - Integration Groups and Sorting in SmartConnect.com
Popdock Data Lake Upload Tool - Free Training on April 5th
eOne Welcomes Intersys Group Sp. z o.o. as a New eOne iPaas Partner - Our First Partner in Poland!

POPULAR POSTS


2016 SmartConnect Integration Bootcamps
Tech Tues: Automatically refreshing Pivot Tables in Excel Refreshable Reports
Happy Thanksgiving from the eOne team!
2017 SmartConnect Integration Bootcamps
New Releases of Extender and SmartList Builder

CATEGORIES

TAGS

Business Central CRM D365 Business Central Dynamics 365 dynamics crm Dynamics GP Dynamics NAV Econnect Employee Spotlight eone eOne News error Error Message Events Excel Excel Report Builder Extender Flexicoder GP integration Map Meet the Team Microsoft dynamics crm Microsoft Dynamics GP Navigation List Builder Office Relationships Partner All Hands Call Popdock promotions release SalesForce SalesForce.com SmartConnect SmartConnect.com SmartConnect Bootcamp SmartConnect Maps SmartConnect Office Hours SmartList SmartList Builder SmartPost SmartView SQL Tech Tuesday Templates training

Integrate & Automate without Any Code.

SmartList Data has Never Been Faster.

The Easiest Way to Report on GP Data.