-
Introduction Recently I had a situation where I had to change the voucher number of a posted payables document. There is no standard way to do this via the application however it was causing issues with a third party integration so we had to investigate how this could be done. To do this task I…
-
Introduction A few weeks ago I assisted with a General Ledger year end for a GP user with a very large number of journals and consequently a very large SQL database. Usually a year end is a fairly straight forward routine, however as this user has such a large database, along with additional SQL bits…
-
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 post I also use a stored procedure and SQL job to create an alert to…
-
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…
-
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…
-
This week I dealt with a very bizarre issue affecting all Sales Order Processing Transactions that I thought was worth documenting. It started with a simple support request explaining that Sales Order Processing Invoice transactions weren’t posting due to missing distributions. See below When I connected to investigate further I found the Sales Order Processing…
-
Subscribe
Subscribed
Already have a WordPress.com account? Log in now.
thedynamicsexplorer.com 