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

The source spreadsheet includes all of the required fields, except for one; the Journal Entry Number. This is not a field which you want users to supply, but because SmartConnect sits on top of eConnect, the integration needs to supply it.

Fortunately, SmartConnect includes functionality which allows you to get this information. The functionality is called a GFP Rolling Column. To create one of these columns, click the Additional Column button on the toolbar and, in the Additional Columns window which opens, click on the COlumns button and select GP Rolling Column:

Additional Columns window showing the GP Rolling columns option

The Dynamics GP Rolling Column window will open; enter JRNENTRY in the Name field and select a Series of Financial:

Dynamics GP Rolling Column showing data entered

Click the ellipsis button next to the Company field and then select the company from the lookup from which the next Journal entry number should be derived (this should match the company selected in the main Destination window:

Database Lookup for companies

Use the dropdown and select a Document Type of Journal Number.

The Journal Entry number we get into this additional column needs to be available to both the distributions and also the journal header, so ensure you mark the Use for Global Variable checkbox.

Dynamics GP Rolling Column showing data entered

Click OK to save the changes and create the rolling columns and then click OK to close the Additional Columns window:

Additional columns window listing the new GP Rolling Column

The new JRNENTRY additional column will be listed at the end of the available columns in the left oane of the SmartConnect Mapping window.

SmartConnect Mapping window showing new column

Mapping the source fields from the left to the right is just a case of drag-and-drop from one side to the other.

The destination side has both an Account Index as well as an Account String column making mapping easy; additionally, mandatory fields are shown in red (not great for someone colour blind like myself, but there is a Show Required Only checkbox at the top right of the window).

SmartConnect Mapping window showing all fields have been mapped

Once all fields have been correctly mapped, click the OK button to return to the Map Setup window; a mark in the Mapped on the Add distributions row will show that the distributions have been mapped:

Map Setup window showing distributions have been mapped

In the next post, I’ll cover the mapping of the journal header.

What should we write about next?

If there is a topic which fits the typical ones of this site, which you would like to see me write about, please use the form, below, to submit your idea.

Your Name

Your Email

Suggested Topic

Suggestion Details

Looking for support or consultancy with Microsoft Dynamics GP?

I no longer work with Microsoft Dynamics GP, but the last company I worked for was ISC Software in the UK; if you’re looking for support or consultancy services with Microsoft Dynamics GP you can contact them here.

Leave a Reply

Your email address will not be published. Required fields are marked *