Category: GP

Bulk Export Dynamics GP Document Attachments using .NET

Ian Grieve2 minute read0 comment

Precipio ServicesSteve Endow of Precipio Services, the man behind the GP Transaction Search, has created another tool for Microsoft Dynamics GP; this one allows a bulk download of Document Attachments.

The tool allows the user to select a Database, Record Type, and indicate whether Deleted attachments should be exported. The attachments can then be previewed before being exported:

Export Document Attachments window

Full details of this tool is available on Steve’s blog and can be downloaded here.

As well as the Free Tools, Precipio Services also have a range of products available; they also provide a a full array of Dynamics GP integration and customization services.

PrintFriendlyLinkedin

Microsoft Dynamics GP Error: “A Countrecords operation on table ‘[Not Found]’ (45).”

Ian Grieve3 minute read0 comment

Microsoft Dynamics GPI was recently working onsite with a client when I was shown an error message which some users has intermittently been reporting. Every so often they would receive the following error:

A Countrecords operation on table '[Not Found]' (45).

A Countrecords operation on table '[Not Found]' (45).

A little research found me this post by Tim Wappat where he explains this is an error due to a network connection glitch.

Network interruptions are known to cause issues with Microsoft Dynamics GP; this is because it takes a persistent connection with SQL Server. Not all network interruptions are due to a problem; some of them are because clients lock their PC when they go to lunch, but left Dynamics GP running. When the PC has been locked for a few minutes it goes to sleep. Whe the user wakes it up and resumes working, Dynamics GP makes a new connection to the database which is assigned a new SID, but Dynamics GP still thinks it has the original SID.

After advising the client to have users always log out when they are leaving their PC for a while, they have reported that users no longer see the error.

PrintFriendlyLinkedin

Microsoft Dynamics GP In-Transit Transfer Document Locked

Ian Grieve3 minute read1 Comment

Microsoft Dynamics GPWhile I was looking at the problem raising In-Transit Transfers I needed to delete all orders with alpha numeric Document Numbers, but was getting an in use error on one of them:

Document is in use error

Continue reading “Microsoft Dynamics GP In-Transit Transfer Document Locked”

PrintFriendlyLinkedin

Error Raising In-Transit Transfer in Microsoft Dynamics GP

Ian Grieve4 minute read2 Comments

Microsoft Dynamics GPI was doing some work for a client the other day who was implementing some new functionality in Microsoft Dynamics GP. One of the areas they were working on was Inventory Control. They were testing that everything was working correctly and tried to raise an In Transit Transfer (Inventory Control area page » Transactions » in-Transit transfer Entry); when they entered the Item Number and hit tab the following error appeared:

Error entering an item

Microsoft Dynamics GP
A get/change first operation failed on table 'IV_TRX_WORK_LINE' failed accessing SQL data.

Continue reading “Error Raising In-Transit Transfer in Microsoft Dynamics GP”

PrintFriendlyLinkedin

Error Creating Fiscal Calendar In Fabrikam Caused by Audit Trail Codes

Ian Grieve5 minute read0 comment

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”

PrintFriendlyLinkedin

Changing System Database Name After Installing the Microsoft Dynamics GP Client

Ian Grieve3 minute read0 comment

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”

PrintFriendlyLinkedin

Enhanced Notes Setup Window Missing

Ian Grieve3 minute read0 comment

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”

PrintFriendlyLinkedin

hMailServer: Connect Outlook 2019 Professional

Ian Grieve3 minute read0 comment

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”

PrintFriendlyLinkedin

Inventory Reconcile Cannot Be Run While Users Are Posting Invoices

Ian Grieve2 minute read1 Comment

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.

PrintFriendlyLinkedin

Implementing Node Builder: Conclusion

Ian Grieve3 minute read0 comment

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.

PrintFriendlyLinkedin