Sage 100

 View Only

  • 1.  Payroll Data Entry Import

    Posted 02-17-2025 16:01

    Has anyone created a Payroll Data Entry VI import job where the source file contains the employee division and employee numbers, but not the employee key?  A client has the division/employee # in their third party product, but the PR_DataEntryHeader table contains only the employee key.  How have you overcome that?



    ------------------------------
    Susan Pawlowic
    Sage 100 Solutions Architect
    RKL eSolutions, LLC
    spawlowic@rklesolutions.com
    (717) 735-9109 Ext. 4352
    ------------------------------


  • 2.  RE: Payroll Data Entry Import

    Posted 02-17-2025 16:06
    Edited by Beth Bowers 02-17-2025 16:07

    @Susan Pawlowic - here's the Sage doc on it - you use a cryptic formula How to import into the EmployeeKey field when using Visual Integrator on Sage 100 2018 and higher



    ------------------------------
    Beth Bowers
    (269) 358-0989
    ------------------------------



  • 3.  RE: Payroll Data Entry Import

    Posted 02-17-2025 22:34

    An oldie but a goodie.



    ------------------------------
    Jeff Schwenk
    Owner
    Bottomline Software, Inc.
    Waynesboro VA
    (540) 221-4444

    Improving bottom lines for over 25 years!
    ------------------------------

    Original Message


  • 4.  RE: Payroll Data Entry Import

    Posted 02-18-2025 08:19

    @Beth Bowers thank you!  I had totally forgotten about this, I think I used it once in 2018 or so.  



    ------------------------------
    Susan Pawlowic
    Sage 100 Solutions Architect
    RKL eSolutions, LLC
    spawlowic@rklesolutions.com
    (717) 735-9109 Ext. 4352
    ------------------------------

    Original Message


  • 5.  RE: Payroll Data Entry Import

    Posted 02-18-2025 09:06

    I wonder why Sage wouldn't just build that logic into VI? Or am I missing some hidden hazard?



    ------------------------------
    Wayne Schulz
    wayne@s-consult.com
    Schulz Consulting
    (860) 516-8990
    CT
    ------------------------------

    Original Message


  • 6.  RE: Payroll Data Entry Import

    Posted 02-20-2025 10:24

    Hi @Wayne Schulz,

    I wondered that myself. I thought it was okay to use the Division and Employee Number for the key, and it turns out I was right. I just did a test in ABC Company in 2024 using an export to Excel of my employee list:

    11-0000100 THOMAS JERRY A.
    11-0000105 JENKINS ALLEN
    11-0000130 SHAW ARTHUR

    ..etc.

    And voila, it appears to work:

    VI Job Log wEmp Nums
    I find in interesting that the first article uses a formula to extract the Employee Key, but then it has a link to another article which says:
    • H.EmployeeKey
      • Formatted DD-XXXXXXX where DD=Dept No and XXXXXXX=Employee No
      • Refer to KB86744 - How to import into the EmployeeKey for more details
    Your results may vary, but that's my little Q&D experiment (Quick & Dirty).


    ------------------------------
    Cullen Lowe | Senior Business Consultant

    Kissinger Associates, Inc.
    Office: 800-562-5456 x255 | Mobile: 717-460-3755
    cullenl@kissingerassoc.com | kissingerassoc.com
    ------------------------------

    Original Message


  • 7.  RE: Payroll Data Entry Import

    Posted 02-20-2025 10:32

    I'm not positive but I think at one time the formula was required. And then when Sage updated payroll the VI logic may have been updated as well? 



    ------------------------------
    Wayne Schulz
    wayne@s-consult.com
    Schulz Consulting
    (860) 516-8990
    CT
    ------------------------------

    Original Message


  • 8.  RE: Payroll Data Entry Import

    Posted 02-20-2025 10:57

    WOO HOO!  And now that I think about it - I may have known that. UGH, sorry.



    ------------------------------
    Beth Bowers
    (269) 358-0989
    ------------------------------

    Original Message


Related Content