---
title: "Dynamics GP Integration Manager: 5 Need to Know Tips"
description: Dynamics GP Integration Manager is a handy little tool that was designed to allow you to load data into GP manually.
image: https://www.iesgp.com/hubfs/statistic-1820320_960_720.png
---

[![Microsoft Dynamics 365 Managed Services](https://www.iesgp.com/hs-fs/hubfs/IES-Logo.png?width=137&height=83&name=IES-Logo.png)](https://www.iesgp.com)

[GET FREE QUOTE](https://www.iesgp.com/get-free-quote)

## The IES Blog News. Tips. Professional Advice.

A look into the world of Microsoft Dynamics.

# Dynamics GP Integration Manager: 5 Need to Know Tips

Posted by [IES](https://www.iesgp.com/blog/author/ies) on Mar 30, 2017 8:00:00 AM

![](https://www.iesgp.com/hubfs/user.png)

![statistic-1820320_960_720.png](https://www.iesgp.com/hs-fs/hubfs/statistic-1820320_960_720.png?width=320&name=statistic-1820320_960_720.png)Dynamics GP Integration Manager is a handy little tool that was designed to allow you to load data into GP manually. You can add data from an XML, text file or database. It's an excellent add-on that helps reinforce data integrity. We like the Integration Manager because you don’t have to be a data scientist to use it—it’s a graphically enabled interface with some cool drag-and-drop features that allow even the “non-geeks” in an office to use it efficiently.

We've assembled five "need to know" tips that will help you understand how to leverage this piece of the Microsoft toolkit to make your data integrations go a little more smoothly.

## **Tip #1 Download the Microsoft Dynamics GP Integration Manager User’s Guide.**

You can do that by [clicking here](https://www.microsoft.com/en-us/download/details.aspx?id=36069). That way you always have a fallback in case you need a troubleshoot guide.

## **Tip #2 Streamline Mapping**

Dynamics GP Integration Manager has drag-and-drop functionality. You can completely skip the process of selecting a source field, which can be a little laborious if you're not a data manager. Drag-and-drop allows you to leave the source window open and just pull fields where you need them. 

## **Tip #3 Creating Pathnames**

Updating source files can be a constant on your data to-do list. The data file source may change from one server to another. If you’re updating the Source Adaptors to a new drive or folder, you can use Pathname Translations to speed up the process. The [ERP Software Blog](https://www.erpsoftwareblog.com/2017/02/2-tips-dynamics-gp-integration-manager/) has a nice series of screen shots that can walk you through the process. The goal, though, is for you to be able to update one translation that tells all the Source Adapters to use the new path once the information has been added.

## **Tip #4 Automatic Integration**

You can automate data integration as a regular process, but usually, Dynamics GP users make this more of a manual process on their task list. One reason to automate data integrations would be to update payroll records. For example, if you have a personalized time clock, you could take that information from an external system and drop it into GP. This saves you from having to reenter the data manually. Or, if you have proprietary software for purchase orders, you can use Dynamics GP Integration Manager to bring the PO’s directly into Dynamics GP. One important benefit of using the Integration Manager is that it can reduce the amount of time your organization is spending on double data entry. That’s the beauty of a 365-integrated platform—the pieces come together to form a more efficient and cohesive whole.

## **Tip #5 ****Dynamics GP Integration Manager is One Option**

Did you realize you have three options to import data into GP? We’ve been talking about the Integration Manager, which is perfect for the average user that lacks programming skills. But there is also **eConnect, **which offers a whole series of tools that integrates applications with GP data. This is for the more sophisticated user. eConnect has a set of SQL integrators that enforce the programming logic to help with the import process. (If you don’t know what this means, stick with the Integration Manager.) There is also **Web Services **for GP that uses the standard Internet protocols for transferring data.

To learn more about the benefits of Dynamics GP Integration Manager, [contact the IES team](http://iesgp.com/contact) today and set up a free consultation.

![IES](https://www.iesgp.com/hs-fs/hubfs/user.png?width=90&height=90&name=user.png)

### Written by [IES](https://www.iesgp.com/blog/author/ies)

### Recent Posts

### Posts by Topic

- [Dynamics 365 (138)](https://www.iesgp.com/blog/topic/dynamics-365)
- [Microsoft Dynamics GP (66)](https://www.iesgp.com/blog/topic/microsoft-dynamics-gp)
- [Microsoft Dynamics CRM (59)](https://www.iesgp.com/blog/topic/microsoft-dynamics-crm)
- [Microsoft Gold Certified Partner (50)](https://www.iesgp.com/blog/topic/microsoft-gold-certified-partner)
- [Business Solutions (48)](https://www.iesgp.com/blog/topic/business-solutions)
- [Business Central (43)](https://www.iesgp.com/blog/topic/business-central)
- [Microsoft Dynamics (37)](https://www.iesgp.com/blog/topic/microsoft-dynamics)
- [Microsoft CRM Banking (21)](https://www.iesgp.com/blog/topic/microsoft-crm-banking)
- [azure (13)](https://www.iesgp.com/blog/topic/azure)
- [ERP (12)](https://www.iesgp.com/blog/topic/erp)
- [CRM (10)](https://www.iesgp.com/blog/topic/crm)
- [CRM Software (10)](https://www.iesgp.com/blog/topic/crm-software)
- [Microsoft Dynamics ERP (10)](https://www.iesgp.com/blog/topic/microsoft-dynamics-erp)
- [Dynamics NAV (9)](https://www.iesgp.com/blog/topic/dynamics-nav)
- [Project Management (8)](https://www.iesgp.com/blog/topic/project-management)
- [Sharepoint (8)](https://www.iesgp.com/blog/topic/sharepoint)
- [Microsoft Dynamics Solutions (7)](https://www.iesgp.com/blog/topic/microsoft-dynamics-solutions)
- [Dynamics CRM (6)](https://www.iesgp.com/blog/topic/dynamics-crm)
- [Microsoft Dynamics Software (6)](https://www.iesgp.com/blog/topic/microsoft-dynamics-software)
- [Microsoft Dynamics for the Health Care Industry (6)](https://www.iesgp.com/blog/topic/microsoft-dynamics-for-the-health-care-industry)
- [Project Management System (6)](https://www.iesgp.com/blog/topic/project-management-system)
- [Dynamics ERP (5)](https://www.iesgp.com/blog/topic/dynamics-erp)
- [Cloud (4)](https://www.iesgp.com/blog/topic/cloud)
- [Small Business (4)](https://www.iesgp.com/blog/topic/small-business)
- [Cloud Based ERP (3)](https://www.iesgp.com/blog/topic/cloud-based-erp)
- [Microsoft Sharepoint (3)](https://www.iesgp.com/blog/topic/microsoft-sharepoint)
- [Quickbooks (3)](https://www.iesgp.com/blog/topic/quickbooks)
- [B2B vs B2C (2)](https://www.iesgp.com/blog/topic/b2b-vs-b2c)
- [CRM and Sales Team (2)](https://www.iesgp.com/blog/topic/crm-and-sales-team)
- [Project Management Billing System (2)](https://www.iesgp.com/blog/topic/project-management-billing-system)
- [Project Management Software (2)](https://www.iesgp.com/blog/topic/project-management-software)
- [SaaS ERP (2)](https://www.iesgp.com/blog/topic/saas-erp)
- [SharePoint Workflows (2)](https://www.iesgp.com/blog/topic/sharepoint-workflows)
- [AWS (1)](https://www.iesgp.com/blog/topic/aws)
- [Business Systems (1)](https://www.iesgp.com/blog/topic/business-systems)
- [CRM Hosting (1)](https://www.iesgp.com/blog/topic/crm-hosting)
- [CRM Integration (1)](https://www.iesgp.com/blog/topic/crm-integration)
- [Customer Relationship Management (1)](https://www.iesgp.com/blog/topic/customer-relationship-management)
- [HIPAA (1)](https://www.iesgp.com/blog/topic/hipaa)
- [Integrated CRM (1)](https://www.iesgp.com/blog/topic/integrated-crm)
- [LinkedIn (1)](https://www.iesgp.com/blog/topic/linkedin)
- [Microsoft Dynamics Project Management (1)](https://www.iesgp.com/blog/topic/microsoft-dynamics-project-management)
- [Microsoft Fabric (1)](https://www.iesgp.com/blog/topic/microsoft-fabric)
- [Microsoft Sales (1)](https://www.iesgp.com/blog/topic/microsoft-sales)
- [Microsoft Sharepoint Training (1)](https://www.iesgp.com/blog/topic/microsoft-sharepoint-training)
- [Office 365 (1)](https://www.iesgp.com/blog/topic/office-365)
- [Quickbooks vs. Microsoft Dynamics (1)](https://www.iesgp.com/blog/topic/quickbooks-vs-microsoft-dynamics)
- [SharePoint Cloud (1)](https://www.iesgp.com/blog/topic/sharepoint-cloud)
- [Talent Acquisition (1)](https://www.iesgp.com/blog/topic/talent-acquisition)
- [Training (1)](https://www.iesgp.com/blog/topic/training)
- [accounting (1)](https://www.iesgp.com/blog/topic/accounting)
- [business productivity software (1)](https://www.iesgp.com/blog/topic/business-productivity-software)
- [outlook (1)](https://www.iesgp.com/blog/topic/outlook)

[see all](https://www.iesgp.com/blog/dynamics-gp-integration-manager-5-need-to-know-tips#)

### Subscribe to Email Updates

### An Inside look at dynamics 365

![](https://www.iesgp.com/hs-fs/hubfs/laptop.jpg?width=320&name=laptop.jpg "laptop.jpg")

This eBook analyzes Microsoft Dynamics 365 and explains how companies can leverage the new robust platform to accelerate business.

[Download Free Guide](https://www.iesgp.com/ms-dynamics-ebook?hsCtaTracking=5baf3a3d-408b-4eb9-8daf-39b983984193%7Cea0b10d3-bfc7-4eca-b7ae-5c721b37d70f)

## About IES

Internet eBusiness Solutions, Inc. is a leading Microsoft Dynamics software reseller and developer based in the Miami and Tampa areas of Florida and operating nationally.

Our business process consulting firm is dedicated exclusively to Microsoft® Dynamics products and supported services, including Microsoft Dynamics GP, Dynamics CRM, Dynamics NAV, and Sharepoint.

## Current News and Events

## Contact us

** 2200 N Commerce Pkwy  
 Suite 200  
 Weston, FL 33326

**  [(954) 888-9223](tel:+19548889223)

![](https://googleads.g.doubleclick.net/pagead/viewthroughconversion/1072061139/?value=0&guid=ON&script=0)

```json
{
  "@context" : "http://schema.org",
  "@type" : "Organization",
  "address" : {
    "@type" : "PostalAddress",
    "addressCountry" : "USA",
    "addressLocality" : "Weston",
    "addressRegion" : "FL",
    "postalCode" : "33326",
    "streetAddress" : "2200 N Commerce Parkway Suite 200"
  },
  "alternateName" : "Microsoft Dynamics",
  "description" : "Internet eBusiness Solutions, Inc. (IES) is a leading business software reseller, development, implementation, and business process consulting firm dedicated exclusively to Microsoft® Dynamics products.",
  "email" : "ali@iescrm.com",
  "image" : "http://cdn2.hubspot.net/hubfs/679984/ies2.png",
  "logo" : "https://cdn2.hubspot.net/hubfs/679984/IES-Logo-1.png",
  "mainEntityOfPage" : {
    "@id" : "https://www.iesgp.com/blog/dynamics-gp-integration-manager-5-need-to-know-tips",
    "@type" : "WebPage",
    "description" : "Dynamics GP Integration Manager is a handy little tool that was designed to allow you to load data into GP manually. "
  },
  "name" : "Internet eBusiness Solutions, Inc.",
  "sameAs" : [ "https://www.facebook.com/iesgp/", "https://twitter.com/IESCRM", "https://www.youtube.com/channel/UC_xV3Avsa4_LDVkhbTWlUaw" ],
  "telephone" : "(954)-888-9223",
  "url" : "https://www.iesgp.com/"
}
```

```json
{
  "@context" : "http://schema.org",
  "@type" : "BlogPosting",
  "author" : {
    "@type" : "Person",
    "name" : "IES"
  },
  "dateModified" : "May 31, 2018, 10:09:07 AM",
  "datePublished" : "2017-03-30 12:00:00",
  "description" : "Dynamics GP Integration Manager is a handy little tool that was designed to allow you to load data into GP manually. ",
  "headline" : "Dynamics GP Integration Manager: 5 Need to Know Tips",
  "image" : {
    "@type" : "ImageObject",
    "url" : "https://cdn2.hubspot.net/hubfs/679984/statistic-1820320_960_720.png"
  },
  "publisher" : {
    "@type" : "Organization",
    "logo" : {
      "@type" : "ImageObject",
      "url" : "https://cdn2.hubspot.net/hubfs/679984/IES-Logo-1.png"
    },
    "name" : "Internet eBusiness Solutions, Inc."
  }
}
```

```json
{
  "@context" : "https://schema.org",
  "@type" : "BlogPosting",
  "author" : {
    "@id" : "https://www.iesgp.com/blog/author/ies#person",
    "@type" : "Person",
    "image" : "http://cdn2.hubspot.net/hubfs/679984/user.png",
    "name" : "IES",
    "url" : "https://www.iesgp.com/blog/author/ies",
    "worksFor" : {
      "@type" : "Organization",
      "name" : "Internet eBusiness Solutions, Inc."
    }
  },
  "dateModified" : "2018-05-31T10:09:07+0000",
  "datePublished" : "2017-03-30T12:00:00+0000",
  "description" : "Dynamics GP Integration Manager is a handy little tool that was designed to allow you to load data into GP manually. ",
  "headline" : "Dynamics GP Integration Manager: 5 Need to Know Tips",
  "image" : {
    "@type" : "ImageObject",
    "url" : "https://cdn2.hubspot.net/hubfs/679984/statistic-1820320_960_720.png"
  },
  "mainEntityOfPage" : {
    "@id" : "https://www.iesgp.com/blog/dynamics-gp-integration-manager-5-need-to-know-tips",
    "@type" : "WebPage"
  },
  "publisher" : {
    "@type" : "Organization",
    "logo" : {
      "@type" : "ImageObject",
      "url" : "https://cdn2.hubspot.net/hubfs/679984/IES-Logo-1.png"
    },
    "name" : "Internet eBusiness Solutions, Inc."
  }
}
```