Solved

Journal Entry # Deletion

Posted on 2013-05-20
3
608 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 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

PRTG Network Monitor: Intuitive Network Monitoring

Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
Microsoft Retail Management Sql Error 3 71
dynamics crm 2013 1 91
CRM 2011 Cascade Quote to Order and Order to Invoice 4 76
Value Lookup 10 48
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…
This Micro Tutorial will give you a basic overview how to record your screen with Microsoft Expression Encoder. This program is still free and open for the public to download. This will be demonstrated using Microsoft Expression Encoder 4.
This Micro Tutorial hows how you can integrate  Mac OSX to a Windows Active Directory Domain. Apple has made it easy to allow users to bind their macs to a windows domain with relative ease. The following video show how to bind OSX Mavericks to …

773 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