Solved

Journal Entry # Deletion

Posted on 2013-05-20
3
597 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
Comment Utility
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
Comment Utility
the journal entry is not in any of the above tables
0
 
LVL 18

Accepted Solution

by:
Steve Endow earned 500 total points
Comment Utility
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

Better Security Awareness With Threat Intelligence

See how one of the leading financial services organizations uses Recorded Future as part of a holistic threat intelligence program to promote security awareness and proactively and efficiently identify threats.

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…
On Sep 22nd 2014 Microsoft released Update Rollup 1 for Microsoft Dynamics CRM 2013 Service Pack 1 and back in July Update Rollup 3 was released.  So we now have:   Update Rollup 1Update Rollup 2Update Rollup 3Service Pack 1Update Rollup 1 for S…
Excel styles will make formatting consistent and let you apply and change formatting faster. In this tutorial, you'll learn how to use Excel's built-in styles, how to modify styles, and how to create your own. You'll also learn how to use your custo…
Get a first impression of how PRTG looks and learn how it works.   This video is a short introduction to PRTG, as an initial overview or as a quick start for new PRTG users.

762 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

Need Help in Real-Time?

Connect with top rated Experts

9 Experts available now in Live!

Get 1:1 Help Now