Categories of Deductions by Pay

The Categories of Deductions by Pay report uses the Payroll Register by Pay Run topic to display a list of current deductions by employee for each deduction category.

Fields

Fields included in the report template

Field Name	Group by	Sort Order	Totals
Pay Run Name	Yes	A to Z
Legal Entity	Yes	Ascending
Employee
Deferred Comp			Column Total: Sum
Pre Tax			Column Total: Sum
Post Tax			Column Total: Sum

Custom Fields

Deferred Comp

The Deferred Comp field displays deferred comp deductions. It uses the following expression:

CASE
    WHEN PRPayRunRegister.RecordType = 'Deduction'
         AND PRPayRunRegister.RecordCategory = 'Deferred Compensation' THEN PRPayRunRegister.Amount
    ELSE 0.00
END

Pre Tax

The Pre Tax field displays pre-tax deductions. It uses the following expression:

CASE
    WHEN PRPayRunRegister.RecordType = 'Deduction'
         AND PRPayRunRegister.RecordCategory = 'Pre-Tax' THEN PRPayRunRegister.Amount
    ELSE 0.00
END

Post Tax

The Post Tax field displays post tax deductions. It uses the following expression:

CASE
    WHEN PRPayRunRegister.RecordType = 'Deduction'
         AND PRPayRunRegister.RecordCategory = 'Post-Tax' THEN PRPayRunRegister.Amount
    ELSE 0.00
END

Filters

The template includes the following filters: