Sage 50 payroll transactions
You should use it to check all header and detail line values before you post the journal, especially the Site and Account Codes that have been transcribed from Sage 50 Payroll values.
When you have reviewed the transaction you can:
- Post it as an automatic journal
- Delete it, correct the transcription tables and import it again.
Splitting large files
Sage X3 can only accept transactions with a maximum of 9,999 lines. If the Sage 50 XML X3 Import Conversion Tool processes a file with more than 5,000 lines it will split the output into two, or more, XML files to be transcribed into separate Sage X3 transactions. The files produced will have a '-n' suffix so, for example a Sage 50 Payroll file with 3,000 lines would result in a single file with a file identifier such as 20140701151617, whereas a Sage 50 Payroll file with 9,000 lines would result in two files with identifiers such as 20140701151617-1 and 20140701151617-2.Because these import transactions have been created from the same Sage 50 Payroll file, you should post all the journals, created from related transaction files, at the same time.

Prerequisites
Refer to documentation Implementation
Screen management
There are two selection lists in the list panel; one includes only unposted transactions and the other includes all imported payroll transactions.
Header
The header displays details of the imported file and the transaction created from it, the fields are read-only and cannot be amended.
Company name (field CPYNAM) |
Identifier (field RECID) |
Your reference (field REF) |
Internal reference (field INTREF) |
Detailed (field FLGDET) |
Validated (field FLGVAL) |
Site (field TMPFCY) |
Tab Summary
The summary tab displays details of the imported file and the transaction created from it. All fields with values from Sage 50 Payroll are read-only.
Company (field CPY) |
Site (field FCY) |
Employee (field BPRMURANO) |
Posted (field STA) |
Entry type (field GTE) |
Journal (field NUM) |
Accounting date (field ACCDAT) |
Report date (field RPODAT) |
Report time (field RPOTIM) |
Total (field TOT) |
Currency (field CUR) |
Lot (field LOT) |
Number (field NUMMURANO) |
Import file (field IMPFIL) |
Source file name (field SRCFIL) |
Tab Detail
The detail tab displays all the detail lines from the imported file. Values contained in the imported file cannot be amended, but those created during the import can be corrected if required.
Narrative (field NARRATIVE) |
Source account (field TMPACC1) |
field ACC1 |
field ACC2 |
field ACC3 |
field ACC4 |
field ACC5 |
field ACC6 |
field ACC7 |
field ACC8 |
field ACC9 |
field ACC10 |
Debit (field DEB) |
Credit (field CDT) |
Distribution (field DSP) |
field CCE1 |
field CCE2 |
field CCE3 |
field CCE4 |
field CCE5 |
field CCE6 |
field CCE7 |
field CCE8 |
field CCE9 |
field CCE10 |
field CCE11 |
field CCE12 |
field CCE13 |
field CCE14 |
field CCE15 |
field CCE16 |
field CCE17 |
field CCE18 |
field CCE19 |
field CCE20 |
Source line (field SRC_LINE) |
Code (field ACC_CODE) |
Cost Centre (field COSTCENTRE) |
Department (field DEPT) |
Employee (field EMPLOYEE) |
Totals
Imported credits (field CRTOT) |
field CRCUR |
Imported debits (field DBTOT) |
field DBCUR |
Source value (field SRCTOT) |
field TOTCUR |
Reports
By default, the following reports are associated with this function :
S-MURANA : Spanish payroll analysis
This can be changed using a different setup.
Specific buttons
Delete |
Use the Delete action to remove the transaction without posting it. This will, for example, let you add or correct transcription values using the Sage 50 import transcribe function and then import the XML file again. |
Validation |
Menu Bar
If the journal has been posted you will be able to use the Zoom > Journal action to display the journal created. |
You can use the Zoom > Transcribe action to launch the Sage 50 import transcribe function where you can add or correct transcription values and return here, to the Sage 50 Payroll transactions function. |
Error messages
In addition to the generic error messages, the following messages can appear during the entry :
A problem was encountered, record not deletedJournal posting not permitted, transaction does not balance
- delete all the transactions created by the import;
- use the Sage 50 import transcribe function to add an offset account to the Site's configuration;
- import the XML file again.