EONE BLOG

Integrate to Dynamics GP with Excel Templates


Did you know you can integrate directly into Microsoft Dynamics GP using our pre-configured Excel templates?

The templates make data entry fast and easy without sacrificing power or flexibility.  Each template has a simple interface which can be set up quickly and used as-is or customized to fit your exact integration needs.

Right out of the box the templates get you moving quickly, starting with four tabs visible: a README tab, a setup/connections tab, a main entry tab, and a map run log tab.  Drop-down boxes speed up data entry on the main entry tab.  Un-hiding tabs and using buttons on the ribbon give more control should you need to customize – nearly every setting and customization is saved in the workbook instead of locked away in code.

With many settings exposed, the templates are incredibly flexible and ready to be customized in many ways.  The main interface allows adding in additional fields to the heading or lines. Additional data tables can be added quickly for creating additional lookups. Error messages come directly from eConnect and can be cryptic, but cleaner and clearer error messages can be added to help with troubleshooting.

Take a look at our collection of 8 templates.  There is a workbook that integrates into:


Ready to dive in and use the templates? Download them at the links above whenever you’re ready. Want to start but have a few questions? Reach out to us at +1.888.319.3663.

Leave a Comment




RECENT POSTS


Tech Tuesday: Using GETMAPXML/VAR to pass in parameters to a map and getting the data back
Tech Thursday: Adding Custom Headers to GP Excel Templates
Become an Expert with Extender Self-Paced Training
Missed the All-Hands Partner Call? You're Not Too Late!
Find us at eXtreme365 in Austin

POPULAR POSTS


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

CATEGORIES

ARCHIVES

open all | close all

TAGS

CRM Demo Dynamics Dynamics 365 dynamics crm Dynamics GP Dynamics NAV Econnect Employee Spotlight eone eOne News eOne Spotlight ERP Events Excel Excel Report Builder Extender Extender Enterprise Flexicoder GP GPUG integration integration manager Meet the Team Microsoft Microsoft dynamics crm Microsoft Dynamics GP MSDYNGP Office Relationships partners release SalesForce SalesForce.com scripting SmartConnect SmartList SmartList Builder SmartList Designer SmartView SQL Support Tech Tuesday Templates training Zendesk

Integrate & Automate without Any Code.

SmartList Data has Never Been Faster.

The Easiest Way to Report on GP Data.