Categories of Earnings by Pay

The Categories of Earnings by Pay report uses the Payroll Register by Pay Run topic to display current earnings categories by employee.

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
Normal Earnings			Column Total: Sum
Taxable Benefits			Column Total: Sum
Reimbursements			Column Total: Sum
Memos			Column Total: Sum

Custom Fields

Normal Earnings

The Normal Earnings field displays the current normal earnings. It uses the following expression:

CASE
    WHEN PRPayRunRegister.RecordType = 'Earning'
         AND PRPayRunRegister.RecordCategory = 'Normal' THEN PRPayRunRegister.Amount
    ELSE 0.00
END

Taxable Benefits

The Taxable Benefits field displays the current taxable benefits. It uses the following expression:

CASE
    WHEN PRPayRunRegister.RecordType = 'Earning'
         AND PRPayRunRegister.RecordCategory = 'Taxable Benefit' THEN PRPayRunRegister.Amount
    ELSE 0.00
END

Reimbursements

The Reimbursements field displays the current reimbursement earnings. It uses the following expression:

CASE
    WHEN PRPayRunRegister.RecordType = 'Earning'
         AND PRPayRunRegister.RecordCategory = 'Reimbursement' THEN PRPayRunRegister.Amount
    ELSE 0.00
END

Memos

The Memos field displays the current memo earnings. It uses the following expression:

CASE
    WHEN PRPayRunRegister.RecordType = 'Earning'
         AND PRPayRunRegister.RecordCategory = 'Memo Calc' THEN PRPayRunRegister.Amount
    ELSE 0.00
END

Filters

The template includes the following filters: