TRANXACT.AI Help
HRMS › Pay Setup

Pay Formulas

An earning or deduction code worked out by a formula over the pay variables (hours, rate, base_pay, gross, years_of_service ...). Test it, activate it from a date, and change it only by adding a new version: payslips already paid keep the version they used. Set the code's "Worked out as" to Formula to use it.

Where to find it

  1. Module: HRMS
  2. Group: Payroll
  3. Section: Pay Setup
  4. Screen: Pay Formulas

Address in the console: /hrms/pay-formulas

List · 9 columns · 6 fields on its form · 3 of them required · 5 actions

What the list shows

These are the columns of the list, in the order they are drawn. Any of them can be sorted on, filtered on, hidden, or exported.

ColumnKindField name
ForStatuselement_kind
CodeCodecode
Code nameTextcode_name
VersionNumberversion
FormulaCodeformula
FromDateeffective_from
ToDateeffective_to
StateStatusstate
TestedYes or notested_ok

The form

What is asked for when a record is created here. Required fields are marked; a choice drawn from a configuration list is one an administrator can extend without a release.

FieldTypeChoicesNotes
For required Choice An earning code, A deduction code
Code required Text The earning or deduction code this formula works out.
Formula required Long text e.g. round(base_pay / periods_per_year * 0.05, 2), or if(years_of_service >= 5, 150, 100).
Effective from Date
Effective to Date
What it does Long text

What you can do here

Try a formula

On the toolbar, above the list.

Try a formula

Asks for: For* Formula* Employee (optional) Hours Rate Gross so far

Test primary

On each row of the list.

Asks for: Employee (optional) Hours Rate Gross so far

Activate

On each row of the list. Offered only on records where it applies.

Asks for: In force from

New version

On each row of the list. Offered only on records where it applies.

Asks for: Starting

Retire

On each row of the list. Offered only on records where it applies.

Asks for confirmation: End this version? Payslips already paid keep it.

* required

The rules that apply here

Everything on this screen obeys the platform rules rather than rules of its own. The ones worth knowing before you use it:

Beside it in Pay Setup