User tool to identify a locked record?

• 03-25-2008 8:41 AM

  DosatronUSA Joined on 03-25-2008 Posts 2

  User tool to identify a locked record? Reply Contact 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.

• 03-25-2008 12:47 PM

  In reply to

  Farooque Shaikhsorab Joined on 03-25-2008 Posts 7	Re: User tool to identify a locked record? Reply Contact 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.

• 03-26-2008 7:06 AM

  In reply to

  DosatronUSA Joined on 03-25-2008 Posts 2

  Re: User tool to identify a locked record? Reply Contact 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.

• 03-28-2008 6:48 AM

  In reply to

  Ron Draganowski Joined on 10-04-2007 St. Paul, MN Posts 35

  Re: User tool to identify a locked record? Reply Contact 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

  Tags: Microsoft Dynamics GP, Sales Order Processing, Record Locking