GL Interface Options

The selected conversion generates a General Ledger posting transaction in the relevant format for every posting transaction held in the Closed Period FileGL9000. The generated posting transactions are then added to the corresponding file to be processed.

The converted Closed Period File transactions are added to the corresponding file. That is, any positing transactions already existing in the corresponding file remains intact.

A General Ledger Account Error Report is produced at the completion of the conversion. It lists all account numbers that do not comply with the selected format, along with an error number. A list of error numbers and their descriptions is provided at the end of the report.

Before running the conversion, ensure that:

  • The name of the library containing the corresponding file is specified as the Interface File Library in the selected General Ledger Parameter window, in the disbursement File function, and is included in your Library List, either as part of your Preceda environment or added temporarily for the purposes of running this function.
  • The Close Open Period File function has completed successfully.
  • You have Generated Accruals, if required.
  • You have run the Print the Closed Period Report, if required.

 

Available formats

The generated posting transactions are added to the GLTL file and processed through ABSOLUTIONS.

Field Information

Enter the month number of the current ABSOLUTIONS period.

Enter the financial year of the current ABSOLUTIONS period using CCYY format.

When the conversion process is complete, the GLTL file is ready for processing through ABSOLUTIONS.

 

The generated posting transactions are added to the OUTFILE file to be processed through ACOM.

Field Information 

Enter the month number of the current ACOM period.

Enter the year number of the current ACOM period.

When the conversion process is complete, the OUTFILE files are ready for processing through ACOM.

 

The generated posting transactions are added to the SROIBT files to be processed through ASW.

Field Information 

This field is activated only if the Create Export File field is set to Y.

  • The name of the export file to be created.

Enter the month number of the current ASW period.

Enter the year number of the current ASW period.

When the conversion process is complete, the SROIBT file is ready for processing through ASW.

Also, a report (NSA130) is produced when the interface is run. This report shows the Accounting Period Date and the totals of Debits and Credits included in the interface.

 

The generated posting transactions are added to the GJW file to be processed through BPCS.

Field Information 

Enter the month number of the current BPCS period.

Enter the year number of the current BPCS period.

Use these fields to identify the Debit Profit Center by selecting either a valid Preceda Level Number in the LVL field, or entering a valid BPCS Profit Center account number in the Constant field.

2 Level 2
3 Level 3
4 Level 4
5 Level 5
A Account Number
D Department

 

Use these fields to identify the Credit Profit Center by selecting either a valid Preceda Level Number in the LVL field, or entering a valid BPCS Profit Center account number in the Constant field.

2 Level 2
3 Level 3
4 Level 4
5 Level 5
A Account Number
D Department

 

When the conversion process is complete, the GJW file is ready for processing through BPCS.

This section is relevant only if your Profit Center codes form the first portion of your General Ledger accounts. In this case, you can specify the number of characters at the beginning of the General Ledger account numbers that identify the relevant Profit Center.

The generated posting transactions are added to the GJW file to be processed through BPCS.

Field Information

Enter the month number of the current BPCS period.

Enter the year number of the current BPCS period.

Enter the number of characters at the beginning of the generated General Ledger account numbers that identify the relevant Profit Center. This enables the conversion process to automatically separate the generated General Ledger accounts into a Profit Centre and General Ledger account. When the conversion process is complete, the GJW file is ready for processing through BPCS.

 

This section is relevant only if your Profit Center codes form the first portion of your General Ledger accounts and you want to specify the character (delimiter) that separates the Profit Centre from the rest of the account number. In this case, you can specify the number of characters at the beginning of the General Ledger account numbers that identify the relevant Profit Center and the actual character that separates the Profit Center from the rest of the account number, such as a dash or bracket.

The generated posting transactions are added to the GJW file to be processed through BPCS.

Field Information

Enter the month number of the current BPCS period.

Enter the year number of the current BPCS period.

Enter the character that separates the Profit Center from the rest of the account number. It can be any special character such as a dash, bracket, slash, and so on.

When the conversion process is complete, the GJW file is ready for processing through BPCS.

 

This section is relevant only if you want to specify the Profit Centers to be used.

The generated posting transactions are added to the GJW file to be processed through BPCS.

Field Information

Enter the month number of the current BPCS period.

Enter the year number of the current BPCS period.

Use these fields to identify the Debit Profit Center by selecting either a valid Preceda Level Number in the LVL field, or entering a valid BPCS Profit Center account number in the Constant field.

2 Level 2
3 Level 3
4 Level 4
5 Level 5
A Account Number
D Department

Use these fields to identify the Credit Profit Center by selecting either a valid Preceda Level Number in the LVL field, or entering a valid BPCS Profit Center account number in the Constant field.

2 Level 2
3 Level 3
4 Level 4
5 Level 5
A Account Number
D Department

 

When the conversion process is complete, the GJW file is ready for processing through BPCS.

 

The generated posting transactions are added to the GJW file to be processed through BPCS.

Field Information 

Enter the month number of the current BPCS period.

Enter the year number of the current BPCS period.

Enter the number of characters at the beginning of the generated General Ledger account numbers that identify the relevant Profit Center. This enables the conversion process to automatically separate the generated General Ledger accounts into a Profit Centre and General Ledger account.

When the conversion process is complete, the GJW file is ready for processing through BPCS.

 

This section is relevant only if your Profit Center codes form the first portion of your General Ledger accounts and you want to specify the character (delimiter) that separates the Profit Centre from the rest of the account number. In this case, you can specify the number of characters at the beginning of the General Ledger account numbers that identify the relevant Profit Center and the actual character that separates the Profit Center from the rest of the account number, such as a dash or bracket.

The generated posting transactions are added to the GJW file to be processed through BPCS.

Field Information 

Enter the month number of the current BPCS period.

Enter the year number of the current BPCS period.

Enter the character that separates the Profit Center from the rest of the account number. It can be any special character such as a dash, bracket, slash etc.

When the conversion process is complete, the GJW file is ready for processing through BPCS.

 

This is for General Ledger accounts. In this case, you can specify the number of characters at the beginning of the General Ledger account numbers that identify the relevant Company and Profit Center.

The generated posting transactions are added to the GJW file to be processed through BPCS.

Field Information 

Enter the month number of the current BPCS period.

Enter the year number of the current BPCS period.

Enter the number of characters at the beginning of the generated General Ledger account numbers that identify the relevant Company. This enables the conversion process to automatically separate the generated General Ledger accounts into Company, Profit Centre and General Ledger account.

Enter the number of characters at the beginning of the generated General Ledger account numbers that identify the relevant Profit Center. This enables the conversion process to automatically separate the generated General Ledger accounts into Company, Profit Centre and General Ledger account.

When the conversion process is complete, the GJW file is ready for processing through BPCS.

 

This section is relevant only if your Company and Profit Center codes form the first portion of your General Ledger accounts and if you process inter-company records. In this case, you can specify the number of characters at the beginning of the General Ledger account numbers that identify the relevant Company and Profit Center.

The generated posting transactions are added to the GJW file to be processed through BPCS.

Field Information 

Enter the month number of the current BPCS period.

Enter the year number of the current BPCS period.

Enter the number of characters at the beginning of the generated General Ledger account numbers that identify the relevant Company. This enables the conversion process to automatically separate the generated General Ledger accounts into Company, Profit Centre and General Ledger account.

Enter the number of characters at the beginning of the generated General Ledger account numbers that identify the relevant Profit Center. This enables the conversion process to automatically separate the generated General Ledger accounts into Company, Profit Centre and General Ledger account.

When the conversion process is complete, the GJW file is ready for processing through BPCS.

 

This section is relevant only if your Profit Center codes form the first portion of your General Ledger accounts. In this case, you can specify the number of characters at the beginning of the General Ledger account numbers that identify the relevant Profit Center.

The generated posting transactions are added to the GJW file to be processed through BPCS.

Field Information 

Enter the month number of the current BPCS period.

Enter the year number of the current BPCS period.

Enter the number of characters at the beginning of the generated General Ledger account numbers that identify the relevant Profit Center. This enables the conversion process to automatically separate the generated General Ledger accounts into a Profit Centre and General Ledger account.

When the conversion process is complete, the GJW file is ready for processing through BPCS.

 

This section is relevant only if your Profit Center codes form the first portion of your General Ledger accounts and you want to specify the character (delimiter) that separates the Profit Centre from the rest of the account number. In this case, you can identify the character that separates the Profit Center from the rest of the account number, such as a dash or bracket.

The generated posting transactions are added to the GJW file to be processed through BPCS.

Field Information 

Enter the month number of the current BPCS period.

Enter the year number of the current BPCS period.

