Note: This report has been provided as a potential reporting solution. It has not been reviewed by Sage 300 Construction and Real Estate Quality Assurance.
Report Prompts:
1. The Report Date will print in the page heading next to the page number.
2. The report will prompt for up to 3 Pay IDs to be included on the report. The Pay IDs will default to the recommended Pay IDs outlined by Sage 300 CRE support (COVIDSICK, COVIDFMLA and COVFMLA10) but can be changed by the operator. The first Pay ID prompt is required. The remaining two Pay ID prompts can be blanked out.
3. The report prompts for a range of check dates. The dates will default with from 03-15-2020 through 12-31-2020 but can be changed by the operator.
4. A check box to Include Time Detail determines if the detail of the PR Time will display on the report. The box will default as checked to include the detail, but can be unchecked by the operator to display only the employee and report totals.
Conditions:
Only the Pay IDs entered in the prompt fields will be included on the report.
Only the checks with check dates within the range entered in the check date prompt fields will be displayed.
Fields:
The report will display the following information:
Employee ID, Employee Name, the default Pay ID stored on each employee record, and the current rate stored on the PR Employee Pay record associated with each employee's default Pay ID.
The Time includes:
Period End Date, Check Sequence, Check Date, Date(from each time record if populated) Pay ID, Units, Rate, Amount.
Special Considerations: Employee and report totals for each of the specified pay ids will print in the last three columns on this report.
The report processes from the PR time records and sorts in Employee, Period End Date, Check Sequence, Pay ID order.