Warning: This report is provided as a possible solution to your issue. It was not reviewed by Quality Assurance. You may need to modify it to meet your reporting needs or adapt it for use with future releases of the software.

The formula which is on the Hrly Fringe column is not retrieving the rate off of the Certified pay rate table for fringes. If this is what you want to prefill into the Hrly Fringe column, your formula should be the following:

LOOKUP(Fringe Rate(PR Pay Rate Table), "CERTIFIED", JOIN(Job(PR Time), "C", Certified Class(PR Time)))

The above formula will work if your Pay Rate Table is named CERTIFIED, and the Job, Certified and Certified Class columns are checked.

Note: The modified report assumes that the pay rate table used for certified time has the ID of Certified and that only the columns Job, Certified? and Certified Class are selected. If you have any other combination of columns, you must modify the report. Certified time must exist for this report to calculate correctly.

 

The check must include an automatic cash fringe pay.

The purpose of the PR Certified report (Reports , Other , Certified Report) and the DOL WH-347 report (Tasks , Federal eFile and Reporting) is to show that the employer meets the minimum amount of pay and fringes as stipulated by the government. The basis of this determination is the certified pay rate table's pay rate and fringe rate. Per Department of Labor instructions, Employees must have a cash fringe type pay on their check for the certified report to print with an hourly fringe for that employee. Cash fringes are part of the certified payroll set up and you cannot add them manually, as this calculates when you process checks.

The attached modification of the PR Certified report prints an hourly fringe column even when cash fringes do not calculate. This report prints only the required amount of compensation, even when an employee's pay and certified fringes exceed the required amount on the certified table. No excess prints as the purpose of this report is to verify that the minimum requirements are met. This is the case with or without the calculation of cash fringe.