-
Type:
Support Activity
-
Status: Resolved
-
Priority:
Critical
-
Resolution: Unresolved
-
Affects Version/s: None
-
Fix Version/s: None
-
Component/s: None
-
Labels:
-
Support Task Type:Configuration
-
Environment:Production
-
Reported by:Client
-
Company:Five Guys
-
Module:BenAdmin
*Some employees show defined contribution as negative. This is appearing in the payroll file to client and client is asking us to fix immediately. One example is attached for Fallon Palladino who has a medical deduction of -56.59 on the payroll file.
We also have an issue with the where the client is manually changing the payroll deductions to round correctly. Currently $ amounts are truncated instead of rounded. We need some new macro for rounding the deduction correctly for Five Guys.
*
| Field | Original Value | New Value |
|---|---|---|
| Assignee | Rochelle Thomas [ rochelle.thomas ] |
| BA’s | Darryn Carter [ 14205 ] |
- standard rounding up and down for a $ amount
- negative amounts should be changed to 0
Fallon Paladino's record has been corrected.
There are other negatives for deduction amounts that we could not correct.
| Assignee | Rochelle Thomas [ rochelle.thomas ] | darryn.carter [ darryn.carter ] |
Hi Darryn: Unfortunately I did not request specific names I only know they were off by a penny. Rochelle, do you have any names you can share with Darryn? Thanks.
file path? The production files can be downloaded from workterra, exchange, view exported files, multi-company export, Five Guys ADP Payroll bi-weekly
Hi Darryn,
I do not have an example of negative defined contributions at this time. They should show up in an enrollment report from workterra.
Sumeet.Kolge (Inactive)
made changes -
| Description |
Some employees show defined contribution as negative. This is appearing in the payroll file to client and client is asking us to fix immediately. One example is attached for Fallon Palladino who has a medical deduction of -56.59 on the payroll file. We also have an issue with the where the client is manually changing the payroll deductions to round correctly. Currently $ amounts are truncated instead of rounded. We need some new macro for rounding the deduction correctly for Five Guys. |
*Some employees show defined contribution as negative. This is appearing in the payroll file to client and client is asking us to fix immediately. One example is attached for Fallon Palladino who has a medical deduction of -56.59 on the payroll file. We also have an issue with the where the client is manually changing the payroll deductions to round correctly. Currently $ amounts are truncated instead of rounded. We need some new macro for rounding the deduction correctly for Five Guys. * |
| Assignee | darryn.carter [ darryn.carter ] | Lorena Nava [ lorena.nava@ebsbenefits.com ] |
We are unable to reproduce the issue and this would need to go to Dev.
Would you like me to submit?
Yes. This issue needs resolution asap. Please escalate asap for me. Thank you!
Hello Dev,
We were unable to reproduce the negative values that were received for the EEs cost. Can you please review this?
Thank you
| Assignee | Lorena Nava [ lorena.nava@ebsbenefits.com ] | Samir [ samir ] |
| Assignee | Samir [ samir ] | Avnish Yadav [ avnish.yadav ] |
Hi Traci Simpson,
We are able to reproduce this issue at our end please refer below steps to Reproduce this issue:-
Step 1. Login as employee and reach to recommended plans screen. Do not checkout.
Step 2. In Partner login, While managing this employee, open Enrollment Summery and check value of 'Total Employee Weekly Deduction'. Its -ve value.
This issue is only for those employee whose "Total Benefit Employee Cost" is less then Defined Contribution Allotted. We will fixed this issue ASAP.
Thanks,
Avnish Y
CC- Jyoti Mayne, Satya,Samir
Please provide an ETA on when this will be corrected. Client wants this fixed today. Thanks.
| Issue Type | Support Activity [ 10301 ] | Bug [ 1 ] |
| Support Task Type | Customization [ 11204 ] | |
| Workflow | WT_Support [ 30839 ] | WT_Defects [ 30959 ] |
| Status | Open [ 1 ] | In Development [ 10007 ] |
Khandu Kshirsagar (Inactive)
made changes -
| Item State | Parent values: LB QA(10201)Level 1 values: LB Deployed(11600) |
| Code Reviewed By | Jyoti Mayne [ 11910 ] |
| Status | In Development [ 10007 ] | Local Testing [ 10200 ] |
| Item State | Parent values: LB QA(10201)Level 1 values: LB Deployed(11600) | Parent values: LB QA(10201)Level 1 values: Ready for Stage(10213) |
Displaying proper value after changing tier .
| Assignee | Avnish Yadav [ avnish.yadav ] | Prasad Pise [ prasadp ] |
Khandu Kshirsagar (Inactive)
made changes -
| Item State | Parent values: LB QA(10201)Level 1 values: Ready for Stage(10213) | Parent values: Stage QA(10202)Level 1 values: Stage Deployed(11602) |
| Item State | Parent values: Stage QA(10202)Level 1 values: Stage Deployed(11602) | Parent values: Production QA(10203)Level 1 values: Production Deployed(10221) |
Do we have an update for client?
Lorena.Nava@ebsbenefits.com This is deployed on production, please check and confirm.
Hi Rakesh Roy,
I ran the Exchange production payroll export and there is a negative amount for
Jason Tibby Medical -109.59
-109.59 Bi-Weekly PPO 500 Employee Only FGO General Manager
Here are a few examples of the rounding issue, client is manually changing to the correct rounding:
WT Deduction Amount Pay Schedule Plan Desc Tier rounding
$9.97 Bi-Weekly Dental High Plan Employee Only should be: $9.98
$3.27 Bi-Weekly Dental Low Plan Employee Only should be $3.28
$6.88 Bi-Weekly Dental Low Plan Employee+Child(ren) should be $6.89
$209.49 Bi-Weekly PPO 250 Employee+Child(ren) should be $209.48
| Status | Local Testing [ 10200 ] | Stage Testing [ 10201 ] |
| Resolution | Unresolved [ 10200 ] | |
| Status | Stage Testing [ 10201 ] | Reopen in Stage [ 10023 ] |
| Status | Reopen in Stage [ 10023 ] | In Development [ 10007 ] |
| Item State | Parent values: Production QA(10203)Level 1 values: Production Deployed(10221) | Parent values: Development(10200)Level 1 values: In Progress(10206) |
| Assignee | Prasad Pise [ prasadp ] | Avnish Yadav [ avnish.yadav ] |
Hi Rochelle Thomas,
Please refer below 3'c :-
Concern :- Negative amount for Jason Tibby Medical -109.59.
Cause :- We fixed this issue in our code but not recalculated Employer Defined Contribution so this is issue for existing employee.
Correction :- Now we have recalculated Employer Defined Contribution . It is showing proper cost on UI.
Regarding rounding issue: Vinayak Kulkarni, could you please provide update on this because this is on file.
Thanks,
Avnish Y
CC- Jyoti Mayne,Satya
| Assignee | Avnish Yadav [ avnish.yadav ] | Vinayak Kulkarni [ vinayak.kulkarni ] |
| Remaining Estimate | 6h [ 21600 ] | |
| Original Estimate | 6h [ 21600 ] |
| Remaining Estimate | 6h [ 21600 ] | 5.75h [ 20700 ] |
| Time Spent | 0.25h [ 900 ] | |
| Worklog Id | 20449 [ 20449 ] |
| Remaining Estimate | 5.75h [ 20700 ] | 5.5h [ 19800 ] |
| Time Spent | 0.25h [ 900 ] | 0.5h [ 1800 ] |
| Worklog Id | 20454 [ 20454 ] |
Hello Lorena.Nava@ebsbenefits.com & Rochelle Thomas,
We checked "EmployeeCostMinusCredits" field. As per implementation below is formula
EmployeeCostMinusCredits = Employee Cost - CreditAmount.
Both Employee Cost & Credit Amount are rounded up to two decimal points then subtracts . Due to that there difference of 0.01.
Ex. $3.27 Bi-Weekly Dental Low Plan Employee Only should be $3.28
Monthly Cost : 26.18
Bi-Weekly Cost: (26.18 * 12)/26 = 12.083 , 12.08 with two decimal point
Credit Amount : 19.08
Bi-Weekly Credit Cost : (19.08*12)/26) = 8.806 , 8.81 with two decimal point
EmployeeCostMinusCredits : 12.083 - 8.806 = 3.277 with two decimal rounding 3.28
EmployeeCostMinusCredits : 12.08 - 8.81 = 3.27 with two decimal rounding 3.27
Thanks,
Rohan J Khandave
CC – Vinayak Kulkarni , Ganesh Sadawarte
| Assignee | Vinayak Kulkarni [ vinayak.kulkarni ] | Lorena Nava [ lorena.nava@ebsbenefits.com ] |
| Issue Type | Bug [ 1 ] | Support Activity [ 10301 ] |
| Status | In Development [ 10007 ] | Resolved [ 5 ] |
| Support Task Type | Customization [ 11204 ] | |
| Workflow | WT_Defects [ 30959 ] | WT_Support [ 31124 ] |
| Remaining Estimate | 5.5h [ 19800 ] | 3h [ 10800 ] |
| Time Spent | 0.5h [ 1800 ] | 3h [ 10800 ] |
| Worklog Id | 20468 [ 20468 ] |
| Remaining Estimate | 3h [ 10800 ] | 0h [ 0 ] |
| Time Spent | 3h [ 10800 ] | 7h [ 25200 ] |
| Worklog Id | 21916 [ 21916 ] |
| Time Spent | 7h [ 25200 ] | 11h [ 39600 ] |
| Worklog Id | 21919 [ 21919 ] |
| Environment_New | Production [ 18442 ] |
| Transition | Time In Source Status | Execution Times |
|---|
|
4d 9h 10m | 1 |
|
1d 4h 9m | 1 |
|
5h 50m | 1 |
|
15h 53m | 1 |
|
8s | 1 |
|
5s | 1 |
|
11h 43m | 1 |
Hello Rochelle Thomas
Can you please assist with the above? Can you provide the path for the payroll file? Also is there a way to not include negatives?
Hello Lorena.Nava@ebsbenefits.com
For your 1st issue we are unable to see the same deduction/screen shot you have attached. For your 2nd issue can you please provide an example of the EE and what your expecting to see for the rounding.