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

Hands On With Microsoft Dynamics GP 2018 R2 New Features: Option To Not Display Inactive Checkbooks in Lookup

Microsoft Dynamics GPThis post is part of the Hands On With Microsoft Dynamics GP 2018 R2 New Features series in which I am going hands on with the new features introduced in Microsoft Dynamics GP 2018 R2 (which was released on the 2nd October). I reblogged the new features as Microsoft announced them along with some commentary of how I thought they would be received by both my clients and I. In this series, I will be hands on with them giving feedback of how well they work in reality.

The sixteenth new feature is Option To Not Display Inactive Checkbooks in Lookup. This feature allows users to hide inactive checkbooks when performing a lookup.

When doing a lookup on Checkbook ID, click the blue bar above the list and select Exclude Inactive Checkbooks:

Checkbooks

Continue reading “Hands On With Microsoft Dynamics GP 2018 R2 New Features: Option To Not Display Inactive Checkbooks in Lookup”

Hands On With Microsoft Dynamics GP 2018 R2 New Features: Duplicate Check Numbers Option Extended

Microsoft Dynamics GPThis post is part of the Hands On With Microsoft Dynamics GP 2018 R2 New Features series in which I am going hands on with the new features introduced in Microsoft Dynamics GP 2018 R2 (which was released on the 2nd October). I reblogged the new features as Microsoft announced them along with some commentary of how I thought they would be received by both my clients and I. In this series, I will be hands on with them giving feedback of how well they work in reality.

The fourteenth new feature is Duplicate Check Numbers Option Extended.

This feature sees the Checkbook Maintenance (Financial area page » Cards » Chechbook) option to allow or not allow Duplicate Check Numbers extended to other windows. This means that if this option is not marked, duplicate checks are not allowed in these three windows. Previously, this option only applied to Payables checkbooks but now it includes:

  • Bank Transaction Entry
  • Payroll Manual Checks
  • Miscellaneous Checks
Checkbook  Maintenance

Continue reading “Hands On With Microsoft Dynamics GP 2018 R2 New Features: Duplicate Check Numbers Option Extended”

MDGP 2018 R2 Feature of the Day: Option To Not Display Inactive Checkbooks in Lookup

Microsoft Dynamics GPThe Inside Microsoft Dynamics GP blog has started a series Feature of the Day posts for Microsoft Dynamics GP 2018 R2 on which I am following and adding commentary. The series index for this series of posts is here.

The nineteenth Feature of the Day is option to not display inactive checkbooks in lookup.

This feature is a new option Exclude Inactive Checkbooks in the checkbook lookup which can be selected; it can also be set your default lookup:

Checkbooks

With the last feature of the day which defaults the Checkbook on the creation of a payment run, there probably won’t be muh use for this feature.

Click to show/hide the MDGP 2018 R2 Feature of the Day Series Index

Hands On With MDGP 2018 RTM New Features: New Workflows

Microsoft Dynamics GPMicrosoft Dynamics GP 2018 RTM has now been released and I have been taking a Hands On look at the installation and configuration of the new version.

I am now going to take a hands on look at the new and enhanced features introduced in Microsoft Dynamics GP. Rather than do this as a continuation of the Hands On series I wrote in December, as originally intended, I am going to split it out into a separate hands On With the features post. The series index is for this new features series, can be found here.

One of my favourite new features in Microsoft Dynamics GP 2018 RTM, are the new workflows which were introduced:

  • General Ledger Account Approval
  • Receivings Transaction Approval
  • Purchasing Invoice Approval

I’ve had a number of clients and prospects ask if it is possible to have approvals of goods receipt notes and invoices in POP, so it’s good that I can now say that there are. These workflows are likely to be fairly complicated, so, in this post, I am going to be giving a test to the General Ledger Account Approval workflow.

The workflow process is created and maintained just like any other via Workflow Maintenance (Administration area page >> Setup >> Company >> Workflow >> Workflow Maintenance):

Workflow Maintenance

Continue reading “Hands On With MDGP 2018 RTM New Features: New Workflows”

Hands On With MDGP 2018 RTM New Features: DocAttach Available on More Windows

Microsoft Dynamics GPMicrosoft Dynamics GP 2018 RTM has now been released and I have been taking a Hands On look at the installation and configuration of the new version.

I am now going to take a hands on look at the new and enhanced features introduced in Microsoft Dynamics GP. Rather than do this as a continuation of the Hands On series I wrote in December, as originally intended, I am going to split it out into a separate hands On With the features post. The series index is for this new features series, can be found here.

The first of the features announced by Microsoft was the introduction of DocAttach on more windows: the DocAttach button on the action pane makes the function more accessible to users. The windows updated for this are:

  • General Ledger Transaction Entry
  • Receivables Transaction Entry
  • Asset General Information
  • Employee Entry
  • I-9 Form (Payroll)
  • Journal Entry Enquiry
  • Payables Transaction Entry Zoom
  • Receivables Transaction Entry Zoom

I quite like the DocAttach function in Microsoft Dynamics GP, although I am careful to be clear with clients and prospects that is is document attachment and not document management.

While it’s good to see DocAttach getting wider exposure across Microsoft Dynamics GP on the action panes, it’s especially nice to see Fixed Asset Management getting some DocAttach improvements as many of my clients have images of their assets to store:

Fixed Asset General

Click to show/hide the Hands On With MDGP 2018 RTM New Features Series Index