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