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 | Bank Deposits Line Bank Deposits Header Post Bank Deposits *Not able to update existing transactions |
| Bank Transaction | Bank Transaction Analytics Distribution Bank Transaction Header *Not able to update existing transactions | |
| 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 | Create Asset Book ID Can use ID or ITC but not both | |
| Create Asset Book ITC | Create Asset Book ITC Can use ID or ITC but not both | |
| Create Asset Class ID | Create Asset Class ID | |
| Create Asset ID | Create Asset ID *Does not allow updates to existing Assets | |
| 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 | *The Account Category string is required on updates https://www.eonesolutions.com/help-article/kba-01153-k4r3f1/. 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 | GL Transaction Line Insert Analytics Distribution GL Transaction Header Insert MDA Update *Not able to update existing transactions *Includes Intercompany nodes with SmartConnect since SmartConnect release 20.16 and newer | |
| 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 Reference Line | |
| Delete Applicant Reference | Delete Applicant Reference | |
| HR Delete Applicant Requisition | Delete Applicant Requisition | |
| HR Delete Applicant Test Line | Delete Applicant Test Line | |
| HR Delete Applicant Test | Delete Applicant Test | |
| 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 Set Line | |
| HR Delete Skill Set | Delete Skill Set | |
| HR Delete Skill | Delete Skill | |
| 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 | Update Create Item Transaction Serial Insert Transaction Lot Insert Transaction Line Insert Analytics Distribution Transaction Multi-Bin Insert Transaction Header Insert *Not able to update existing transactions | |
| Inventory Transfer | Update Create Item Transfer Serial Insert Transfer Lot Insert Transfer Line Insert Analytics Distribution Transfer Multi-Bin Insert Transfer Header Insert *Not able to update existing transactions | |
| 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 | Create Payroll Batch Header Create Computer Check Line Insert *Not able to update existing transactions |
| 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 | Create Employee Create Internet Addresses *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 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 Accounting | Accounts Setup | Accounts 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 | 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 *Not able to update existing transactions | |
| Map Sites | Map Sites | |
| Receivings | 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 *Not able to update existing transactions | |
| POP to SOP Link Remove | Remove SOP Link | |
| Purchase Order | 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 *Can update existing purchase orders | |
| 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 | Update Create Vendor Create Vendor Address Transaction Tax Insert Add Distribution Analytics Distribution Transaction Insert MDA Update *Not able to update existing transactions *Includes Intercompany nodes with SmartConnect since SmartConnect release 20.16 and newer | |
| 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 Address | |
| 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 | Update Create Customer Create Customer Address Commissions Transaction Tax Insert Distribution Analytics Distribution Transaction MDA Update *Not able to update existing transactions | |
| Un-apply Transaction | Analytics Distribution Un-apply 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 | SOP to POP Link *Creates a new purchase order | |
| Transaction | 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 *Can update existing transactions | |
| Void Document | SOP Void | |
| Shared | MDA | MDA Update *Only allows for update to an existing MDA transaction record |
| 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/ |
| WennSoft | Job Cost Service Management Equipment Management | WennSoft Integration Manager | Purchase from WennSoft. Installs nodes into SmartConnect for quick mapping. https://www.wennsoft.com/ |
| 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/help-article/applying-gp-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. |