Prev
Next
Forums Lawson S3 HR/Payroll/Benefits

Corelating Requisitions and Personel Actions

Sort:
You are not authorized to post a reply.
Author
Messages
topher21
New Member
Posts: 3
New Member
12/11/2007 5:52 PM
    I'm using Crystal Reports XI R1 with a regular ODBC connection and am trying to report on promotions for a set period of time and would like to try and find out (via PAJOBREQ) how many of the promotions were replacing existing headcount. I'm having the darndest time linking through between the two tables. Any suggestions in terms of structure/link type?
    Chris Martin
    Veteran Member
    Posts: 277
    Veteran Member
    12/11/2007 8:06 PM
      What table are you trying to link to PAJOBREQ?
      topher21
      New Member
      Posts: 3
      New Member
      12/11/2007 8:14 PM
        Ultimately, I'd like to get back to PERSACTHST
        John Henley
        Senior Member
        Posts: 3348
        Senior Member
        12/11/2007 8:21 PM
          I'm not sure you're going to be able to guarantee an exact match/logic.
          You can try going from PAJOBREQ to PAREQOFFER first. That will get you the applicant->employee link.
          From there you can go to PERSACTHST and isolate the hire actions your company uses, etc. and probably get a good match.
          Thanks for using the LawsonGuru.com forums!
          John
          You are not authorized to post a reply.