Article Pay Export to Acerta

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

This export consists of 2 files, which are created separately:

• Payroll (and Absence)
• Addon

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

The Advanced field is EMPTY for these exports!

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

Payroll (and Absence) file

This file includes lines where External Type equals Pay and Absence.

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

Addon file

This file includes lines where External Type equals Addon.

The field Line Prefix is always LOMD (that is fixed value LOM followed by D (equals origineel: gegeven wordt toegevoegd bij al dan niet aanwezige lijnen in de afwijkende lonen).

The fields Afwerkingsdatum, Kostenplaats and Uitbetalingspercentage is always empty.

Only one of the fields Days or Qty is used for each row. The Days field is used if External Unit equals Days, otherwise the Qty field is used.

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 Payroll 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
    
    
• The Addon file contains the following fields: Line Prefix, External Payroll No, Export Empl No, Date, Afwerkingsdatum, Kostenplaats, Export Pay Type No, Days, Qty, Rate, Uitbetalingspercentage, Amount
  • 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
  • Afwerkingsdatum 10 characters at position 42-51
  • Kostenplaats 12 characters at position 22-63
  • Export Pay Type No 6 (2+4) characters (right-aligned with leading spaces) at position 64-69
  • Days 8 (2+6) characters (right-aligned with 2 leading spaces) at position 70-77
  • Qty 8 (2+6) characters (right-aligned with 2 leading spaces) at position 78-85
  • Rate 15 (2+13) characters (right-aligned with 2 leading spaces) at position 86-100
  • Uitbetalingspercentage 5 characters at position 101-105
  • Amout 11 (2+13) characters (right-aligned with 2 leading spaces) at position 106-116
    
    
• Decimal fields are specified without a thousand separator, with 2 decimal places (exept 5 for Rate field) 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 (Payroll)

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