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. ...
    • How Is the Send-From Email Address Being Determined in Elliott?

      Release Date: 05/07/2024 Version: 8.x & Up Q - The shipment verification email is currently send from deferred processing at night. The "send-from email" shows this is from one of our staff. We'd like to change it to a more generic email address. How ...
    • How to Send Shipping Confirmation Email to Customer

      Q - How do we send a shipping confirmation email in Elliott? A - There are two methods, depending on whether you wish to send from Elliott or from your shipping manifest system. The following are the pros and cons: Send Shipping Confirmation from ...
    • Feature - Order Acknowledgment Email Contacts

      Release Date - 3/3/16 In Elliott, we have an existing order acknowledgement email which you can access from COP -> Processing -> Order Entry -> Print-Order-Ack -> Send Email. The purpose of the feature is to add "System Date" support to the Starting ...
    • How Do I Remind Salesmen to Send Order Acknowledgment?

      A - Some of my customers request that we automatically send them an order acknowledgment after they place an order with us. How do I accomplish that? Q - In Elliott, we have a solution to specifically address this kind of scenario: (1) Go to Elliott ...