Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Dynamics 365 Community / Forums / Microsoft Dynamics GP (Archived) / User tool to identify ...
Microsoft Dynamics GP (Archived)

User tool to identify a locked record?

(0) ShareShare
ReportReport
Posted on by DosatronUSA 135

While there is a window that can be used to identify batches being used by individuals (Navigation is Inquiry:System:Batch), is there a window/tool that can identify who has locked an individual record?  I have tried looking for an answer in the Dynamics GP help documentation and CustomerSource, but have not been able to find anything. 

We are using Dynamics GP version 9 and the typical situation that occurs is that someone leaves a sales order transaction open on their PC.  Another person will then need to access that sales order transaction but cannot as it is locked by the other user.  GP 9's message does not identify who the user is and we would like an easy way for them to find that information out so that they can contact the person who has locked the record.

 Thank you in advance for any ideas on this issue.

*This post is locked for comments

  • Ron Draganowski Profile Picture
    Ron Draganowski 1,575 on at
    Re: User tool to identify a locked record?

    Is it an option to create a Crystal Report or a SQL Report?  SQL report is ideal.  Remember that on GP10 all sorts of free SQL Reports are coming your way, so be sure to upgrade to SQL Server 2005 when you move to GP 10 so you can take advantage of them.

     When you install SQL Reporting Services, create a new report for "Sales Document Locks".  Here's the query you need:

    SELECT 'Sales Documents' as LockType, DexSession.sqlsvr_spid , ISNULL(sysproc.loginame, 'Disconnected') as LoginName,

    SOP10100.SOPNUMBE as SOPNumber,

    CASE SOP10100.SOPTYPE WHEN 1 THEN 'Quote' WHEN 2 THEN 'Order' WHEN 3 THEN 'Invoice'

    WHEN 4 THEN 'Return' WHEN 5 THEN 'Back Order' WHEN 6 THEN 'Fulfillment Order' else 'Unknown' END as SOPType,

    SOP10100.CUSTNMBR as CustNumber

    FROM tempdb..DEX_LOCK DexLock

    INNER JOIN tempdb..DEX_SESSION DexSession ON DexLock.session_id = DexSession.session_id

    INNER JOIN SOP10100 ON DexLock.row_id = SOP10100.DEX_ROW_ID

    LEFT OUTER JOIN master..sysprocesses sysproc ON DexSession.sqlsvr_spid = sysproc.spid

    WHERE DexLock.table_path_name = RTRIM(DB_NAME()) + '.dbo.SOP10100'

    Take care,

    Ron Draganowski
    Senior Solution Developer
    Olsen Thielen Technologies, Inc.
    rdrag@ottechnologies.com
    www.ottechnologies.com     

     

    Find me on LinkedIn: http://www.linkedin.com/in/rondraganowski

     

  • DosatronUSA Profile Picture
    DosatronUSA 135 on at
    Re: User tool to identify a locked record?

    Farooque,

    Thank you for the quick response! 

    When we went to the Business Ready Licensing - Advanced Management structure last year, I was happy with all of the new modules we were able to use which we could never justify licensing under the old pricing structure.  Unfortunately, the Smartlist Builder is an add-on module that is not included and we do not have it. 

    If the alternative is to create a custom window that runs the query on the SY00800 table to display to users, then we will have to evaluate whether we go that way or if the additional functionality of the Smartlist Builder will be worth the extra licensing cost.

    Thank you for the help with this question. 

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    Re: User tool to identify a locked record?

    Hi There,

     You can create a smartlist for the table SY00800 in Dynamics database with the help of Smartlist Builder and you can run it and see which will give you the details about the batches and the records they are working on, later when you want to free the record you can just go ahead and delete it.

    Hope this helps,

    Farooque. 

     

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,235 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans