Print ROE Troubleshooting – Error: Must be Non-Negative

Print ROE Not Processing – Error: Must be Non-Negative

ISSUE: Payroll > ROE > Print ROE yields the below error

Troubleshooting Steps:

select * from EC_EMPLOYEE_DAILY_EI_DATA

where EMPLOYEE_ID = 'xxxxx'

and EI_DATE > '2022-01-31'

**Ensure no negative EI_EARNINGS

select * from EC_EMPLOYEE_AUDIT

where EMPLOYEE_ID = 'xxxxx'

and AUDIT_DATE >= '2023-06-01'

**Ensure there are no records with AUDIT_TYPE = D (Deleted) or anything else unusual under the relevant AUDIT query

select ROE_STATUS, ROE_BATCH_NO, * from EC_GROUP_ROE

where ROE_STATUS = '0'

**Ensure there are no old unprocessed ROE records

Note: ROE Status = 0 indicates the record has not been processed yet. Group ROE is for Status = 0, once processed it will turn to Status = 1. 

select * from EC_EMPLOYEE_ROE

where ROE_STATUS = '1'

**Ensure that you see the appropriate number of records you expect when running this query

Note: Any error could be coming from another record that the system is including in the ROE that you may not be aware of.