Enter the character that separates the Profit Center from the rest of the account number. It can be any special character such as a dash, bracket, slash etc.

When the conversion process is complete, the GJW file is ready for processing through BPCS.

 

This section is relevant only if your Company and Profit Center codes form the first portion of your General Ledger accounts. In this case, you can specify the number of characters at the beginning of the General Ledger account numbers that identify the relevant Company and Profit Center.

The generated posting transactions are added to the GJW file to be processed through BPCS.

Field Information 

Enter the month number of the BPCS period.

Enter the year number of the current BPCS period.

Enter the number of characters at the beginning of the generated General Ledger account numbers that identify the relevant Company. This enables the conversion process to automatically separate the generated General Ledger accounts into Company, Profit Centre and General Ledger account.

Enter the number of characters at the beginning of the generated General Ledger account numbers that identify the relevant Profit Center. This enables the conversion process to automatically separate the generated General Ledger accounts into Company, Profit Centre and General Ledger account.

When the conversion process is complete, the GJW file is ready for processing through BPCS.

 

The generated posting transactions are added to the GBH & GBL files to be processed through BPCS.

Field Information 

Enter the month number of the current BPCS period.

Enter the year number of the current BPCS period.

Enter the character that is the Payroll Identifier for the current BPCS period for the sub system sequence.

When the conversion process is complete, the GBH & GBL files are ready for processing through BPCS.

 

This section is relevant only if your Profit Center codes form the first portion of your General Ledger accounts. You can specify the number of characters at the beginning of the General Ledger account numbers that identify the relevant Profit Center.

The generated posting transactions are added to the GJW file to be processed through BPCS.

Field Information 

Enter the month number of the current BPCS period.

Enter the year number of the current BPCS period.

Enter the number of characters at the beginning of the generated General Ledger account numbers that identify the relevant Profit Center. This enables the conversion process to automatically separate the generated General Ledger accounts into a Profit Centre and General Ledger account.

When the conversion process is complete, the GJW file is ready for processing through BPCS.

 

The generated posting transactions are added to the GBH & GBL files to be processed through BPCS

Field Information 

Enter the month number of the current BPCS period.

Enter the year number of the current BPCS period.

Enter the character that is the Payroll identifier for the current BPCS period for the sub system sequence.

When the conversion process is complete, the GBH & GBL files are ready for processing through BPCS.

 

This section is relevant only if your Company and Profit Center codes form the first portion of your General Ledger accounts. In this case, you can specify the number of characters at the beginning of the General Ledger account numbers that identify the relevant Company and Profit Center.

The generated posting transactions are added to the GJW file to be processed through BPCS.

Field Information 

Enter the month number of the current BPCS period.

Enter the year number of the current BPCS period.

Enter the number of characters at the beginning of the generated General Ledger account numbers that identify the relevant Company. This enables the conversion process to automatically separate the generated General Ledger accounts into Company, Profit Centre and General Ledger account.

Enter the number of characters at the beginning of the generated General Ledger account numbers that identify the relevant Profit Center. This enables the conversion process to automatically separate the generated General Ledger accounts into Company, Profit Centre and General Ledger account.

When the conversion process is complete, the GJW file is ready for processing through BPCS.

 

The generated posting transactions are added to the JGL250 file to be processed through CA/ Masterpiece.

Field Information 

Enter the month number of the current CA/Masterpiece period.

Enter the name of the interface file to contain the general ledger posting transactions. The Default is the JGL250 file.

Specify the name of the library containing the interface file and ensure it is in your library list before continuing (see Note).

If you have already established the Product disbursement record for CA/Masterpiece in the General Ledger Parameter Tables, and added the interface file library to your library list, you should not need to change the defaults.

When the conversion is finished, the JGL250 file is ready to be imported into the CA/Masterpiece General Ledger.

 

The generated posting transactions are added to the SEQID & SEQIT files to be processed through CA/Masterpiece.

Field Information 

Enter the fiscal year number of the current CA/Masterpiece period.

Enter the number of the current CA/Masterpiece fiscal period. Organisation Code Enter the organisation code for the current CA/Masterpiece processing.

Enter the journal date of the last day of the current CA/Masterpiece period.

When the conversion is finished the SEQID & SEQIT files are ready to be imported into the CA/ Masterpiece General Ledger.

 

The generated posting transactions are added to the JEID & JEIT files to be processed through CA/Masterpiece.

Field Information 

Enter the batch identifier for the current CA/Masterpiece period.

Enter the year number of the current CA/Masterpiece period.

Enter the number of the current CA/Masterpiece fiscal period.

The options are Y or N. If left blank it will default to N.

The date for the journal. The format is DD/MM/YY.

When the conversion is finished the JEID & JEIT files are ready to be imported into the CA/ Masterpiece General Ledger.

 

The generated posting transactions are added to the ACLOGTMP file to be processed through CGAS.

There is no field information to enter.

When the conversion process is complete, the ACLOGTMP file is ready for processing through CGAS.

 

The generated posting transactions are added to the ACCINT file to be processed through CGAS.

Field Information 

Enter the period number of the current CGAS period.

Enter the financial year number of the current CGAS period.

Enter the currency code to be used by CGAS.

When the conversion process is complete, the ACCINT file is ready for processing through CGAS.

 

The generated posting transactions are added to the GLIMPORT file to be processed through CODA G/L.

Field Information 

Enter the year number of the current CODA G/L period.

Enter the accounting period of the current CODA G/L fiscal period.

Enter the description for the current CODA G/L. When the conversion is finished, the GLIMPORT file is ready to be imported into the CODA G/L General Ledger.

 

The generated posting transactions are added to the GLT200 file to be processed through COMOPS.

Field Information 

The Dummy Account is an arbitrary account number used for balancing detail records, as required for COMOPS.

When the conversion process is complete, the GLT200 file is ready for processing through COMOPS.

 

The generated posting transactions are added to the GJVD031N file to be processed through Computron.

Field Information

Enter 6 digits representing the year, in CCYY format, and the posting period these transactions relate to (e.g. 12).

Enter a three-character code.

Enter a six-character code to be used as a reference for this batch of transactions. When the conversion process is complete, the GJDV031N file is ready for processing through Computron Version 5.

 

The generated posting transactions are added to the JJR01801 file to be processed through Finance One.

Field Information 

Enter the month number of the current Finance One period.

Enter the year of the current Finance One period.

Enter the date of the GL period.

Enter the General Ledger number for the posting.

When the conversion process is complete, the JJR01801 file is ready for processing through Finance One.

 

The generated posting transactions are added to the GLPIT file to be processed through IMAS/400.

There is no field information to enter.

When the conversion process is complete, the GLPIT file is ready for processing through IMAS/400.

 

The generated posting transactions are added to the GLPIT file to be processed through IMAS.

There is no field information to enter.

When the conversion process is complete, the GLPIT file is ready for processing through IMAS.

 

A header record is also generated for this format.

The generated posting transactions are added to the GLPIT file to be processed through IMAS/400 R5.1.

Field Information 

Type the batch number for the current IMAS/400 R5.1 period.

When the conversion process is complete, the GLPIT file is ready for processing through IMAS/400 R5.1.

 

The generated posting transactions are then added to the GLTRN file to be processed through INFOGL.

Field Information 

Enter the posting month number of the current INFOGL period.

Enter the posting year number of the current INFOGL period.

 

The generated posting transactions are added to the GLTRNV10 file to be processed through INFOGL.

Field Information 

Enter the posting month number of the current INFOGL V10 period.

Enter the posting year number of the current INFOGL V10 period.

 

The generated posting transactions are added to the GLTRN file to be processed through INFOGL.

Field Information 

Enter the month number of the current INFOGL - PAXUS period.

Enter the year number of the current INFOGL - PAXUS period.

 

The generated posting transactions are added to the PAYROL file to be processed through INSIGHT.

Field Information 

Enter the date of the current INSIGHT period.

Enter the period number of the current INSIGHT period.

 

The generated posting transactions are added to the F0911Z1 file to be processed through JD Edwards.

Field Information

Enter the month number of the current JD Edwards period.

Enter the year number of the current JD Edwards period.

 

The generated posting transactions are added to the F0911Z1 file to be processed through J D Edwards.

Field Information

Enter the month number of the current J D Edwards period.

Enter the year of the current J D Edwards period.

 

The generated posting transactions are added to the F0911Z1 file to be processed through J D Edwards.

Field Information

Enter the month number of the current JD Edwards period.

Enter the year number of the current JD Edwards period.

 

The generated posting transactions are added to the F0911Z1 file to be processed through J D Edwards.

Field Information

Enter the month number of the current JD Edwards period.

Enter the year number of the current JD Edwards period.

 

