Month: June 2021

Integration Manager installs with a sample database in the install folders as the default database. In virtually every case, the clients I work with have a centralised database shared by all clients. While users can amend the path through the Integration Manager application, you can also add a setting in the Microsoft.Dynamics.GP.IntegrationManager.ini file (by default located in C:\Program Files (x86)\Microsoft Dynamics\Integration Manager 18) to change the location for all users.

Under the [IMBaseProvider] heading add the following line where the highlighted section is the path to the database:

DBPath=\\fileserver\Integrations\IM.mdb

I’m working on a few projects for a client at the moment and became aware that logging into their main company was taking almost a minute. Most of the work had been in subsidiaries at the start of the projects, but we’ve moved into the main company now. The subsidiaries are quite quick to log into, say 10 seconds, but the main company was over a minute.

It didn’t matter if this was logging into Dynamics GP itself or just switching between companies. Everything else was running normally (entering or posting transactions and running reports), but as I investigated I found that the problem was specifically related to the loading of the Dynamics GP home page and it was only affecting out user account (I confirmed with the client that they were not seeing speed problems when loading the home page).

The problem turned out to be very prosaic; there were a number of SmartList reminders setup for sales and inventory which were all running before the home page displayed. The main company is where most of the inventory is processed so these reminders are checking large numbers of items and related transactions; removing these favourites from our user restored the quickness of the home age in the main company.

Being able to use SmartList favourites as reminders is good, but if there are a few of them on large datasets, then they can have an impact on performance. As it was just our user account, I was able to remove the reminders without impact; I think they had been added when showing users how to add reminders. If this speed was affecting a user, I would look to see if the reminders could be removed and, if not, create some SmartList Builder (if they have it, otherwise SmartList Designer) which only select the relevant subset of data (such as by selecting only from the work table and not the history table).

I’ve been using, off and on, the eConnect developers documentation for a number of years. However, it seems that Microsoft have now closed down the old location and moved the documents to the Microsoft Docs website.

The new location is here.

I’m posting this here as it took me a long time to actually find the new location.

I’ve been working with a client a lot recently, so when one of their users was not able to log into Microsoft Dynamics GP today, they got in touch.

The problem only affected one user who got the below error message; all other users were unaffected and could log in normally:

This sort of issue is covered in a Microsoft KB article.

The first three possibilities listed, could be ruled out as they would have affected more than just one user; the final option, records stuck in either the SACTIVITY or Batch Activity (SY00800) tables.

I used the below script to check for corrupt records (the highlighted section is the user id to check for):

SELECT * FROM ACTIVITY WHERE userid = 'userid'
SELECT * FROM SY00800 WHERE userid = 'userid'

Once I had confirmed the records were present, I used the below scripts to delete the stuck rows:

DELETE FROM ACTIVITY WHERE userid = 'userid'
DELETE FROM SY00800 WHERE userid = 'userid'