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 allow the user access to the batch.
The exact issue they received is as follows:
With this error message the first thing to try is to clear activity and although this didn’t work on this occasion I’ll detail the steps below.
Ensure there are no users in Dynamics GP and click “Yes” to the message below. (rather than asking everyone to log out I usually just ensure there’s nobody doing any Bank Management activities)
After doing this you will be prompted with the message below confirming activity is cleared
However I found I still couldn’t access the batch. On investigation there is still some activity for the batch in the CBEU1020 table which needed clearing. I therefore ran the SQL query below in the company database to delete the row. (replace TWO18 with the name of your company database)
Following a recent client upgrade of Dynamics GP to version 2018 R2 I found that when selecting “Write Letters > Print Debtors” the window was blank:
I opened the C:\Program files (x86)\Microsoft Dynamics\GP2018R2\Data\DEX.INI file to find the Letters Directory location and when I checked each sub folder in this shared folder the word documents (.DOC files) were present.
On investigation it seems previous versions of Dynamics GP used to expect files in the DOC format however its now expecting them to be in the DOCX format. Therefore, I opened each one and saved them as DOCX files and they are now available.
I hope this helps anyone else who may encounter this issue.