Earnings and Deductions by Range

The Earnings and Deductions by Range report uses the Payroll Register by Date Range topic to display employees’ YTD and date range totals for selected earning and deduction codes.

Fields

Fields included in the report template

Field Name	Group by	Sort Order	Totals
Pay Group	Yes	Ascending
Legal Entity	Yes	Ascending
Employee		A to Z
Record Code
Date Range Earnings
Date Range Deductions
YTD Earnings			Column Total: Sum
YTD Deductions			Column Total: Sum

Custom Fields

Date Range Earnings

The Date Range Earnings field displays the earnings amounts for the selected date range. It uses the following expression:

CASE
    WHEN PRPayRunRegisterPeriod.RecordType = 'Earning' THEN PRPayRunRegisterPeriod.Amount
    ELSE 0.00
END

Date Range Deductions

The Current Deductions field displays the deduction amounts for the selected date range. It uses the following expression:

CASE
    WHEN PRPayRunRegisterPeriod.RecordType = 'Deduction' THEN PRPayRunRegisterPeriod.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: