Summary
I want a report that only shows my active employees. How do I exclude terminated employees from my Sage 300 CRE Payroll reports?
Description
Cause
Resolution
Add a condition to exclude employees with a termination date
- From the Reports menu, select the report.
- Click Conditions.
- If conditions already exist on the report, click Add.
- If the field list title isn't PR Employee, click Index and select PR Employee, then click OK
- Select Termination Date
- For Operator, select Equal to
- Leave Value blank
- Click OK. The condition displays as "Termination Date EQ 0."
- Click Add.
- Select OR for the connector
- If the field list title isn't PR Employee, click Index and select PR Employee, then click OK
- Select Rehire Date
- For Operator, select Greater than
- For the Value, click List Items
- If the default record isn't PR Employee, click Index and select PR Employee, then click OK
- Select Termination date
- Click OK. The second condition displays as "OR Rehire Date GE Termination Date."
- Click OK and print the report.
Note: Enter OR conditions before any AND conditions for the conditions to work properly.