Gross to Net Current by Pay

The Gross to Net Current by Pay report uses the Payroll Register by Pay Run topic to display current total gross to net amounts 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		A to Z
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 contains the following filters: