Create SmartConnect Journal – Standard Map: Connection Could Not be Validated Error

eOne SolutionsThis post is part of a series on creating a Journal – Standard integration using SmartConnect from eOne Solutions; I recently posted a series on Implementing SmartConnect.

When I was creating the Journal – Standard for a client recently, I encountered a problem when trying to add a Key Field in the Map Setup window:

Connection could not be validated error

SmartConnect

Connection could not be validated

ERROR [IM002] [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified

This integration polls for Excel spreadsheets in a certain folder; it took me a moment to realise that the server I was working on was a new one and did not have Microsoft Excel installed.

I asked the client of they could install it for me and, once they had done so, the error disappeared and I was able to add the key fields without further problems.

Create SmartConnect Journal – Standard Map: Schedule Integration

eOne SolutionsThis post is part of a series on creating a Journal – Standard integration using SmartConnect from eOne Solutions; I recently posted a series on Implementing SmartConnect.

Before creating the schedule, select the Options tab and mark the Allow any user to run this map checkbox. This will allow the service account to run this map on the schedule once it is created.

Map Setup action pane with Schedule button

The journal standard integration is one which I would usually schedule to run periodically throughout the day. This is done as the final step in creating the integration from the Map Setup window by clicking Schedule on the toolbar.

The Schedule window will popup and allow you to configure the schedule as required:

Schedule window showing new schedule

Click Save to save the schedule and then click Save again to save the new integration map.

Create SmartConnect Journal – Standard Map: Run Integration

eOne SolutionsThis post is part of a series on creating a Journal – Standard integration using SmartConnect from eOne Solutions; I recently posted a series on Implementing SmartConnect.

Over the last few posts, I’ve stepped through the creation of a map in SmartConnect; with the map now completed, it is time to test.

To do this click the Run button on the Map Setup window.

A SmartConnect Progress window will be displayed and show the progress; as you can see below, my source file with one journal in has been successful:

SmartConnect Progress window showing map was successful

Continue reading “Create SmartConnect Journal – Standard Map: Run Integration”

Create SmartConnect Journal – Standard Map: Define Header Mapping

eOne SolutionsThis post is part of a series on creating a Journal – Standard integration using SmartConnect from eOne Solutions; I recently posted a series on Implementing SmartConnect.

In the last post, I stepped through mapping of the journal lines; in this post, I’ll cover mapping of the journal header.

From the Map Setup window, double-click on the Create journal line in the scrolling window.

As shown in the image, below, map the BatchID, TrxDate, Reference and JRNENTRY fields from the source to the destination. If JRNENTRY doesn’t show here then you have not marked the Use as Global Variable in the GP Rolling Column window).

You also need to change the Column Type on the Transaction type row to List Option and then set the Column Name to Regular; this will make sure the integrated journal is created as a standard journal.

SmartConnect Mapping window showing mapping of fields

Continue reading “Create SmartConnect Journal – Standard Map: Define Header Mapping”

Create SmartConnect Journal – Standard Map: Configure Distributions

eOne SolutionsThis post is part of a series on creating a Journal – Standard integration using SmartConnect from eOne Solutions; I recently posted a series on Implementing SmartConnect.

With the Destination configuration started, the next step is to define the distribution field mapping.

Double click the Add distribution entry in the scrolling window at the bottom of the Map Setup window when the Destination section is selected:

Map Setup window showing Destination section is selected

Continue reading “Create SmartConnect Journal – Standard Map: Configure Distributions”

Create SmartConnect Journal – Standard Map: Configure Destination

eOne SolutionsThis post is part of a series on creating a Journal – Standard integration using SmartConnect from eOne Solutions; I recently posted a series on Implementing SmartConnect.

With the integration map heading created, the next step is to define the destination.

On the Map Setup window which will still be open from the previous post, click the down chevron button next to the Destination heading.

Set Destination Type to Microsoft Dynamics GP.

In the Settings section, there are two fields to define:

  1. Set Group to General Ledger.
  2. Set Node Type to Transactions.
Map Setup window showing Destination settings

Click the Companies button and select the company the integration is to be run against.

In the next post, I’ll take a look at mapping of the distributions.

Create SmartConnect Journal – Standard Map: Create Integration Map

eOne SolutionsThis post is part of a series on creating a Journal – Standard integration using SmartConnect from eOne Solutions; I recently posted a series on Implementing SmartConnect.

With the prerequisites decided, in this post, I’m going to start creating the Journal – Standard integration, the first step of which is to define the Source & Destination information.

To create the integration, launch SmartConnect and on the Map tab click the Create button on the action pane:

SmartConnect Map tab showing action pane

Continue reading “Create SmartConnect Journal – Standard Map: Create Integration Map”

Create SmartConnect Journal – Standard Map: Prerequisites

eOne SolutionsThis post is part of a series on creating a Journal – Standard integration using SmartConnect from eOne Solutions; I recently posted a series on Implementing SmartConnect.

The prerequisites for creating a new integration map are quite straight forward:

    Decide on the type of integration to be created.
  • Decide how the integration should work.
  • Create the source data template.

The integration I am creating as part of this series is one of the easiest which can be created; it is a standard General journal integration. I always create this map after implementing SmartConnect (and before starting to use SmartConnect, Integration Manager) as it is a quick and easy one to create and which will be useful to all clients.

The most useful way of creating this integration for clients, is to create an integration which polls a folder every few minutes on a schedule and which reads data from an Excel spreadsheet. This approach allows one integration to be set up and usuable by all users; as it is a folder being polled, the files dropped into the folder can have any name and, as long as the format matches the template, SmartConnect will attempt to integrate the data.

In the past when using Integration Manager, the source file would be a CSV or TXT file as Integration Manager couldn’t easily handle Excel spreadsheets; SmartConnect has no such limitation, so I am going to use the Excel version of the Integration Manager template:

Excel spreadsheet source with BatchID, TrxDate, Reference, Account, Debit, Credit and DistRef columns

With the above decided and in place, the next post, in this series, will start to cover the creation of the integration map in SmartConnect.

Create SmartConnect Journal – Standard Map: Series Index

eOne SolutionsI recently did a series on Implementing SmartConnect, from eOne Solutions; in this series I am going to create a simple integration map to show how SmartConnect can be used to integrate standard journals into Microsoft Dynamics GP from a predefined folder.

The series index below will update as each post in the series goes live (unless you’re reading a syndicated version of this post in which case check back to the original post).

Create SmartConnect Journal – Standard Map
Create Integration Map
Configure Destination
Configure Distributions
Define Header Mapping
Run Integration
Schedule Integration
Connection Could Not be Validated Error
Credit Amount Was Not Supplied Error
Could Not Run The Scheduled Map
Conclusion

Implementing SmartConnect: Conclusion

eOne SolutionsThis post is part of the series on Implementing SmartConnect, an integration tool from eOne Solutions, which can take data from any source and integrate it into Microsoft Dynamics GP (and other systems such as Microsoft Dynamics CRM or Sales Force amongst others). It has a drag and drop interface to make creating integrations quick and easy for all users rather than just developers (as many integration tools target).

Over the course of the last few weeks, I have installed and configured SmartConnect from eOne Solutions. The installation is fairly straightforward, but you do need to make sure that tasks are completed in order.

With SmartConnect installed, the next step is to create an integration. Therefore, in a few weeks, I’ll be doing a small series on creating a simple integration. For testing that SmartConnect itself is working, I usually create a Standard Journal integration; it’s a nice simple one, but one which is useful to all clients.