Sage 50 payroll integration

You can use the Sage 50 payroll integration (KPY) import template to set the default data paths for your Sage 50 Payroll XML files. Select the Fields tab and in the File Generation block type in, or select, the paths to your import Data File and its Final Directory.

The Data File source is where the files to be imported will be found, it's the Target folder for the Sage 50 XML X3 Import Conversion Tool.

The Final Directory is where successfully imported XML files will be moved to when they have been processed.

It is important that you do not tick the Update allowed check box in the Header tab's Import block.

Error messages

In addition to the generic error messages, the following messages can appear during the entry :

  • Unable to transcribe
  • Payroll transaction details do not balance

Tables used

This template can be used in import and export modes. The data is updated in the following tables :

Table

Table description

COMPANY [CPY]

Company

KPYIMPDTL [KPD]

Sage 50/Murano payroll detail

KPYIMPHDR [KPH]

Sage 50/Murano payroll header