Skip to content
+1-888-319-3663

EONE BLOG

Integrate to Dynamics NAV or Dynamics 365 Business Central with Excel Templates


Did you know you can integrate directly into Microsoft Dynamics NAV or Dynamics 365 Business Central 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 Dynamics NAV pages can be added for creating additional lookups.  Error messages directly from NAV are in XML and can be cryptic, but cleaner and clearer error messages can be added to help with troubleshooting.

Take a look at our collection of 15 templates: 7 Dynamics 365 templates and 8 Dynamics NAV templates.  There is a workbook that integrates into:

And don’t forget to check out the corresponding video that walks you through each template. 

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


eOne Sessions at Directions North America 2023
Connect with eOne Solutions at Directions North America 2023!
Tech Tuesday: Creating a Summarize List by States Between Two Systems
eOne Sessions at Days of Knowledge UK - Live from Birmingham!
Employee Spotlight: Ally Tronson, Business Development Representative

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.