Sage 100

 View Only

  • 1.  VI Payroll Import version 2021

    Posted 03-03-2022 15:50
    When payroll was first upgraded and a VI Import job only had the EmployeeKey and not the DepartmentNo and EmployeeNo, we could somehow get these into the field names to use.  I do not remember how I did this, I'm pretty sure I read it on 90Minds, possibly @Beth Bowers or @Sue Bennett.  I have upgraded a client from 2019 standard to 2021 advanced and this import job is stating it cannot find the fields.  This specific table is PR_EmployeeDocuments.  I know there is a table to go to thru DFDM to change a field from read only to write and you change the 0 to a 1 or vice versa.  I have not been able to locate my file that provides specifics.


    ​​

    ------------------------------
    [Michele] [Herzog] [CPA,CITP, CGMA]
    [Overland Park] [KS]
    [816-520-1365]
    ------------------------------


  • 2.  RE: VI Payroll Import version 2021

    Posted 03-03-2022 15:54
    I don't know of a way to do that.  I only know how to use Temp fields for Dept and Employee and then the calculation for the EmployeeKey OR if you have the field as DD-EEEEEEE in one field, you can just read that into EmployeeKey.

    ------------------------------
    Beth Bowers
    Mom to Samson, Peanut, ChiChi, Canton, Cagney and Daisy (NO Oxford comma - shriek!)
    Tennessee Software Solutions
    269-445-1625
    ------------------------------



  • 3.  RE: VI Payroll Import version 2021

    Posted 03-04-2022 08:36
    I am confused @Michele Herzog.  Are you saying the temp field workaround for PR data entry does not work or you can't recall how to do it?
    ​

    ------------------------------
    Jeff Schwenk
    FORMER 90M Board Member -140,000,000 is a TERRIBLE thing to waste!!!
    Bottomline Software, Inc.
    Waynesboro VA
    540-221-4444
    ------------------------------

    Original Message


  • 4.  RE: VI Payroll Import version 2021

    Posted 03-04-2022 09:40
    Dept and EE in temp fields:

    EmployeeKey, CALC,

    _obj'ConvertToEmployeeKey$(Temp001$,Temp002$)

    That is for Payroll D/E, not sure if works for other objects.

    ------------------------------
    Eric Lunceford
    First Mate Business Solutions
    Oklahoma City, OK
    877-880-8960
    https://www.firstmatellc.com/
    ------------------------------

    Original Message


  • 5.  RE: VI Payroll Import version 2021

    Posted 03-04-2022 10:19
      |   view attached
    Here is the actual KB to enhance what @Eric Lunceford posted.  If this doesn't work, then you could extract the employee key for each employee via a Crystal report.  @Dan Burleson has a nifty way of extracting the information without Crystal as well.
    ​​

    ------------------------------
    Jeff Schwenk
    FORMER 90M Board Member -140,000,000 is a TERRIBLE thing to waste!!!
    Bottomline Software, Inc.
    Waynesboro VA
    540-221-4444
    ------------------------------

    Original Message


  • 6.  RE: VI Payroll Import version 2021

    Posted 03-04-2022 12:19

    Michelle – I'm happy to put you in touch with Marty at our office, who does all of our payroll imports (and we have quite a few!):

     

    Here are her notes:

     

    Bring in the Department (Temp001$) and Employee No (Temp002$) into Temp fields then set the Employee Key as follows:  Operation = Calculated

    Calculation = _obj'ConvertToEmployeeKey$(Temp001$,Temp002$)

     

    And the temp fields need to be set up like this:

     

     

     

    Sue Bennett | President

    Bennett/Porter & Associates, Inc.

    P. 503 620 3484 | F. 503 620 2765

    12559 SW 69th Ave | Portland, OR  97223

    Email address | www.benpor.com

    Bennett/Porter Blog | facebook | twitter

     

    The information in this email and any attachments is considered confidential. This information may be subject to legal, professional, or other privilege. It must not be disclosed to any person without our authority. If you are not the intended recipient you are not authorized to and must not disclose, copy, distribute, or retain this message or any part of it. Please return this message to the sender immediately and delete any and all copies from your system.

     

     






  • 7.  RE: VI Payroll Import version 2021

    Posted 03-05-2022 18:31
    Thank you for your input @Sue Bennett, @Beth Bowers, @Jeff Schwenk, @Eric Lunceford.  As it turns out, the VI job that had the department and employee number fields were from the old payroll framework.  My client told me they were being used and as I started to fix 40 import jobs, I realized they had to be old jobs.  I questioned my client again and found out the jobs were not being used.​​​​

    ------------------------------
    [Michele] [Herzog] [CPA,CITP, CGMA]
    [Overland Park] [KS]
    [816-520-1365]
    ------------------------------

    Original Message


Related Content