Sage 50 import transcribe

To create the transcription values click in the Type column and select from the drop down list.

The transcription to Sage X3 sites uses the record selected in the Sage 50 XML X3 Import Conversion Tool. In the tool you can choose to use:

 In the XML files produced by the Sage 50 XML X3 Import Conversion Tool this value will appear in the <KPH_TMPFCY> tag in the header of each file.

The transcription to Sage X3 account codes uses the account code created by the Sage 50 XML X3 Import Conversion Tool. The tool uses some, or all, of the Sage 50 Payroll cost centre, department or nominal codes. You can translate the same Sage 50 Payroll account code to a different Sage X3 account code for each Site.

When a detail line is imported the value in the tag is looked for in the transcribe table.

If it is found; the associated Sage X3 account code is used in the transaction's detail line.

If no transcribe record is found; the value is checked to see if it is a valid Sage X3 account code, if so; it is used in the transaction's detail line.

If no transcribe record is found and the value is not already a valid Sage X3 account code; a blank account code will be used and the failure reported to the import log, before continuing with the next detail line.

Because it is not mandatory, in Sage 50 Payroll, to enter Department, Cost Centre or Nominal codes for every possible category of payroll transaction you might want to create a transcription pair using just your separators, or 'BLANK', and a suitable suspense account.

Department, Cost Centre, Nominal code and Employee Number

The transcription of Sage 50 Payroll Department, Cost Centre, Nominal code and Employee Numbers to Sage X3 values lets you use them for analytical dimension posting.

©   Sage 1999-2023