The generated posting transactions are added to the F0911Z1 file to be processed through J D Edwards.

Field Information

Enter the month number of the current JD Edwards period.

Enter the year number of the current JD Edwards period.

 

The generated posting transactions are added to the F0911Z1 file to be processed through J D Edwards.

Field Information

Enter the month number of the current JD Edwards period.

Enter the year number of the current JD Edwards period.

 

The generated posting transactions are added to the F0911Z1 file to be processed through J D Edwards.

Field Information

Enter the month number of the current JD Edwards period.

Enter the year number of the current JD Edwards period.

 

The generated posting transactions are added to the GLMAC381 file to be processed through MAC/38.

There is no field information to enter.

When the conversion process is complete, the GLMAC381 file is ready for processing through MAC/ 38.

 

The generated posting transactions are added to the GLMAC384 file to be processed through MAC 38.

Field Information

Enter the month number of the current MAC 38 period.

Enter the year number of the current MAC 38 period.

 

The generated posting transactions are added to the GLIJNLEN file to be processed through M & D.

Field Information

Enter the Level 1 Code for the Company Code that has been used to pay your employees.

Enter the appropriate period month number.

Enter the appropriate code for the payroll.

Enter the appropriate Journal Entry.

Enter your Corporation Code.

This is the Detailed Description.

This is for the Trailer Source.

This is for the Trailer Description.

 

The generated posting transactions are added to the GELWRK file to be processed through MAPICS.

Field Information

Enter the date of the current MAPICS period. When the conversion process is complete, the GELWRK file is ready for processing through MAPICS.

 

The generated posting transactions are added to the GLTRAN file to be processed through MAPICS.

Field Information

Enter the posting date of the current MAPICS period.

Enter the record code for the MAPICS processing.

Enter the company for the MAPICS processing.

When the conversion process is complete, the GLTRAN file is ready for processing through MAPICS.

 

The generated posting transactions are added to the MK001 file to be processed through MK.

Field Information

Enter a three-character account number.

When the conversion process is complete, the MK001 file is ready for processing through MK.

 

The generated posting transactions are added to the FCR040 file to be processed through MOVEX.

Field Information

Enter the year number of the starting fiscal MOVEX period.

Enter the month number of the current MOVEX period.

Enter the text to be added to the MOVEX voucher text details.

Enter the character which separates the GL account number into its MOVEX components.

When the conversion process is complete, the FCR040 file is ready for processing through MOVEX.

 

The generated posting transactions are added to the FCR040 file to be processed through MOVEX.

Field Information

Enter the year number of the starting fiscal MOVEX period.

Enter the accounting month number of the current MOVEX period (i.e. 01 = July).

Enter the company for the current MOVEX period.

Enter the division for the current MOVEX period.

Enter the FAM function for the interface.

Enter the relevant voucher series number.

Enter the relevant voucher number.

Do you wish to use Debit and Credit Codes? Enter Y or N.

If Y is entered, you may enter the relevant Debit Code or Credit Code; otherwise leave the Debit and Credit fields blank.

Enter the relevant Debit Code.

Enter the relevant Credit Code.

Enter the start and end positions of the Company within the GL Account Number field. If entered, the Company is set using the positions of the GL account number entered.

If left blank, the details entered in the Company field above is used. A maximum of 3 digits can be defined.

Enter the start and end positions of the Division within the GL Account Number field. If entered, the Division is set using the positions of the GL account number entered.

If left blank, the details entered in the Division field above is used. A maximum of 3 alphanumeric digits can be defined.

Enter the start and end positions of the Acc Dimension 1 within the GL Account Number field. If entered, the Acc Dimension 1 is set using the positions of the GL account number entered. If left blank, the details entered in the BACCT (Account) field from the GL9000 file is used. A maximum of 8 alphanumeric digits can be defined.

Enter the start and end positions of the Acc Dimension 2 within the GL Account Number field. If entered, the Acc Dimension 2 is set using the positions of the GL account number entered. If left blank, the details entered in the BDEPT (Dept.) field from the GL9000 file is used. A maximum of 8 alphanumeric digits can be defined.

When the conversion process is complete, the FCR040 file is ready for processing through MOVEX.

 

The generated posting transactions are added to the FCR040 file to be processed through MOVEX.

Field Information

Enter the year number of the starting fiscal MOVEX period.

Enter the accounting month number of the current MOVEX period (i.e. 01 = July).

