Prev
Next
Forums Human Capital Management Lawson S3 HR/Payroll/Benefits

ESS Address Change notification to HR on Windows platform

 4 Replies
 0 Subscribed to this topic
 68 Subscribed to this forum
Sort:
Author
Messages
TBonney
Veteran Member
Posts: 281
Veteran Member
8/4/2009 4:10 PM

    We are on 9.0 environment and Apps, on a Windows platform, also running ESS/MSS 9.0.

    Through researching Lawson  KB articles and LIS sessions, we have come to realize that although there is an option to notify HR of any address changes made by employees through ESS (by the setup of the HS07 screen), it only produces the email, but does not send it. It simply renders the email on their screen, but is then reliant upon the end user to hit the 'SEND' button in order for it to actually be sent to HR.

    I have asked Lawson if there is any workaround developed for this and of course was simply told that this is a Windows limitation and that I could submit an enhancement request to have it reviewed. Has anyone else on Windows come up with a way to work around this and provide HR with the notification they desire? Thank you.

    Jay Riddle
    Veteran Member
    Posts: 191
    Veteran Member
    8/4/2009 4:39 PM
      You can easily add a trigger onto the table and then write a report against it. Smart Notes or whatever.

      CREATE TRIGGER [xxAuditUpdateEMPLOYEE] ON [dbo].[EMPLOYEE]
      FOR UPDATE
      AS
      BEGIN
      SET NOCOUNT ON

      INSERT INTO XXEMPADDR
      (
      R_ACTION
      ,COMPANY
      ,EMPLOYEE
      ,FIRST_NAME
      ,LAST_NAME
      ,ADDR1
      ,ADDR2
      ,CITY
      ,STATE
      ,ZIP
      ,MODIFIED_DATE
      ,MODIFIED_TIME
      )
      SELECT
      delta.R_ACTION
      ,delta.COMPANY
      ,delta.EMPLOYEE
      ,delta.FIRST_NAME
      ,delta.LAST_NAME
      ,delta.ADDR1
      ,delta.ADDR2
      ,delta.CITY
      ,delta.STATE
      ,delta.ZIP
      ,getdate()
      ,dbo.XX_LAWSON_TIME(getdate())
      FROM
      (
      SELECT 'AFTER' AS R_ACTION, i.* FROM inserted i
      UNION ALL
      SELECT 'BEFORE' AS R_ACTION, d.* FROM deleted d
      ) delta
      , inserted i
      , deleted d
      WHERE i.COMPANY = d.COMPANY
      AND i.EMPLOYEE = d.EMPLOYEE
      AND i.COMPANY = delta.COMPANY
      AND i.EMPLOYEE = delta.EMPLOYEE
      AND (i.ADDR1 <> d.ADDR1 OR i.ADDR2 <> d.ADDR2 OR i.CITY <> d.CITY OR i.ZIP <> d.ZIP OR i.STATE <> d.STATE)


      SET NOCOUNT OFF
      Derek Czarny
      Veteran Member
      Posts: 63
      Veteran Member
      8/4/2009 5:20 PM
        If the employee changing their address creates a record in pa52, you could create a processflow that will send the email, based on that action. I am not sure if the ESS functions create a pa52 record or not.
        Gary Davies
        Veteran Member
        Posts: 248
        Veteran Member
        8/4/2009 5:30 PM
          It does a direct call to HR11 to update. I am having a similair issue with custom code I am developing for a Windows client, apparently the EMAIL object doesn't work seamlessly in Windows.

          You could create a email notification processflow and trigger it in empaddress. When you customize ESS though you have to track the changes because patches can wipe them out, it is not as simple as upgrades for 4GL. The problem with Database triggers is they have to be reapplied during upgrades.

          If I find a better resolution for my issue I will pass it on.

          John Henley
          Posts: 3353
          8/4/2009 6:27 PM
            I did a bunch of work on this a few years ago, and I remember the problem is due to browser security (i.e., you don't want a rogue website to start sending emails from your browser via JavaScript). So, you can't rely on the user interaction that is required when using the email object from JavaScript.

            Naturally, I can't remember who I did this for, nor what the solution was...

            I do remember that the solution was to send the email from the server; I don't remember if I used an HR11 user exit or had a server-side script that was called from the ESS page...

            Thanks for using the LawsonGuru.com forums!
            John