Our latest articles are listed below
LATEST STORIES
-
Dynamics GP – Re-create Check Stub greyed out on Payables Payment Zoom window
My colleague alerted me to this one and as I could find no information for this online I thought I’d document it on my blog :). A client logged a ticket saying the “Re-create Check Stub” option was greyed out Read more
-
Dynamics GP – Select Cheques routine looping because of duplicate key error in DEX_LOCK
A quick one but hopefully it will help someone else in the future. We had an issue raised last week with a client running the “Select Cheques” routine in payables and although it appeared to be running normally it was Read more
-
Dynamics GP – How I figured out which user deleted a row from a table using the SQL fn_dump_dblog function and DBCC PAGE command
Introduction This post is similar to a previous post I did when investigating deletions on a SOP table however it takes things one step further to confirm 100% which user deleted the data. Along with similar techniques as the previous Read more
-
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 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 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 Read more
Subscribe
Sign up to be notified with any new blog posts.
thedynamicsexplorer.com 