Sage 100

 View Only

  • 1.  Payroll VI Import based of UDF value

    Posted 08-15-2024 10:27

    My client is trying to import data into Payroll Data Entry and update masterfile information from an external system. 

    The other system is able to export (CSV) with the necessary data, but it has a different values for employee numbers. We have imported those employee IDs as UDFs in Sage, so there is a link between the two systems. They have been manually entering this information, but now they want to import it.

    Challenge, when importing into Sage 100, I need the actual Sage employee number or key.

    Does anyone have any perform logic or idea on how to convert the UDF value into the Sage employee ID when importing? I am wanting to lookup the actual Sage employee no/key based on the UDF value during the import.

    I seem to recall an old Slade H. program that did this for other modules, but I have not been able to make it work on Payroll. I am guessing, that it has to do with the PII encryption.

    Thank you,

    Michael



    ------------------------------
    Michael Davis
    Warren Averett Technology Group
    ------------------------------


  • 2.  RE: Payroll VI Import based of UDF value

    Posted 08-15-2024 10:37

    I use this in a calculated pr_employee.employeekey to get the employee number  _obj'ConvertToEmployeeKey$(%PFM_HomeDeptNo$,%PFM_EmployeeNo$)



    ------------------------------
    Doug Higgs
    Midwest Commerce Solutions, Inc
    (312) 315-0960
    Chauffeur, Chef, and Personal Assistant to Sprinkles
    ------------------------------



  • 3.  RE: Payroll VI Import based of UDF value

    Posted 08-15-2024 10:43

    Additional Information:

    So in the CSV import file, the first column of Employee ID is 20050886. This is the UDF value in Sage 100 that is assigned to Sage 100 employee number of 05-LH5410.

    The second employee has 20051085 in the file and the actual Sage ID is 05-JM5513.

    I do not have the Sage department or Sage employee id in the csv file. Only the UDF value

    Thank you

    Michael



    ------------------------------
    Michael Davis
    Warren Averett Technology Group
    ------------------------------

    Original Message


Related Content