Sage 100

 View Only
  • 1.  JobOps Employee List

    Posted 08-09-2019 09:45
    JobOps 2018 - the employee list in Administrative time entry shows and employee dept-employee number that does not exist in PR_Employee.  Where does this screen pull its list from?

    ------------------------------
    Phil McIntosh
    President
    Friendly Systems, Inc.
    Asheville NC
    678.273.4010 ext 5
    ------------------------------


  • 2.  RE: JobOps Employee List

    Posted 08-09-2019 10:06
    If looking at PR_Employee via DFDM remember that the primary key is Employee Key (not employee #).  Switch to kEMPLOYEE and you may find the records.

    ------------------------------
    Lee Graham
    Friendly Systems, Inc.
    ------------------------------



  • 3.  RE: JobOps Employee List

    Posted 08-09-2019 12:02
    Did that - not there.

    ------------------------------
    Phil McIntosh
    President
    Friendly Systems, Inc.
    Asheville NC
    678.273.4010 ext 5
    ------------------------------



  • 4.  RE: JobOps Employee List

    Posted 08-09-2019 12:13
    Do you see a JT_Employee file?

    ------------------------------
    Lee Graham
    Friendly Systems, Inc.
    ------------------------------



  • 5.  RE: JobOps Employee List
    Best Answer

    Posted 08-09-2019 13:07
    In case anyone else runs across this:  It appears that on converting to the new payroll, if JobOps had a record in JT_Employee that it can't find a match for in PR_Employee, it attempts to match on the name fields (and maybe others) and puts the new ID on it.
    30-0000077 Bob Jones - no PR_Employee record
    30-0000486 Bob Jones - PR_Employee.ID F32CD... this ID is on both records in JT_Employee

    ------------------------------
    Phil McIntosh
    President
    Friendly Systems, Inc.
    Asheville NC
    678.273.4010 ext 5
    ------------------------------