The Earnings and Deductions by Pay report uses the Payroll Register by Pay Run topic to display current and YTD earning and deduction amounts.
Fields
| Field Name | Group by | Sort Order | Totals |
|---|---|---|---|
| Pay Run Name | Yes | A to Z | |
| Legal Entity | Yes | Ascending | |
| Employee | A to Z | ||
| Record Code | |||
| Current Earnings | Column Total: Sum | ||
| Current Deductions | Column Total: Sum | ||
| YTD Earnings | Column Total: Sum | ||
| YTD Deductions | Column Total: Sum |
Custom Fields
Current Earnings
The Current Earnings field displays the current earnings. It uses the following expression:
CASE
WHEN PRPayRunRegister.RecordType = 'Earning' THEN PRPayRunRegister.Amount
ELSE 0.00
END
Current Deductions
The Current Deductions field displays the current deductions. It uses the following expression:
CASE
WHEN PRPayRunRegister.RecordType = 'Deduction' THEN PRPayRunRegister.Amount
ELSE 0.00
END
YTD Earnings
The YTD Earnings field displays year-to-date earnings. It uses the following expression:
CASE
WHEN PRPayRunRegister.RecordType = 'Earning' THEN PRPayRunRegister.PayRunAmountYTD
ELSE 0.00
END
YTD Deductions
The YTD Deductions field displays year-to-date deductions. It uses the following expression:
CASE
WHEN PRPayRunRegister.RecordType = 'Deduction' THEN PRPayRunRegister.PayRunAmountYTD
ELSE 0.00
END
Filters
The template includes the following filters:
.