Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Dynamics 365 Community / Forums / Microsoft Dynamics GP (Archived) / Another user is workin...
Microsoft Dynamics GP (Archived)

Another user is working with this record

(0) ShareShare
ReportReport
Posted on by Syrus 4,156

Hello All,

I understand that this question has been raised many many times while there is no solid answer. It occurs in GP-Manufacturing ( ver. 10 SP 4) where there are some orphans QMOs/MOs hung up and when I try to access these; to cancel or delete, an error message pops up saying " Another user is working with this record"

It has also been pointed to download an Automated solution from Customer Source which I have tried but it does not work.

Can anyone or Microsoft look into this issue and advise, how to handle this situation.

Regards,

 

 

 

 

*This post is locked for comments

  • bnschulz Profile Picture
    bnschulz 15 on at
    RE: Another user is working with this record

    This was awesome help! Can you tell me, can we simply delete these records from WO010032, or is there a better way to resolve these hung items?

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Another user is working with this record

    You can detect those types of record, by cheking MANUFACTUREORDERST_I = 0

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Another user is working with this record

    Hi! In my experience, is a dirty record that remains in the WO010032 table only.

    Regards,

  • Richard Wheeler Profile Picture
    Richard Wheeler 75,730 on at
    Re: Another user is working with this record

    The usual fix for locked records is

    DELETE DYNAMICS..ACTIVITY

    DELETE DYNAMICS..SY00800

    DELETE DYNAMICS..SY00801

    DELETE TEMPDB..DEX_LOCK

    DELETE TEMPDB..DEX_SESSION

    While no one is in GP.

    You could also try stopping/starting SQL or simply rebooting your SQL box.

  • Syrus Profile Picture
    Syrus 4,156 on at
    Re: Another user is working with this record

    Very strange, no reply or feedback even by microsoft

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

Quick Links

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Top 10 leaders for November!

Congratulations to our November super stars!

Tips for Writing Effective Suggested Answers

Best practices for providing successful forum answers ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,280 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,214 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans