Dynamics GP – Clear Activity in Bank Management – Delete from CBEU1020

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.

Select “Tools > Routines > Financial > Bank Management > Clear Activity”

Select “Clear Activity”

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)

I could then access the batch.

Thanks for reading

Dynamics GP – Letter Writing Assistant – Letter Templates missing following upgrade to Dynamics GP 2018 R2

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.

Thanks for reading

Dynamics GP – Your login failed because of a database error. Contact your system administrator for assistance

Recently I encountered an issue when a user was attempting to login to Dynamics GP. After entering their user name and password they were receiving the error below which prevented access:

Your login failed because of a database error. Contact your system administrator for assistance.

On this occasion I found to fix the issue I had to remove the users login from the ACTIVITY and SY00800 tables in the DYNAMICS database using the SQL statements below:

DELETE FROM DYNAMICS..ACTIVITY WHERE USERID=’<UserID>’

DELETE FROM DYNAMICS..SY00800 WHERE USERID=’<UserID>’

Replace <UserID> with the User ID in question.

After running the scripts the user could then access Dynamics GP without issues.

I hope this helps anyone else who stumbles across this issue in the future.

Thanks for reading