Solved

Journal Entry # Deletion

Posted on 2013-05-20
3
621 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 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 500 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

Revamp Your Training Process

Drastically shorten your training time with WalkMe's advanced online training solution that Guides your trainees to action.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

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…
For cloud, the “train has left the station” and in the Microsoft ERP & CRM world, that means the next generation of enterprise software from Microsoft is here: Dynamics 365 is Microsoft’s new integrated business solution that unifies CRM and ERP fun…
Nobody understands Phishing better than an anti-spam company. That’s why we are providing Phishing Awareness Training to our customers. According to a report by Verizon, only 3% of targeted users report malicious emails to management. With compan…
Attackers love to prey on accounts that have privileges. Reducing privileged accounts and protecting privileged accounts therefore is paramount. Users, groups, and service accounts need to be protected to help protect the entire Active Directory …

726 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