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

Question

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

Bvulliamy · Accepted 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.

Sage 100

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

Top Replies

COMMUNITY

COMPANY

PARTNERS

SUPPORT & TRAINING