S39 - Filtered Pay Rate Number (Payroll Report Generator variable)

Syntax

S39{C/H, 1-10, R/H, A/Z, C/Y}

Description

This variable can be used to filter out pay rates that are not in use, for passing to other variables relating to pay rates, such as E22 Pay Amount (current) and H10 Pay Amount (historic). Those variables already have parameters for doing similar filtering, but using S39 offers more flexibility, and future pay-related variables can now be simpler, leaving the filtering to S39.

E22{$S39{C,1,H,Z,C},R,Y} - uses S39 to determine the first used pay rate based on hours worked this period, but then retrieves the pay amount year-to-date total for that pay rate. Note the use of the dollar sign ($) to insert a variable into the parameters of another. H10{$S39{H,1,H,Z,C},R,Y} - similar to above, except using the employee's historic values. H10{$S39{H,5,R,Z},R} - a simpler one; retrieves the pay amount for the fifth used historical pay rate, and is exactly equivalent to H10{5,R,C,Z}.

Parameters

C/H

A text parameter that can be omitted (it defaults to "C").

C

Current (the value currently in effect).

H

Historic (the value as at the time of the historic transaction). This will only be applicable if you have based a report on the 'H' variables.

1-10

A numeric parameter that can be omitted (it defaults to "1").

The payment number to retrieve.

R/H

A text parameter that can be omitted (it defaults to "R").

(Only used if you are using zero filtering, see below).

R

Filter on the current employee's pay rates.

H

Filter on the current employee's hours worked.

A/Z

A text parameter that can be omitted (it defaults to "A").

A

All amounts (regardless of the value).

Z

Non-zero amounts (only get amounts that have a value).

C/Y

A text parameter that can be omitted (it defaults to "C").

C

Current (the value for this period).

Y

Year (the value for the payroll year including this period).

Returns

A numeric value whose typical size is 2 digits.