Summary

The Virtual Payslip settings allow you to control the table or field sizes to prevent the virtual payslip table from becoming too large.

These settings are used by a companies who need to display a large number of transactions on their payslips, especially taxable transactions. By default 20 taxable transactions can be displayed per employee payslip. Some clients need to display more taxable transactions, so they usually choose an upper limit of 40 taxable transactions in the virtual payslip table.

When you increase the virtual payslip transaction numbers, you also increase the time required to generate the virtual payslip table and the time that it takes to run reports using this table.

Important: Do not change the default values without advice from your PayGlobal Consultant.

Base fields

Specify the number of transactions allowed for each field grouping.

For example, if No. of Taxable Transactions = 8 and your payslip report specifies nine transactions, then the report will produce an error when it cannot find the ninth field.

Create concatenated table

When Create concatenated table = Yes, PayGlobal creates an additional virtual table that you can select in report designer. Sets of fields are grouped into a single field so the concatenated table contains fewer fields.

Concatenation character

The Concatenation character separates values in the grouped field; the default character is a semicolon (;).

Recreating reporting tables

To include the virtual payslip concatenated table in a report, Create concatenated table must be set to 'Yes'. If it is not set to 'Yes', then you need to recreate the reporting tables using the following procedure:

1. Delete the localversion.ini file in the Rept folder.
2. The next time that you edit a designer report, the tables will be recreated.

For example, the Virtual Payslip table is created with the following fields:

TaxableTrType, TaxableTrCode, TaxableTrDesc, TaxableTrText, TaxableSubQty, TaxableTrRate, TaxableTrFact, TaxableSubTtl, TaxableAwardCode, TaxableRateCode, TaxableCostCentreCode, TaxableCostCentreDesc, TaxableStartDate, TaxableEndDate.

The Virtual Payslip Concatenated table would consolidate the values for these fields into a single field for each transaction called 'TaxableConcat'.

The following example shows the results of this field:

Allowance;601;Redundancy;;500;28.657;1;14328.5;;;02.02;Wellington - Sales & Marketing;18/05/2009;;

Note: When the concatenation character (;) is repeated this indicates that there is no value for the field between the semicolons.