Article Pay Export to Acerta

This is for the Belgian Payroll System Acerta and the Acerta Connect file.

Below is special information for this export format. General information is available here.

The field External Payroll No is retrieved from the field External Payroll number in the JobManager Setup table.

The field Line Prefix is always KLX1 (that is fixed value KLX followed by 1 for Update Code equals Active)

The Advanced field is EMPTY for this export!

Summation

A runtime parameter indicates whether this file should sum the lines for the entire selected period, if they have the same Pay Type and Rate.

If summation, the date on the lines will be set to the first day of the selected period.

File format

• The file contains the following fields: Line Prefix, External Payroll No, Export Empl No, Date, Export Pay Type No, Qty
  • Line Prefix 4 characters (left-aligned) at position 1-4
  • External Payroll No 7 characters (left-aligned) at position 5-11
  • Export Empl No 20 (17+3) characters (left-aligned) at position 12-31
  • Date 10 characters at position 32-41
  • Export Pay Type No 6 (2+4) characters (right-aligned with leading spaces) at position 42-47
  • Qty 6 (2+4) characters (right-aligned with 2 leading spaces) at position 48-53
    
    
• Decimal fields are specified without a thousand separator, with 2 decimal places and without a decimal point. That is 12.34 would be 1234 (with a maximum of 4 digits). The number has leading 0 (zeros).
• Dates are specified as `DD/MM/YYYY'.

Sample file

External Payroll No: 99999999
Employee: 11
28/10-2024 with 8 normal hours and 4.25 overtime.
29/10-2024 with 4.75 normal hours and 3.25 absence (Loopbaan Verlof).

KLX1999999911                  28/10/2024  0100   800
KLX1999999911                  29/10/2024  0100   475
KLX1999999911                  28/10/2024  0138   425
KLX1999999911                  29/10/2024  2353   325