/
How to tell a payroll check is outstanding

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










Related content

Run a Check Register report for a specific payroll
Run a Check Register report for a specific payroll
More like this
Report showing Voided checks
Report showing Voided checks
More like this
Missing payroll checks for a payroll
Missing payroll checks for a payroll
More like this
Report for cleared or uncleared payroll checks
Report for cleared or uncleared payroll checks
More like this
Need to pull a list of active employees and the last date they were paid
Need to pull a list of active employees and the last date they were paid
More like this
Report of payroll checks
Report of payroll checks
More like this