Using the General Ledger Interface

This chapter discusses how to:

See Also

Integrating with PeopleSoft Enterprise General Ledger

Click to jump to parent topicRunning the General Ledger Interface Process

This section provides an overview of GLI process and discusses how to run the General Ledger Interface process.

Click to jump to top of pageClick to jump to parent topicUnderstanding GLI Process

The Calculate phase of GLI processing populates the GP_GL_DATA table.

You can also run The GL Mapping Application Engine process (GPMX_GL_RC) that updates ChartFields in GP_GL_DATA. The process selects and updates the necessary GP_GL_DATA records with specified ChartField overrides. When you run the finalize phase of the GL Interface process, the data is summarized by using your selected (remapped) ChartFields for correct account mapping.

After you have updated the GP_GL_DATA table, you can complete the standard core GLI process by running the Finalize process.

Running the ChartField Remapping Process

The ChartField remapping process:

You run the new Application Engine process as part of the standard General Ledger Interface process in the following sequence:

  1. Ensure that the GL Calculate phase is complete.

  2. Run the new Application Engine process to perform ChartField remapping.

    If you alter the remap, you must always rerun the calculate process. You can't rerun the remap process until you have run the calculation process.

  3. Run the GL Finalize process.

Note. This process runs as a separate process and is not integrated into existing Application Engines. In this way, it does not affect the existing GLI.

Process or Phase

PeopleSoft GL

QSP GL

Calculate

Y (yes)

Y

Leave Entitlement

Y

Y

Finalize

Y

N

Update Statistics

Y

Y

Click to jump to top of pageClick to jump to parent topicPages Used to Run the General Ledger Interface Process

Page Name

Definition Name

Navigation

Usage

Send Costs to GL MEX

GPMX_GL_PREPARE

Global Payroll & Absence Mgmt, Time and Labor / GL Costs, Send Costs to GL MEX, Send Costs to GL MEX

Initiate the processes for calculation of GL data, remapping of GL ChartFields, finalization of the GLI, and statistical data updating.

Review GL costing info MEX

GPMX_GL_INQUIRY

Global Payroll & Absence Mgmt, Time and Labor / GL Costs, Review GL costing info MEX, Review GL costing info MEX

View the GL costing information.

Click to jump to top of pageClick to jump to parent topicRunning the General Ledger Interface Process

Access the Send Costs to GL MEX page (Global Payroll & Absence Mgmt, Time and Labor / GL Costs, Send Costs to GL MEX, Send Costs to GL MEX).

Payroll Run

Calendar Group

Select a calendar group to run the process. Only calendar groups for which payroll is finalized but not yet sent to General Ledger are available.

Stream Number and Process Streams

Process Streams is selected if stream processing was used during the payroll process and must be used with the Calculate option. Select the stream number to process.

Posting Date

Enter the date on which the entries are posted to General Ledger. Even if you run your process on the fifteenth of the month, you can indicate that you want the entries posted on the thirtieth of the month.

Note. The posting date that you select must abide by the closing date of Journal Generator. Posting dates must be coordinated with General Ledger. If Time and Labor is installed and costing has been sent, the posting date defaults to the day the costing was sent. You can change this day in this field to reflect the day that the general ledger is actually sent to General Ledger.

Processing Phases and Options

Select a processing option. You can run Calculate and Finalize together if the Payroll process is finalized.

Calculate

Select to generate General Ledger transactions for the earnings, deduction, and accumulators that were calculated by the Payroll process for this calendar group and that belong to a General Ledger group. The Payroll process must have identified at least one payee before you can run the Calculate process.

If you're using stream processing, run the Calculate phase for one stream at a time.

You can run the Calculate phase more than once for each stream. During subsequent iterations, the system deletes existing data before creating new results. It stores final results in the Global Payroll Transaction Interface record (GP_GL_DATA) and inserts an entry in the Completed GL Stream table (GP_GL_PREP_STRM) to indicate that calculation is complete.

Chart Field Remap

Select to enable the ChartField Remap Application Engine process (GPMX_GL_RC) when running the General Ledger process. This run control page enables you to run an Application Engine process that updates ChartFields in GP_GL_DATA. The program selects and updates the necessary GP_GL_DATA records with specified ChartField overrides. When you run the GL Interface Finalize process, the data is summarized by using your selected (remapped) ChartFields for correct account mapping.

Finalize Entire Run

This check box is available for selection after the Payroll process has been finalized and you have run the Calculate phase for the entire calendar group. (If you are using stream processing, all streams must be calculated.)

Select this check box when you are ready to finalize the run. (Stream processing is not available for the Finalize phase.)

Note. The Finalize check box is hidden if PPS is installed.

Update Statistics

This check box is for the database administrator to help with fine-tuning system performance. If selected, the system generates statistics during batch processing that provide information about how worktables are being used.

Processing Phases

This group box displays all streams associated with the calendar group that have been processed and the status of the processing phases for each stream.

Stream Number

Displays the streams that are associated with the calendar group.

Calculate

If selected, then you have already run the GLI process (GLI_GPMX_GL) to calculate the stream.

Chart Remap

If selected, then you have already run the GLI process (GLI_GPMX_GL) to remap ChartFields in the stream.

Calendar List

The system displays information about each calendar in the calendar group.

Off Cycle Groups

The system displays off-cycle groups that were processed within the calendar group.

Click to jump to parent topicRemapping ChartFields After Initial Calculation

To remap General Ledger (GL) ChartFields for Global Payroll for Mexico, use the GL Chartfield Remapping MEX (GPMX_GL_MAP) component.

This section discusses how to remap ChartFields.

Click to jump to top of pageClick to jump to parent topicUnderstanding ChartField Remapping

Global Payroll for Mexico enables you to define ChartField remapping data used during the General Ledger (GL) interface process and post payroll costs to differing levels of ChartFields based on GL groupings codes or accounts. You set up GL ChartField parameters that enable you to remap default ChartFields after you run the initial Calculate process. For example, you might require that a higher level of ChartFields be attached to each of your cost centers. Instead of using multiple departments for each cost center, you may require one department at a global ChartField level, which covers all departments. By remapping the departments to the one global department you are able to roll costs from the various cost centers into this one department. For instance, perhaps you want to charge parking to facilities independently of an employee's department.

Click to jump to top of pageClick to jump to parent topicPage Used to Remap ChartFields After Initial Calculation

Page Name

Definition Name

Navigation

Usage

GL Chartfield Remapping MEX

GPMX_GL_MAP

Set Up HRMS, Product Related, Global Payroll & Absence Mgmt, Integration, GL Chartfield Remapping MEX, GL Chartfield Remapping MEX

Set up GL ChartField parameters that enable you to remap ChartFields after you run the initial Calculate process. You can configure and maintain GL remapping data. Enables you to set up different levels of ChartFields based on GL groupings codes or accounts.

Click to jump to top of pageClick to jump to parent topicRemapping ChartFields

Access the GL Chartfield Remapping MEX page (Set Up HRMS, Product Related, Global Payroll & Absence Mgmt, Integration, GL Chartfield Remapping MEX, GL Chartfield Remapping MEX).

Chartfields

ChartFields represent attributes of a payee, such as department, pay group, company, employee ID, etcetera. When you send a payee's earnings, deductions, or accumulator amounts to General Ledger, you can also transmit the values that are associated with your specific combination of ChartFields for the payee.

Chartfields to be passed to GL

A field appears for each ChartField that you set up on the Mapping page in Global Payroll. Use the specific ChartFields check boxes to prevent the system from sending particular ChartFields to the GL. During mapping, ChartFields can be used to cost to different account codes. You can then elect not to send the ChartFields to the GL and only send the values to the accounts. When integrating Global Payroll with General Ledger, you can remap ChartField values to a business unit's GL account numbers. To enter the new, remapped ChartField value, use the Transformed Values tab.

Chartfield Transformations

The default ChartFields values appear in the fields on the ChartFields tab. To remap the default settings, select the new values on the Transformed Values tab.

Chartfields and Transformed Values

Account

Displays the GL account number to which your ChartFields and grouping codes will map.

Grouping Code

Select the code to map to the GL account. This is the grouping code for the elements that are included in the GL transfer. A grouping comprises entry types of earnings, deductions, or segment accumulators. Elements must be in groups before they can be processed by General Ledger. Instead of entering earnings individually, you bundle them into one accumulator and create a grouping code for that accumulator.

See Also

Integrating with PeopleSoft Enterprise General Ledger