Our latest articles are listed below
LATEST STORIES
-
Dynamics GP – SQL parameter sniffing issue causing a routine to hang
Background The new year started off with a very interesting ticket logged on our support desk. The premise of the issue was a routine that would normally finish in seconds, or at most minutes, not appearing to start let alone finish. The user had tried crashing out of GP and even asking everyone else to… Read more
-
Why did my Microsoft SQL Transaction log grow so big and how do I shrink it and reclaim the space?
Background Working primarily on support for Microsoft Dynamics ERP systems I often see tickets logged where the SQL transaction log has grown uncontrollably and is filling (or almost filling) the drive where its located. This post aims to explain the most common reason why this happens and some steps you can take to truncate and… Read more
-
Dynamics GP – Payables Payments not updating the Bank Management module
Recently I ran across an interesting issue affecting the bank management module following an upgrade from Dynamics GP 2010 to Dynamics GP 2018 R2. (I think the bank management module is more widely used here in the UK) A client reported that when posting a EFT payables payment run the payments weren’t hitting the bank… Read more
-
Brief overview and comparison of how summary values are stored and calculated in Dynamics GP, Dynamics NAV and Dynamics 365 Business Central
Introduction There was an interesting conversation on twitter over the weekend with regards summary values and Dynamics 365 Business Central. Much like myself the person asking the question came from a Dynamics GP background and was wondering where in the database Dynamics 365 Business Central stored summary values i.e. GL period balances. Now this is… Read more
-
Dynamics GP – Error Msg “A fatal error occurred while creating an SSL client credential. The internal error state is 10013” with the Web Client
A client reported the following error when trying to access the Dynamics GP web client: The first thing I checked was the event viewer which highlighted the following error in the system log: I then checked through the system log and found this first starting happening 4 days ago which coincided with a server reboot.… Read more
-
Dynamics NAV \ Business Central – Message “This combination of document number and posting date has been used more than once”
I had this message pop up when using the “Navigate” function on a cash receipt in Business Central when i wanted to view the related GL entries. In this instance the message does a really good job of explaining the issue. The same document number and posting date have been used on more than one… Read more
Subscribe
Sign up to be notified with any new blog posts.
thedynamicsexplorer.com 