How to tell a payroll check is outstanding
Description of Issue
Client only wants to report on outstanding payroll checks.
Context
All versions of Enterprise ERP
SSRS
Reporting
Payroll views
Cause
pr_checks has both posted and unposted checks.
Resolution
To get only outstanding checks you must grab the warrant number from the pr_control_file and filter on where ct_finished_y_n is N.
Additional Information