?
Solved

Journal Entry # Deletion

Posted on 2013-05-20
3
Medium Priority
?
635 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 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

 [eBook] Windows Nano Server

Download this FREE eBook and learn all you need to get started with Windows Nano Server, including deployment options, remote management
and troubleshooting tips and tricks

Question has a verified solution.

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

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…
Desired Skill Set for Microsoft Dynamics CRM Technical Resources – Part I
In this brief tutorial Pawel from AdRem Software explains how you can quickly find out which services are running on your network, or what are the IP addresses of servers responsible for each service. Software used is freeware NetCrunch Tools (https…
Add bar graphs to Access queries using Unicode block characters. Graphs appear on every record in the color you want. Give life to numbers. Hopes this gives you ideas on visualizing your data in new ways ~ Create a calculated field in a query: …
Suggested Courses

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