Can't find fields needed to recreate a PR report.

SOLVED

I have a report from v2017 that utilizes the table PR4_EmployeeEarningDeduction.  The documentation says that in v2019 the equivalent table name is PR_EmployeeDeduction.  The problem is that the new table doesn't seem to include earning information, and does not contain the two fields I need:

  • Month1EarningHours
  • Month1EarningAmount

Is there an alternate strategy for retrieving this information?  The purpose of the report is to return employee overtime totals for the month.

Thanks,

Eric

Parents
  • 0

    A little more info...

    I've tried using PR_EmployeeEarningsHist in place of PR4_EmployeeEarningDeduction.  It seems to work for July and August, but the numbers for June are way too high.  The report doesn't return any data for months prior to June 2020.

    Eric

  • +1 in reply to emaher
    verified answer

    With the conversion to Payroll 2.x, some of the data is converted strange.  For the current quarter, the information in put in the correct months, but all entries for the prior quarters are entered in the last month of the prior quarter.  So i would expect the number in June is actually January through June.

Reply
  • +1 in reply to emaher
    verified answer

    With the conversion to Payroll 2.x, some of the data is converted strange.  For the current quarter, the information in put in the correct months, but all entries for the prior quarters are entered in the last month of the prior quarter.  So i would expect the number in June is actually January through June.

Children