Sage 100

 View Only

  • 1.  PR_EmployeeDeductionHist Import

    Posted 05-07-2021 15:48
    Has anyone figured out a way to import into PR_EmployeeDeductionHist?

    We have a client that wants to significantly revamp their PR Deduction Codes and that includes modifying history so that check stubs aren't a confusing mess.

    PR_EmployeeDeductionHist isn't available in VI and I'm trying to figure out a way to get the data altered without going the totally custom MD route.  If push comes to shove, we'll have to go the MD route and brute force it somehow, but hoping others have ventured down this path previously.

    ------------------------------
    Thanks,

    Kevin Wesley
    Lehman, Wesley & Associates
    kevin@lehmanwesley.com
    http://www.lehmanwesley.com/
    ------------------------------


  • 2.  RE: PR_EmployeeDeductionHist Import

    Posted 05-10-2021 09:23
      |   view attached
    @Kevin Wesley  So VI allows access to the PR_EmployeeDeductionHist table if you want to EXPORT the data, But VI does not give you access if you want to IMPORT.  I would have thought access would always be a two-way street. ​

    ------------------------------
    Michael McDonald - Consultant
    Michael T McDonald CPA
    616-813-8887 - mike@mcdcpa.com
    ------------------------------



  • 3.  RE: PR_EmployeeDeductionHist Import

    Posted 01-19-2022 18:48
    @Kevin Wesley what did you end up doing here?

    We have been importing into this table for the last couple of years to populate amounts for Box 12 DD.

    Apparently, a Payroll update at some point took away the business object for this table! It was available at least on 2.20.0, but not in 2.2​1.0+

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



  • 4.  RE: PR_EmployeeDeductionHist Import

    Posted 01-20-2022 08:46
    They fired the HR Manager and all of a sudden it wasn't such an issue anymore.

    Some things are really just that simple.

    ------------------------------
    Kevin Wesley
    Lehman, Wesley & Associates
    kevin@lehmanwesley.com
    http://www.lehmanwesley.com/
    ------------------------------

    Original Message


Related Content