SYS: Note Activity Locking
Note Activity Locking provides record-level activity tracking and locking for Record Notes in GP. If two users attempt to edit the same note, the second user to open the note will receive a warning message which indicates the note is lock, and by whom, and the Note window will be completely uneditable.
Setup
Navigation: Tools >> Setup >> Company >> Setup GP PowerPack
Mark the box next to TWK-SYS: Note Activity Locking, then click DONE.
The feature will be enabled for the current user. Other users must restart their Dynamics GP client to enable this feature.
Using Note Activity Locking
When the same Record-level note is opened by more than one user, the first user will have full-editable access to the note.
Subsequent users will receive a warning that the note is locked, and by which user.
The note will be locked, along with the buttons along the bottom of the window.
The Note Activity Locking feature uses the DEX_LOCK table in the tempdb. The lock is added when a user opens the note, and removed when the user closes the note. In the event a note becomes locked and there are no users with it open, delete records from the DEX_LOCK table where the table_path_name = TWO.dbo.SY03900 (replace TWO with the correct company name).