Feature: Send an Email to the User Locking a Record

Feature: Send an Email to the User Locking a Record

Release Date: 1/26/2023
Versions: Elliott V8.5 and Above

Background

Some Elliott tasks, like COP Order Entry / Change Order, will cause a record to be locked while the task is executing.  Subsequently, another user will start a task, like COP Order Entry / Print Order Acknowledgement, that will also need to temporarily lock the same record.  When that happens, the second user will see a record locked message on the screen like this, with a locked record message in the status area::


There is an Elliott event that can be subscribed to that can send an email detailing the locked record conflict to an administrator, once per minute, until the record is released by the first user.  With this update, Elliott has the ability to send an email to the first user, the one who is locking the record, as well.  This could help resolve the conflict sooner because the offending user will get notified that he/she has a record locked that is causing a conflict.

Subscribing to the Record Locked Event

To send an email to the offending user, go to Utilities / Global Setup, click on the Events button, press F5 and select the event with LCKEVENT in the Type column:

Select the E-mail and Recurring Request options on the General tab, then select the E-mail tab.  Click on the To: field, right-click and select the choice System Variables / Email by Windows UserID:

This will bring up the Select Email Variable dialog where you choose which event variable to use to look up the desired email..  Scroll through the entries in the Variable: ComboBox until you find the one with Offending User.  Press OK to save your choice:

This will insert the required text in the To: field to get the offending user's email during the processing of this event.  Complete the remaining fields as desired and press the Save button to complete the process of subscribing to the LCKEVENT event.

Notes

  • This mechanism of determining the email address of a specific Windows or Elliott user may be applied to other events, as long as there is an event variable that specifies either the Windows user or the Elliott user.
  • If, for any reason, Elliott cannot resolve the To: address, no email will be sent.

JEG
NWSMEVTV



    • Related Articles

    • Feature - Active User Report to Show Users Logged into Elliott and Optionally Send Email

      Release date: 3/6/2019 Version: 8.5 and up The Active Users report will show a list of users actively logged into Elliott. This report will also have the option of emailing users who are currently logged in and send them a predefined email message. ...

    • Feature - Added Phantom Locking to Customer File Maintenance

      Release date: 6/4/2018 In the past, when a user brought up a customer master record in Customer File Maintenance Change mode, the customer record would be locked. Any other users who tried to update that customer record -- including when printing a ...

    • Feature - Added Phantom Locking to Item File Maintenance

      Release date: 6/4/2018 In the past, when a user brought up an item master record in Item File Maintenance Change mode, the item record would be locked. Any other users who tried to update that item record -- including quantity on hand, on order, or ...

    • EM API - Create and Send an Email

      Release Date: 12/23/20 Version: 7.0 and Higher This is a set of API calls introduced after Elliott 6.X.060. Use them collectively. They will send out emails through the SMTP or MAPI interface. Developers who use these API calls do not need to know ...

    • Elliott SMTP Email Settings for Outlook 365 or Hosted Email Solutions

      Release Date: 1/19/2018 Revision Date: 9/26/2022 Version: 8.0 & Up Introduction Starting with Elliott V8, we support both SMTP and MAPI interfaces for sending emails. MAPI is the old email interface method, which we find more and more difficult to ...