The Sage 50 import transcribe function lets you create data import parameters to transcribe (translate) incoming values into Sage X3 sites and account codes.

 Refer to documentation on Sites and Account codes for more information

Instructions for use

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

Site

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:
  • Company Name - from Sage 50 Payroll;
  • Internal Reference - typed in for each pay run in Sage 50 Payroll;
  • Your Reference - typed in for each pay run in the Sage 50 XML X3 Import Conversion Tool.

 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.

Account

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.

 In the XML files produced by the Sage 50 XML X3 Import Conversion Tool this value will appear in the <KPD_TMPACC1> tag in every detail record of the file.

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.

Prerequisites

SEEREFERTTO Refer to documentation Implementation

Screen management

The function uses a table to create the transcription values.

Entry screen

Grid

field NBLIG
Type (field TYP)
Source value (field INVALUE)
Site (field FCY)
Entry type (field GTE)
Automatic journal (field GAU)
Use report date (field ACCDAT)
Default dimensions (field CDE)
Offset (field CONTRA)
Chart of accounts (field COA)
Account (field ACC)
Analytical dimension (field CCE)

Error messages

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

Record already exists on line

The record you are trying to add is already present in the table. You should check the values you have entered in the Type, Source value and Site fields and correct them if they are wrong. If they are correct you should clear the values on this row and check the values of the existing row.

Tables used

SEEREFERTTO Refer to documentation Implementation