Error Creating Fiscal Calendar In Fabrikam Caused by Audit Trail Codes

Microsoft Dynamics GPI’ve been receiving an error in the Fabrikam Sample Company database when trying to create a new Financial Calendar for a while and finally had the time to track it down.

The error appears when you enter a new year and click the Calculate button:

Error when calculating a new year

Microsoft Dynamics GP
[Microsoft][SQL Server Native Client 11.0][SQL Server[Violation of PRIMARY KEY constraint 'PKSY40100'. Cannot insert duplicate key in object 'dbo.ST40100'. The duplicate key value is (0, 2021, 0, 2 ,General Entry ).

Continue reading “Error Creating Fiscal Calendar In Fabrikam Caused by Audit Trail Codes”

Changing System Database Name After Installing the Microsoft Dynamics GP Client

Microsoft Dynamics GPI was installing a new VM to do some testing on and, after installing the Microsoft Dynamics GP, I ran GP Utilities and realised that I had an mistake in the system database name I had defined; the SQL Server I am using already had a deployment of Microsoft Dynamics GP 2018 R2 on it, so could not use my usual name of D18R2 and had to use an alternative.

I had decided to name the system database D18R2U and Fabrikam sample company as U18R2 as this demo VM was to be in US English. However, I named the system database U18R2.

I’ve never changed the system database used by a client before, but I remembered seeing a setting in the Dex.ini file:

Dex.ini file with Pathname line highlighted

Continue reading “Changing System Database Name After Installing the Microsoft Dynamics GP Client”

Enhanced Notes Setup Window Missing

GP Elementz Enhanced NotesA while ago I did a series on Implementing Enhanced Notes from ISC Software Solutions. I more recently installed the add-on again on a different machine and, after doing some initial configuration, wanted to change the settings, couldn’t find the Enhanced Notes Setup window (Administration » Setup» Company » Enhanced Notes » Setup Enhanced Notes):

Administration area page showing menu option missing

Continue reading “Enhanced Notes Setup Window Missing”

hMailServer: Connect Outlook 2019 Professional

Microsoft Dynamics GPWay back in 2015 I did a series on using hMailServer in virtual machine demo environments as a lighter alternative to Exchange. The last post in that series was on connecting Outlook to hMailServer. I am still using hMailServer, but the new version of Outlook, 2019, has changed the process of connecting.

In this post, I’m going to run through connecting Outlook 2019 Professional to hMailServer.

When you start Outlook for the first time, the following dialog will be displayed in which you enter the email address which you will have already configured in hMailServer. Mark the Let me set up my account manually and click Connect:

Outlook - connect new account

Continue reading “hMailServer: Connect Outlook 2019 Professional”

Inventory Reconcile Cannot Be Run While Users Are Posting Invoices

Microsoft Dynamics GPIf you try to run the Inventory Reconcile utility ((Inventory area page » Utilities » Reconcile)) when users are posting invoices, the following error message will be displayed (the same message will be displayed during a Year-End Close):

You cannot complete this process while invoices are being posted

You cannot complete this process while invoices are being posted

If users are not posting invoices, this KB article shows all of the tables which need to be cleared down.

This came up for a client recently. The above KB article requires all users to be out of the system to clear the tables down. In the middle of the working day we wanted t avoid this if we could; so we checked the Batch Activity (SY00800) table and were able to identify the user locking the process and get them to log out.

Leaving the Dex… tables alone we then tried the Reconcile utility again and found it worked fine. In many cases, all three tables will need to be cleared, but sometimes just the SY table will be sufficient.

Implementing Node Builder: Conclusion

eOne SolutionsThis post is part of the series on Implementing Node Builder; Node Builder is a product which allows additional eConnect nodes to be easily created for use with SmartConnect.

I was somewhat surprised that the most recent version available was the 2011 version; I think this shows that Node Builder is not a very popular product, but I am slightly surprised by this as SmartConnect seems to be a popular choice for integrations. I have manually written eConnect stored procedures for new nodes and Node Builder is an easier and quicker way of creating the nodes.

I assume though that people are generally either creating the stored procedures manually or are doing direct updates to the database. If this is the case, then it would seem that the people mainly using SmartConnect are more technical users.

It does not need to be this way and, for a lot of the SmartConnect projects I’ve had a hand in delivering, it hasn’t been this way as we have installed and configured SmartConnect and then trained users on creating and maintaining integrations.

Node Builder compliments this approach by allowing non-technical users to create new nodes as required rather than needing a SQL develop with experience of Microsoft Dynamics GP and eConnect.

I’ll do a series in a few weeks on using Node Builder to create a node for use with SmartConnect.

Implementing Node Builder: Connection Issue

eOne SolutionsThis post is part of the series on Implementing Node Builder; in particular I m creating a node to add EFT Bank information when adding a creditor.

The first time I installed Node Builder I received an error when trying to log in:

Connection failed

Connection Failed

A connection error occurred while trying to connect o the Node Builder database. Check the server settings to ensure Node Builder is pointing to the correct server.

Continue reading “Implementing Node Builder: Connection Issue”

Implementing Node Builder: Registration

eOne SolutionsThis post is part of the series on Implementing Node Builder; Node Builder is a product which allows additional eConnect nodes to be easily created for use with SmartConnect.

With Node Builder installed we can now launch and register it. Node Builder will be available via the Windows Start menu. When launched, you will be prompted to enter the SQL Server and a user account to connect with; this is making a connection to the SQL Server so you will either need to use the sa account or another SQL account (which is not a Dynamics GP user).

Connection Information

Continue reading “Implementing Node Builder: Registration”

Implementing Node Builder: Installation

eOne SolutionsThis post is part of the series on Implementing Node Builder; Node Builder is a product which allows additional eConnect nodes to be easily created for use with SmartConnect.

With Node Builder downloaded, we can now start the implementation. The download is a zip file containing NodeBuilder.exe. Extract and run this file.

On the Welcome step, click Next:

eOne Node Builder Setup: Welcome to the eOne Node Builder Setup Wizard

Continue reading “Implementing Node Builder: Installation”

Implementing Node Builder: Downloading

eOne SolutionsThis post is part of the series on Implementing Node Builder; Node Builder is a product which allows additional eConnect nodes to be easily created for use with SmartConnect.

Node Builder can be downloaded from the eOne Solutions website; there is no requirement to leave your email address when downloading:

Download page