-
Only a short post however I thought I’d blog this one as its a frequent query we receive on the Bank Management module in Dynamics GP. Clients who have the “Bank Management” module for Dynamics GP will often create a new chequebook via “Cards > Financial > Chequebook” and notice the “Bank Management” option isn’t…
-
A colleague and I worked on a very interesting support ticket today. A client reported that when logging into Dynamics GP using their own Dynamics GP User ID they received the error “No Obligations Found” when retrieving the obligations for the VAT Return however it worked fine when logged in as “sa”. **Please note there…
-
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…
-
I encountered this error when a client was trying to select a vendor in the “Edit Payables Cheque Batch” window. A screen shot of the error is below The error occurred when trying to select a vendor from the list in the left hand pane of the window. To troubleshoot this I created a SQL…
-
I had a client report this issue recently which was preventing them submitting the VAT return to HMRC via the government gateway. The exact error is below After some digging it seems the period key is passed down from HMRC when the obligations are retrieved therefore its strange that the error is produced when submitting…
-
A client reported that when reprinting a remittance via the “Recreate Check Stub” option it was correctly reprinting the remittance however another remittance for a totally different vendor was also printing at the same time? The option being used for the remittance reprint is below To troubleshoot I looked at the main table used on…
-
A client was experiencing the error “Install Microsoft Word” on the exception report for lots of statements when emailing a high volume of customer statements when running Dynamics GP 2013. After searching online I found the following thread in the community forum https://community.dynamics.com/gp/f/32/t/137272 This mentioned the exact same issue and a user named Pam Robertson…
-
A client reported the following error on the posting journals when trying to post both Receivables and Payables Transactions. “This transaction contains multi-currency error(s)” This was followed by a message informing them that the batch had gone to recovery. I checked the usual things like exchange rate expiration dates however everything seemed fine. The client…
-
Introduction On occasion a batch can be accidentally deleted from the system, and for one reason or another it would be interesting to find out which user did this. In this post I aim to show how this might be possible using some SQL functions to query the SQL transaction log. (I appreciate there are…
-
I recently had an issue where a user was stuck in a batch in the Bank Management module. You can usually run the “Clear Activity” option to resolve the issue however on this occasion it didn’t work. I found I had to manually delete a row in an SQL table to clear the lock and…