Gross to Net Current by Check

The Gross to Net Current by Check report uses the Payroll Register by Pay Run topic to display current total gross to net amounts by check.

Fields

Fields included in the report template

Field Name	Group by	Sort Order	Totals
Pay Run Name	Yes	Ascending
Legal Entity	Yes	Ascending
Employee		Ascending
Check Order		Ascending
Check Type
Curr Gross			Column Total: Sum
Curr Deductions			Column Total: Sum
Curr Garnishments			Column Total: Sum
Curr Taxes			Column Total: Sum
Curr Net			Column Total: Sum

Custom Fields

Curr Gross

The Curr Gross field displays the current gross amount. It uses the following expression:

CASE
    WHEN PRPayRunRegister.RecordType = 'Earning'
         AND PRPayRunRegister.ImpactsNetPay = 'True' THEN PRPayRunRegister.Amount
    ELSE 0.00
END

Curr Deductions

The Curr Deductions field displays the current deduction amount. It uses the following expression:

CASE
    WHEN PRPayRunRegister.RecordType = 'Deduction'
         AND PRPayRunRegister.ImpactsNetPay = 'True' THEN PRPayRunRegister.Amount
    ELSE 0.00
END

Curr Garnishments

The Curr Garnishments field displays the current garnishments amount. It uses the following expression:

CASE
    WHEN PRPayRunRegister.RecordType = 'Garnishment'
         AND PRPayRunRegister.ImpactsNetPay = 'True' THEN PRPayRunRegister.Amount
    ELSE 0.00
END

Curr Taxes

The Curr Taxes field displays the current tax amount. It uses the following expression:

CASE WHEN PRPayRunRegister.RecordType = 'Tax' AND PRPayRunRegister.ImpactsNetPay = 'True' THEN PRPayRunRegister.Amount ELSE 0.00 END

Curr Net

The Curr Net field displays the current net amount. It uses the following expression:

CASE
    WHEN PRPayRunRegister.RecordType = 'Net' THEN PRPayRunRegister.Amount
    ELSE 0.00
END

Filters

The template includes the following filters: