This chapter discusses how to:
Run the General Ledger Interface process.
Remap ChartFields after initial calculation.
See Also
Integrating with PeopleSoft Enterprise General Ledger
This section provides an overview of GLI process and discusses how to run the General Ledger Interface 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:
Uses specified ChartField overrides and updates the GP_GL_DATA records.
Enables the finalize phase of the GL Interface process to correctly summarize transactions by using your selected combination of ChartFields, grouping codes, and account values.
You run the new Application Engine process as part of the standard General Ledger Interface process in the following sequence:
Ensure that the GL Calculate phase is complete.
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.
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 |
Page Name |
Definition Name |
Navigation |
Usage |
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. |
|
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. |
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. |
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.
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.
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.
Page Name |
Definition Name |
Navigation |
Usage |
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. |
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