Export Templates

One of the uses of export templates is to define the mechanism that the period end is to use to process the nominal ledger transactions.

To create an export template, access Transfer Template in Payroll Definitions General.

To transfer data directly to the QLX General Ledger, a template of the following format is required:

Reference

This is a user defined value, by which the template is to be later referred when linking it to the Payroll run template.

Description

This is a user defined value, which should be used to make it easy to identify the template.

Type 

This must be set to Pre-Defined.

Form

This must be set to PAYH0008.

Detail

This field defines the level at which the posting is to be made. Selecting Summary will result in a single posting to each nominal account. Selecting Detail will result In multiple postings. (Note: if posting in Detail, then an individual employee’s pay details will be visible within the general ledger enquiries).

Create File

This must be blank.

Invoke

The must be blank.

Having entered the details close the screen.

 

 

To output the data to a CSV file, perhaps for a manipulation before transferring to the QLX general ledger or importing to some other package, a template of the following format is required:

Reference

This is a user defined value, by which the template is to be later referred when linking it to the Payroll run template.

Description

This is a user defined value, which should be used to make it easy to identify the template.

Type 

This must be set to Pre-Defined.

Form 

This must be set to PAYH0008.

Detail

The setting of this field is irrelevant; the file is always created at the detail level. If a summary posting is required then this can be done when the data is imported back into the ledger.

Create File

This must be the name of the file to create. The full path name will be required, e.g. c:\transfer.csv.

Invoke

This must be blank.

 

Having entered the details, close the screen.

 

 

 

Having created the required export template, it is necessary to define this template in Payroll Template.

Access the required Payroll Template and select Edit.

Select the required entry in the export template field and save the record.