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

Payroll Reporting

 6 Replies
 0 Subscribed to this topic
 68 Subscribed to this forum
Sort:
Author
Messages
David Newton
New Member
Posts: 1
New Member
1/5/2012 3:30 PM
    I'll open this discussion with a simple question that has (I believe) a not-so-simple solution... Is there anyway in Lawson to run a report that shows a list of available reports with description? I find the Lawson canned reports to be lacking, but if I could just see the available reports, I might find some of the things I'm looking for!

    Any help is greatly appreciated!!
    Greg Moeller
    Veteran Member
    Posts: 1498
    Veteran Member
    1/5/2012 3:58 PM
      Have your admin (or you if you have access to LID)... do this.
      rngdbdump -cnt gen screen

      Or to create a file rngdbdump -cnt gen screen > ~/filename.csv

      It will give you a brief description of what each screen (and report) does.

      You can then import this file into Excel, and go from there.
      Greg Moeller
      Veteran Member
      Posts: 1498
      Veteran Member
      1/5/2012 4:00 PM
        To get the column headers leave the n off of the switches.
        rngdbdump -ct gen screen
        Greg Moeller
        Veteran Member
        Posts: 1498
        Veteran Member
        1/5/2012 4:04 PM
          More for the Lawson group, the command would be:
          rngdbdump -ct gen screen | lashow from LID
          stephanie
          Veteran Member
          Posts: 330
          Veteran Member
          1/5/2012 4:23 PM
            Hi Dave - if you want to contact me off line (stephanie.harris@mail.house.gov) I have an excel spreadsheet that I created manually that lists form number, name, and a brief description of the data within the report. It's only updated up to v8.1 apps, but it's a good start. Steph
            John Henley
            Posts: 3353
            1/5/2012 5:56 PM
              Interestingly, Lawson used to publish these and even included samples! Just my opinion, but I think keeping it updates as new versions were released, combined with the proliferation of Crystal and other reporting solutions as well as the HR report writer, made Lawson's canned reports look very limited.
              Thanks for using the LawsonGuru.com forums!
              John
              stephanie
              Veteran Member
              Posts: 330
              Veteran Member
              1/5/2012 7:10 PM
                Thanks John, for allowing me to REALLY feel my age, because when I counted back how many years ago it was that Lawson provided that info, I almost fainted that I've been alive that long.... I agree, though - with the advent of the other reporting tools and options, as handy as the standard reports can be, other tools allow so much more flexibility.