Enter the company for the current MOVEX period.

Enter the division for the current MOVEX period.

Enter the relevant voucher series number.

Enter the relevant voucher number.

Do you wish the Voucher Number written to the G/L interface file to be incremented by 1 each time the batch number changes?

Y Increment Voucher Number
N (or Blank) Do not increment Voucher Number
  • Note that if this window is set to Y, the Voucher Number is incremented before the record is saved to the FCR040 interface file.

 

Do you wish to use Debit and Credit Codes?

If Y, for yes, is entered you may enter the relevant Debit Code or Credit Code; otherwise leave the debit and credit code fields blank.

Enter the Debit code.

Enter the Credit code.

Enter the start position of the Acc Dimensions 1...7 within the GL Account Number field. If entered, the Acc Dimensions 1...7 is set using the positions of the GL account number entered. If left blank, the details in the BACCT (Account) field from the GL9000 file is used.

Enter the end position of the Acc Dimensions 1...7 within the GL Account Number field. If entered, the Acc Dimensions 1...7 is set using the positions of the GL account number entered. If left blank, the details in the BACCT (Account) field from the GL9000 file is used.

Enter the start position of the Error Accounts 1...3 within the GL Account Number field. If entered, the Error Account 1...3 is set using the positions of the GL account number entered. If left blank, the details in the BACCT (Account) field from the GL9000 file is used.

Enter the end position of the Error Accounts 1...7 within the GL Account Number field. If entered, the Error Accounts 1...7 is set using the positions of the GL account number entered. If left blank, the details in the BACCT (Account) field from the GL9000 file is used.

When the conversion process is complete, the FCR040 file is ready for processing through MOVEX.

 

The generated posting transactions are added to the PAYROLLEFT file to be processed through MOVEX.

Field Information

Enter the division for the current MOVEX period.

Enter the start position of the Acc Dimensions 1...7 within the GL Account Number field. If entered, the Acc Dimensions 1...7 is set using the positions of the GL account number entered. If left blank, the details in the BACCT (Account) field from the GL9000 file is used.

Enter the end position of the Acc Dimensions 1...7 within the GL Account Number field. If entered, the Acc Dimensions 1...7 is set using the positions of the GL account number entered. If left blank, the details in the BACCT (Account) field from the GL9000 file is used.

When the conversion process is complete, the PAYROLLEFT file is ready for processing through MOVEX.

 

The generated posting transactions are added to the ORAPSTP and ORIFCTPW files to be processed through ORACLE.

Field Information

Enter the month number and year number of the current ORACLE period using the MMM-YY format. For example, JUN-07 for June 2007.

 

Each time the ORACLE conversion is run, it creates a new file called ORACLWRK within your Preceda file library. General Ledger posting transactions are then created in an ORACLE Compatible Format for every posting transaction held in the Closed Period File (GL9000) and added to the interface file. The interface file can then be transferred from the server to the PC where it can be imported into and processed through ORACLE.

Field Information

Enter the name of the ORACLE general ledger period in the MMM-YY format, including the format dash (e.g., MAR-96). Enter the period name and press Enter to continue.

When the conversion is finished, the interface file is ready to be transferred to the PC and imported into the ORACLE General Ledger.

 

The interface file can be transferred from the mainframe to the PC where it can be imported and processed through ORACLE.

Field Information

Enter the accounting date for the current ORACLE period.

When the conversion process is complete, the GL123A and GL123B files are ready for processing through ORACLE.

 

The generated posting transactions are added to the GL900X file to be processed through PAYCOST.

Field Information

Enter the date of the current PAYCOST period.

When the conversion process is complete, the GL900X file is ready for processing through PAYCOST.

 

The converted posting transactions are added to the GLICP100 file, ready to be processed through PRMS.

There is no field information to enter.

When the conversion process is complete, the GLICP100 file is ready for processing through PRMS.

 

The converted posting transactions are added to the GLIFP100 file, ready to be processed through PRMS.

There is no field information to enter.

When the conversion process is complete, the GLIFP100 file is ready for processing through PRMS.

 

The converted posting transactions are added to the GLIFP100 file, ready to be processed through PRMS.

There is no field information to enter.

When the conversion process is complete, the GLIFP100 file is ready for processing through PRMS.

 

The converted posting transactions are added to the GLICP100 file, ready to be processed through PRMS.

There is no field information to enter.

