Creating An Outlook Item Shortcut

Microsoft OutlookEarlier this month I did a post on command line paramaters to create an Outlook item (such as an email or appointment). In that post I mentioned it was easy to create a shortcut for them, but realised afterwards, that it might be beneficial to cover creating the shortcut.

To create a shortcut, right click on the Windows desktop, and click on New » Shortcut:

Windows right-clickcontext menu

Continue reading “Creating An Outlook Item Shortcut”

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”

Advanced Credentialed Professional Accreditation Retained

Association of Dynamics ProfessionalsThis post is part brag and part public service announcement. The Dynamics Credentialed Professional Exams used to be offered through the Association of Dynamics Professionals, but are now offered through GPUG; once you’ve passed an exam and received the credential, the credential lasts for two years.

If, like me, you passed the exams before 1/1/2017, you have an extended grace period until 31/3/2019 to resit and pass one of your exams. This is the public service element of the post.

Now for the brag; I resat one of the exams earlier this week and passed, so I can, for another two years, claim to be one of these:

Microsoft Dynamics GP Advanced Credentialed Professional

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