Best Practice for PR12

 8 Replies
 0 Subscribed to this topic
 68 Subscribed to this forum
Sort:
Author
Messages
Mary Porter
Veteran Member
Posts: 337
Veteran Member
    What is the best practice for maintaining PR12? Our payroll department would like to see a history of each time a PR12 record was changed.
    and EMACHDEPST only keeps the last change, and I can't find any other tables that would hold changes. Should they be using the Effective Date fields
    if they want to make a change to an account number or Flat Amount or Percentage etc? Or is there another table that is holding all change history?
    John Henley
    Posts: 3353
      Mary, there is no table (e.g. HRHISTORY) in v9 holding the history for the ACH distributions; only automated solution I have seen for this is similar to tracking history for employee dependents, which is to use Smart Notifications (LSN) to monitor data changes on the table. Since this table (EMACHDEPST) does have effective start/end dates, I think it is safe/sufficient to use those to track changes, thereby keeping a full history. Only caveat required is to change the default flag to 'N' when changing the default account for an employee. Hope that helps, and anyone with other ideas, please chime in...
      Thanks for using the LawsonGuru.com forums!
      John
      Margie Gyurisin
      Veteran Member
      Posts: 538
      Veteran Member
        Once you get to version 10 and it could be one of the newer point releases, that history will be available on a more granular level.

        It was presented at Inforum.
        John Henley
        Posts: 3353
          You think I'd have remembered that, since I reported an issue with the v10 upgrade documentation having incorrect instructions for loading those tables (PADICT, etc.) not adding the v10 records for HR10...
          Thanks for using the LawsonGuru.com forums!
          John
          Mary Porter
          Veteran Member
          Posts: 337
          Veteran Member
            Well that's cool to know it's out there. I think we are two years away from 10 my boss wants to wait until you all get all of the bugs worked out for us ;)
            But at least we'll get to 9.1.9 this summer. Thanks Margie and John!
            Shane Jones
            Veteran Member
            Posts: 460
            Veteran Member
              Mary, we are one of the companies "working out the bugs" for you....   We are in the process of migrating to V10.   I just changed data on PR12 and it looks like it is doing much better with the change history dating.   version - 10.0.2
              Shane Jones
              Tools: HR, Payroll, Benefits, PFI, Smart Office, BSI, Portal and Self-Service
              Systems: Lawson, Open Hire, Kronos, Crystal Reporting, SumTotal Learning
              ** Teach others to fish...
              Mary Porter
              Veteran Member
              Posts: 337
              Veteran Member
                I'm sure the answer to this is NO, but, I thought I'd ask anyway. If payroll deletes a record entirely, is there anywhere to look to see who deleted it?
                stephanie
                Veteran Member
                Posts: 330
                Veteran Member
                  You are correct, Mary - unless your organization uses some kind of server auditing tool that captures all activity)
                  Mary Porter
                  Veteran Member
                  Posts: 337
                  Veteran Member
                    Thanks Stephanie. We are remote hosted so I'll ask them.