web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

🚀 Season of Sharing Community Challenge Launch!
Ask A Community Pro
Introducing our New Video Series: Community Spotlight
News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Microsoft Dynamics GP (Archived) / Receivables Transactio...
Microsoft Dynamics GP (Archived)

Receivables Transaction Entry

(0) ShareShare
ReportReport
Posted on by joeyinlfs 37

I have a credit memo transaction that is completely stuck and I couldn't access the document. It gives me an error "You may not edit this document. It is being edited by another user." but no one has it open.

What can I do to be able to access the document? Any help would be appreciated. 

Thank you.

Joe

*This post is locked for comments

I have the same question (0)
  • Suggested answer
    Kumar_Sat Profile Picture
    Kumar_Sat 1,290 on at

    Check if there is any record locked in SY00800/SY00801? These are Dynamics database tables. Also, I have seen if there is a batch with the user ID name or blank batch ID, it could give you trouble too. Most of the time, you would find the answer in the above 2 tables. Also cheque the batch status in SY00500.

  • joeyinlfs Profile Picture
    joeyinlfs 37 on at

    Thank you Kumar for the suggestion. I did check the SY00800, SY00801, ACTIVITY, DEX_LOCK and DEX_SESSION and they are all clear of records. I also did a query on SY00500 to look up the batch and it is no longer on this table. I also tried to look up the stuck document on tables RM20101 and RM30101 but it was not there too. Is there any other tables I can look into?

  • Suggested answer
    coquisalsa Profile Picture
    coquisalsa 2,725 on at

    This script might help you to identify who is locking the credit memo:

    SELECT tempdb.dbo.DEX_LOCK.table_path_name, master.dbo.sysprocesses.loginame, dbo.SOP10100.SOPNUMBE, dbo.SOP10100.CUSTNMBR
    FROM tempdb.dbo.DEX_LOCK LEFT OUTER JOIN
    dbo.SOP10100 ON tempdb.dbo.DEX_LOCK.row_id = dbo.SOP10100.DEX_ROW_ID LEFT OUTER JOIN
    tempdb.dbo.DEX_SESSION ON tempdb.dbo.DEX_LOCK.session_id = tempdb.dbo.DEX_SESSION.session_id LEFT OUTER JOIN
    master.dbo.sysprocesses ON master.dbo.sysprocesses.spid = tempdb.dbo.DEX_SESSION.sqlsvr_spid
    WHERE (NOT (dbo.SOP10100.SOPNUMBE IS NULL))

  • Bill Campbell Profile Picture
    Bill Campbell 12 on at

    Jorge, just for clarification and to help the person reading this can you please let us know what the expected result is from this script?  I am trying to read through it and I got lost at the second OUTER JOIN.

    Thanks

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

News and Announcements

🚀 Season of Sharing Community Challenge Launch!
Ask A Community Pro
Introducing our New Video Series: Community Spotlight

Quick Links

Season of Sharing Community Challenge Launch!

Jump in, show your community spirit, and win prizes!

Women in Power Builds Momentum

Expanding mentorship, skilling, and AI innovation

Congratulations to the May Top 10 Community Leaders

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics GP (Archived)

#1
Dan Liebl Profile Picture

Dan Liebl 2

#2
Shravan Attelli Profile Picture

Shravan Attelli 1

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans