on 2024 Feb 14 5:28 PM
Hi Team,
We have a field on our variable pay template history section where it stores the # of days of each assignment row.
We started the cycle few days back and with the help of SAP SF, we scheduled Employee History job along with update worksheets and another job to perform mass update and this job type is "Variable Pay Mass Update Job". Prior years, this used to update the field correctly but this year, it is not updating that field correctly.
For ex: one of the assignment has start date as 12/31/2022 and end date 12/31/2023. The job is calculated the # of days as 366 instead of 365 as it considers 12/31/2022 as well. Whereas in prior years, it used to calculated 365 correctly.
Anyone facing this type of issue and how this was resolved.
Guidance appreciated.
Best Regards,
Balaji
Request clarification before answering.
Hi,
After rescheduling the jobs in provisioning, the issue was fixed and the # of days got calculated correctly.
This can be closed.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Can you check in last year's template employee history whether the start date of the records was 1/1 by any chance ? The end date will always be 12/31 but I'm thinking that maybe last year you used 1/1 (which is the start date that should be used for this formula to work correctly). Please test with 1/1 for this year and see what happens.
I will test when I find time (not much lately unfortunately).
All the best
Xavier
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
There is no standard field that calculates the number of days by assignment so this number of days is calculated through a custom field at the assignment level.
Can you please share the formula in the assignment level custom field of that field ?
All the best
Xavier
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi @xavierlegarrec :
Yes, it is a custom field and here is the formula used on it. dateDiff(customStartDate,customEndDate)+1
And at the summary level, the same field is used to calculate aggregate value.
Please let me know for any additional information.
Thank you.
User | Count |
---|---|
9 | |
4 | |
3 | |
3 | |
3 | |
1 | |
1 | |
1 | |
1 | |
1 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.