When the conversion process is complete, the GLICP100 file is ready for processing through PRMS.

 

The converted posting transactions are added to the GLIFP100 file, ready to be processed through PRMS.

There is no field information to enter.

When the conversion process is complete, the GLIFP100 file is ready for processing through PRMS.

 

The converted posting transactions are added to the GLIFP100 file, ready to be processed through PRMS.

There is no field information to enter.

When the conversion process is complete, the GLIFP100 file is ready for processing through PRMS.

 

The converted posting transactions are added to the GLIFP10092 file, ready to be processed through PRMS.

Field Information

Enter the year number of the current PRMS period using format YY.

Enter the month number of the current PRMS period.

The number of the company for which records are being processed.

When the conversion process is complete, the GLIFP100 file is ready for processing through PRMS.

 

The generated posting transactions are added to the GLSAPVR3 file to be processed through SAP.

Before running the SAP conversion, you must ensure that:

  • The Program Control Option GLI79 has been set.
  • The Prevar setting *PEOPLE_GLOPTIONS has been set to N in position 1.
  • You have set up the Interface Account Descriptions required for the interface.

Field Information

Enter the posting date for the interface. The format is DDMMYY. You may use the <F4> key in this field to activate a calendar, if required.

Select Run Process to activate the interface.

When the conversion process is complete, the GLSAPVR3 file will have been copied to the IFS, ready to be uploaded to SAP Version R 3.

  • Note that each time this process is run, it will clear the previous contents of the interface file.

 

The generated posting transactions are added to the SAP46GL file to be processed through SAP.

Field Information

You may enter the name of the file to be created.

  • Note that it must have a suffix of .txt.

When the conversion process is complete, the file is ready for processing through SAP v 4.6.

 

The SCHOLAS conversion generates a General Ledger posting transaction in SCHOLAS Compatible Format for every posting transaction held in the Closed Period File (GL9000). Two files are created by this conversion for SCHOLAS:

BTCCNTL - Header file containing the batch header record.

JNLTRAN - Details file continuing the posting transactions.

Field Information

Enter the year number of the current SCHOLAS period using format CCYY.

Enter the month number of the current SCHOLAS period.

When the conversion process is complete, the BTCCNTL and JNLTRAN files are ready for processing through SCHOLAS.

 

The generated posting transactions are added to the PAYGTWK file to be processed through SMARTLAW.

Field Information

Enter the month number of the current Smartlaw period.

Enter the year number of the current Smartlaw period.

 

The generated posting transactions are added to the GELJNL file to be processed through STICS.

Field Information

Enter the period to post of the current STICS period.

When the conversion process is complete, the GELJNL file is ready for processing through STICS.

 

The generated posting transactions are added to the PAYSUNEXP file to be processed through SunAccount Systems.

Field Information

Enter the period number of the current SunAccount Systems accounting period.

Enter the year number of the current SunAccount Systems accounting period.

Enter *ERRORS to generate a report of errors only, or *ALL to generate a report of all transactions.

You must indicate whether the export file is to be cleared or not.

When the conversion is finished, the PAYSUNEXP file is ready to be imported into the SunAccount Systems General Ledger.

 

The generated posting transactions are added to the GLSUN or GLSUN2 files, which are to be processed through SunAccount Systems release 5.0.

The file to which the transactions are posted depends on the window chosen during the running of the G/I Interface process. All transactions which belong to the same Level 1, Level 5, Account No, Department, GL Account No, Employment Type, Pay Header date and Journal No. will be grouped and merged as one transaction before writing to the GLSUN and/or GLSUN2 files.

Field Information

Enter the month number of the current SunAccount Systems release 5.0 accounting period.

Enter the year number of the current SunAccount Systems release 5.0 accounting period.

You must indicate whether or not the transactions in the file are to be split according to Employment Type.

N Do not split records according to Employment Type. All records will be posted to the GLSUN.txt file
Y Split the records according to Employment Type. In this instance, the records for Casual employees will be posted to the GLSUN.txt file, while records for employees whose Employment Type is other than Casual will be posted to the GLSUN2.txt file.

When the conversion is finished, the GLSUN and/or GLSUN2 files are ready to be imported into the SunAccount Systems release 5.0 General Ledger.

 

The file created by this conversion for Working Systems G/L is WSPAYINP.

Field Information

Enter the year number of the current Working Systems G/L period using the format CCYY.

Enter the period number of the current Working Systems G/L period.