GP GL: Override Chartfield Retrospectively is not Forwarded to Current Calendar, Forwarded Amount in Current Calendar is Costed to Employee's NOT from the Retro Calendar
(Doc ID 3049394.1)
Last updated on SEPTEMBER 30, 2024
Applies to:
PeopleSoft Enterprise HCM Global Payroll Core - Version 9.2 to 9.2 [Release 9]Information in this document applies to any platform.
Symptoms
Override chartfield retrospectively is not forwarded to current calendar, forwarded amount in current calendar is costed to employee's not from the retro calendar.
The reported issue can be reproduced at will using below steps.
1. Setup the GL configuration for multiple GL accounts.
2. Navigate to Time and Labor > Enroll Time Reporters > Manage Time Reporter Data
Login:PS/PS
user: MCORTES (KA0003)
3. Navigate to MSS > TEAM TIME TILE > Enter Time
Approve the time card with the time details give below chart fields.
4.Enter Time. Submit and Approve in the same page.
5.Time and Labor > Process Time > Request time Admin
After Reported time is approved, run this process which would create the payable time.
6.With PS login approve the payable time.
Enter approver Operator ID as PS and click Approve selected.
Payable time is approved.
7.Note down the TRC code below:
select * from PS_TL_PAYABLE_TIME where dur='6-May-24' and emplid='KA0003';
With this setup on T&L side is done.
Below is the TL - GP integration setup:
8.Remove the Map to NA earnings value and UnSynch
Map earnings to TRC code. GP and choose an earning code.
9.Run payroll for May 2024
10. Run Send Costs To GL process:
SELECT G.CAL_RUN_ID, GROUPING_CODE, G.CALC_RSLT_VAL, G.PIN_CHART1_VAL, G.PIN_CHART2_VAL, G.PIN_CHART3_VAL, G.PIN_CHART4_VAL, G.PIN_CHART5_VAL, G.PIN_CHART6_VAL
FROM PS_GP_GL_DATA G WHERE EMPLID = 'KA0003' AND CAL_RUN_ID= 'KA 2024M05'
11. Chartfield value given in TL is picked here for Overtime.
For rest of the grouping code it has picked the CF values given in Distribution override.
12.Test Retro for April time sheet:
Calculate and finalize Apr 2024.
13. Enter Time sheet for April retroactively.
14.Select and Approve the Reported time
Run the Request Time Admin process. Payable time is generated.
Approve the Payable Time
15. select * from PS_TL_PAYABLE_TIME where dur='3-Apr-24' and emplid='KA0003';
Run the Payroll process for May'2024
16. Run the send cost to GL process:
SELECT CAL_RUN_ID , EMPLID, GP_PAYGROUP, CAL_ID, ORIG_CAL_RUN_ID ,
GROUPING_CODE , PIN_CHART1_VAL, PIN_CHART2_VAL, PIN_CHART3_VAL , ACCT_CD , CALC_RSLT_VAL
FROM PS_GP_GL_DATA WHERE CAL_RUN_ID = 'KA 2024M05' AND EMPLID = 'KA0003'AND GROUPING_CODE = 'OVERTIME_NEW';
17.There are 2 rows for Overtime.
As shown above, current period TL Overtime (216.35) is costed against the chartfield variable override value given in timesheet for May month
Previous period TL Overtime (216.35) is costed against the chartfield variable override value given in retro timesheet for April month.
18.This has a check box “To process GL” and when its checked it sums up the current and Retro amounts.
In the <images or examples> <above or below> and/or the attached document, user details / customer name / address / email / telephone number represent a fictitious sample (based up made up data used in the Product name test environment).
Any similarity to actual persons, living or dead, is purely coincidental and not intended in any manner.
Changes
Cause
To view full details, sign in with your My Oracle Support account. |
|
Don't have a My Oracle Support account? Click to get started! |
In this Document
| Symptoms |
| Changes |
| Cause |
| Solution |
| References |