Improve company productivity with a Business Account.Sign Up

x
?
Solved

Journal Entry # Deletion

Posted on 2013-05-20
3
Medium Priority
?
682 Views
Last Modified: 2013-06-04
we have a journal entry # in the financial module of GP 2010 that says it is being used by another user and will not let us do anyting with it.  Says it has been entered in another window.  How can we delete this in SQL??
0
Comment
Question by:pstre
  • 2
3 Comments
 
LVL 18

Expert Comment

by:Steve Endow
ID: 39183381
Hi,

Does the dialog box say this?

"This journal entry is being edited by another user.  Enter a different journal entry number"

If so, the record is probably being locked in the DYNAMICS..SY00801 table.

Try running this query:

SELECT * FROM DYNAMICS..SY00801 WHERE RSRDESC = 'GL_Normal'

Look for a record where the "RSRCID" field value matches the JE number you are trying to enter.  Review the record and see which user ID is associated with the record lock.

Next, check the Dynamics Activity table:

SELECT * FROM DYNAMICS..ACTIVITY

Make sure the user listed on the SY00801 record is not present in the Activity table.  If the user is listed, have them log out  and close GP completely, then re-query the Activity table to make sure their session record is no longer listed.

After the user's record is gone from the Activity table and they have closed GP, re-query the SY00801 table to see if the lock record is gone.

If the lock record is still present, you should be able to delete the single record from SY00801.

DELETE FROM DYNAMICS..SY00801 WHERE RSRDESC = 'GL_Normal' AND RSRCID = <jenumber> AND USERID = '<user>'

(modify the statement to use the actual JE number and user ID)

Let me know if that helps.

Thanks,

Steve Endow
Dynamics GP Certified Trainer
Dynamics GP Certified IT Professional
0
 

Author Comment

by:pstre
ID: 39199942
the journal entry is not in any of the above tables
0
 
LVL 18

Accepted Solution

by:
Steve Endow earned 2000 total points
ID: 39201574
Hi,

Can you post the exact message that you receive?  Or a screen shot of the message that appears?

Thanks,

Steve Endow
Dynamics GP Certified Trainer
Dynamics GP Certified IT Professional
0

Featured Post

The 14th Annual Expert Award Winners

The results are in! Meet the top members of our 2017 Expert Awards. Congratulations to all who qualified!

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

This is a walkthrough guide I wrote whilst upgrading my on-premise MS Dynamics CRM 3.0 deployment to 4.0. This covers the actual installation of the product to a working level for my system, I ran into a lot of issues that the steps below fixed so h…
Desired Skill Set for Microsoft Dynamics CRM Technical Resources – Part I
The video will let you know the exact process to import OST/PST files to the cloud based Office 365 mailboxes. Using Kernel Import PST to Office 365 tool, one can quickly import numerous OST/PST files to Office 365. Besides this, the tool also comes…
Watch the video to know the process of migration of Exchange or Office 365 mailboxes in absence of MS Outlook. It is an eminent tool which can easily migrate Public, Archive user mailboxes from one another Exchange server and Office 365. Kernel Migr…

595 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question