Sage 100

 View Only
  • 1.  Payroll 2.x YTD vs MTD on reports

    Posted 02-13-2020 16:03
    I've browsed around and I'm just not seeing anyone else having this issue, so it's quite possible I'm missing something.
    I need to write a couple different reports and use the YTD amount as well as a specific MTD or Check Date range in Payroll 2.x.
    I am not finding YTD as a field anywhere.  Really liked PR3!  Any suggestions?

    ------------------------------
    Annette Egbert
    Acuity Solutions, LLC
    ------------------------------


  • 2.  RE: Payroll 2.x YTD vs MTD on reports

    Posted 02-13-2020 16:23
    PR3?

    See PR_EmployeeTaxHistory and PR_EmployeeTaxHistoryOther (by Year/Month.)

    PR_PayrollHistoryTaxDetail and PR_PayrollHistoryTaxDtlOther (by check.)


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



  • 3.  RE: Payroll 2.x YTD vs MTD on reports

    Posted 04-16-2020 16:20
    Edited by Brett Zimmerman 04-16-2020 16:29
    I haven't been able to find any new P/R files that contain YTD data, like PR4 for example in my case.  It appears the only option is to try and use PR_EmployeeEarningsHist.  Have I overlooked anything?  Also, the File Layouts Cross-Ref area states that PR4_EmployeeEarningDeduction is now PR_EmployeeDeduction, but that's incorrect. 

    ------------------------------
    - Brett
    ------------------------------