This is version 1 2 3 4 5 6 7 8 9 10 11 12 . It is not the current version, and thus it cannot be edited.

Back to current versionRestore this version

CREATE G/L INTERFACE FILE#

If an interface file to a general ledger system needs to be created, then this function must be run.

Running UPGLF in non-trial mode will commit the journal entries. For Labor G/L, this will mark individual pay lines as ‘Journalized’, for Payroll G/L this will mark the pay header as ‘Journalized’.

When UPGLF is run in ‘Non-Trial’ mode, it will mark all of the pay headers and pay lines that it is picking up as being ‘journalized’.

Report Parameters
GL Company Code	Mandatory, LOV Available GL Company that the pays must be journalized for, as set up in the IDGC form.
From Fiscal Period	Optional, LOV Available This field allows you to specify a beginning Fiscal Period used to qualify the Journal Entries.
Up to Fiscal Period	Optional, LOV Available According to the IDCL set up.
Summarize Option
Re-Interface Only	Optional, LOV Available This toggle indicates if UPGLF should pick up pay runs and pay headers that are marked with Pay Run and Pay Header stage as '86 - To-be re-interface' only. All other stages will not be processed. This toggle should be used you only want to reverse out (i.e. negate) the previously sent journal entries.
GL Format Code	Optional, LOV Available Only those reports of the format “G/L Interface" will display. Choose from the report formats created. The format “HL$GL" has been provided as a sample, but should be copied, and the copy edited, by the client before running this report. The report definition selected will determine the format of the output file (if any), as well as the columnar content of the report.
GL File Name	Optional, Text Enter the name of the file that will be created in the interface directory specified. e.g. HLGL_mex.txt, if ‘mex’ is specified, MEX_ID will insert text into the file name.
Write or Append to GL file	Mandatory, LOV Available, Defaults as <Write to File> If the file already exists should the current information overwrite it or append to it?
Cost Format Code	Optional, LOV Available Only those reports of the format “Cost Interface" will display. Choose from the report formats created. The format “HL$COST" has been provided as a sample, but should be copied, and the copy edited, by the client before running this report. The report definition selected will determine the format of the output file (if any), as well as the columnar content of the report. This field is used for the Financial Costing module only.
Cost File Name	Optional, Text Enter the name of the file that will be created in the interface directory specified. This field is used for the Financial Costing module.
Write or Append to Cost	Mandatory, LOV Available, Defaults as <Write to File> If the file already exists should the current information overwrite it or append to it?
Interface Directory	Optional, Text Must be a directory on the server for which the current user (as signed onto the client’s network) has write capability. For example the entry ‘C:\TEMP’ accesses the ‘TEMP’ directory on the server, not the local directory for the computer terminal being used.
External GL Info
Exception Level	Mandatory, LOV Available You may increase the level of exception to utility levels for testing purposes.

Report Filters
Journal Source	Optional, LOV Available Journal Source indicates where the entries are originating from Labor G/L, Payroll G/L, Accrual G/L, Trial Labor G/L, Trial Payroll G/L, or Trial Accrual G/L.
Journal Type	Optional, LOV Available The Journal Type may be Financial or Statistical.
Entity	Optional, LOV Available This report will be limited to the entities identified in this field.
Payroll	Optional, LOV Available This report will be limited to the payrolls identified in this field.
Pay Run Number	Optional, LOV Available This report will be limited to the pay run numbers identified in this field.
From Execution ID	Optional, LOV Available This is the Execution ID from the Labor or Payroll General Ledger Update (UPLG or UPGL).
Person Code	Optional, LOV Available This report will be limited to the person codes identified in this field.