Import/export template > Module Financials > Import/export template KPS (Sage 50 Payroll transcriptions)
 |
 |
Sage 50 transcribe import
If you have a large number of account codes, departments, cost centres or employee codes to transcribe from Sage 50 Payroll values you may find it easier to create the information in a spreadsheet and import it into Sage X3.
Prerequisites
You should use the Sage 50 import transcribe function to create a Site type record and an Account type record.
You will use these records to generate a Microsoft® Excel® workbook to use as a template. See the documentation on Sage 50 import transcribe for more information.
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] |
|
|
GACM [GCM] |
|
|
GLED [LED] |
|
|
KPYIMPTRAN [KPT] |
Sage 50 import transcribe |