-
Type:
Bug
-
Status: Closed
-
Priority:
High
-
Resolution: Unresolved
-
Affects Version/s: None
-
Fix Version/s: None
-
Component/s: BenAdmin
-
Labels:
-
Environment:Production
-
Bug Severity:Medium
-
Module:BenAdmin - Report
-
Reported by:Client
-
Company:TIBCO
-
Item State:Production Complete - Closed
-
Sprint:WT Sprint 41
Please see the adjustment issues BCC is having with TIBCO's August bill.
Issue 1: LTD coverage is being unbilled and rebilled at a pro-rated monthly portion. Example: Alec Cross Originally billing for January for Long-Term Disability at $16.25 on the January Invoice. On the August invoice he is being credited for January in the Amount of -$16.25 and being rebilled at $3.67. We did load a new salary effective 1/25/2017, but no billing adjustment should have occurred. The system looks like it is trying to pro-rate for those last 7 days of the month. (16.25/31*7=$3.67)
Other examples: Aaron Shoffa, Adrian Johnson, and many more.
Issue 2: Abay Prajapati terminated 5/31/2017 via a file load that occurred on 6/13/2017. The adjustments on the August invoice look correct with the exception of the COBRA Admin Coverage. COBRA admin did not credit for June or July and COBRA admin is still being billed for August. Even stranger he is being rebilled for January through May which he was previously billed during those billing cycles. Another example of same issue is Shaohua Qu.
Issue 3: Barton Wright his ADD is not age reducing correctly. His age reduction should be the same as life with a volume of $169,000.00. The system for ADD is crediting $110,000 and re-billing at a volume of $260,000 February through current month of August. It looks like the system has not been doing the ADD age reductions correctly from the beginning. The system was reducing the amount to $110,000 versus $169,000
Field | Original Value | New Value |
---|---|---|
Module | Parent values: BenAdmin(10100) | Parent values: BenAdmin(10100)Level 1 values: Report(10109) |
Status | Open [ 1 ] | In Development [ 10007 ] |
Assignee | Prasanna Karlekar [ prasanna ] | Debbie Kulling [ dkulling ] |
Remaining Estimate | 2h [ 7200 ] | |
Original Estimate | 2h [ 7200 ] |
Remaining Estimate | 2h [ 7200 ] | 0.5h [ 1800 ] |
Time Spent | 1.5h [ 5400 ] | |
Worklog Id | 65024 [ 65024 ] |
Attachment | Life Plan.png [ 56201 ] |
Attachment | AD&D Plan.png [ 56202 ] |
Attachment | Payroll Changes.png [ 56203 ] |
Remaining Estimate | 0.5h [ 1800 ] | 0h [ 0 ] |
Time Spent | 1.5h [ 5400 ] | 5h [ 18000 ] |
Worklog Id | 65900 [ 65900 ] |
Time Spent | 5h [ 18000 ] | 7.25h [ 26100 ] |
Worklog Id | 65908 [ 65908 ] |
Time Spent | 7.25h [ 26100 ] | 12.75h [ 45900 ] |
Worklog Id | 65911 [ 65911 ] |
Time Spent | 12.75h [ 45900 ] | 14.75h [ 53100 ] |
Worklog Id | 65917 [ 65917 ] |
Time Spent | 14.75h [ 53100 ] | 16.75h [ 60300 ] |
Worklog Id | 66927 [ 66927 ] |
Assignee | Debbie Kulling [ dkulling ] | Prasanna Karlekar [ prasanna ] |
Time Spent | 16.75h [ 60300 ] | 19.25h [ 69300 ] |
Worklog Id | 67861 [ 67861 ] |
Sprint | WT Sprint 34-Bugs [ 79 ] |
Dev Due Date | 04/Aug/2017 |
Code Reviewed By | Prasanna Karlekar [ 11907 ] | |
Dev Estimates | 35 |
Sprint | WT Sprint 34-Bugs [ 79 ] | WT Sprint 35 - Bugs [ 81 ] |
Company | TIBCO [ 13656 ] |
Time Spent | 19.25h [ 69300 ] | 19.5h [ 70200 ] |
Worklog Id | 72527 [ 72527 ] |
Time Spent | 19.5h [ 70200 ] | 19.75h [ 71100 ] |
Worklog Id | 72536 [ 72536 ] |
Time Spent | 19.75h [ 71100 ] | 20.75h [ 74700 ] |
Worklog Id | 72551 [ 72551 ] |
Time Spent | 20.75h [ 74700 ] | 21.25h [ 76500 ] |
Worklog Id | 72578 [ 72578 ] |
Sprint | WT Sprint 35 - Bugs [ 81 ] |
Time Spent | 21.25h [ 76500 ] | 21.75h [ 78300 ] |
Worklog Id | 75152 [ 75152 ] |
Dev Due Date | 04/Aug/2017 | 04/Aug/2017 |
Item State | Parent values: Development(10200)Level 1 values: On Hold(10207) |
Dev Due Date | 04/Aug/2017 | 04/Oct/2018 |
Dev Due Date | 04/Oct/2018 |
Labels | Invoice_Management |
Root Cause | Bug [ 18430 ] |
Environment_New | Production [ 18442 ] |
Time Spent | 21.75h [ 78300 ] | 22.75h [ 81900 ] |
Worklog Id | 89334 [ 89334 ] |
Code Reviewed By | Prasanna Karlekar [ 11907 ] | Jyoti Agarwal [ 16704 ] |
Dev Due Date | 15/Nov/2017 | |
Developer | Prasanna Karlekar [ prasanna ] |
Item State | Parent values: Development(10200)Level 1 values: On Hold(10207) | Parent values: Development(10200)Level 1 values: In Progress(10206) |
Item State | Parent values: Development(10200)Level 1 values: In Progress(10206) | Parent values: Development(10200)Level 1 values: On Hold(10207) |
Item State | Parent values: Development(10200)Level 1 values: On Hold(10207) | Parent values: Development(10200)Level 1 values: In Progress(10206) |
Assignee | Prasanna Karlekar [ prasanna ] | Parmeshwar Jumbad [ parmeshwar.jumbade ] |
Approval status | Approved for development [ 18453 ] | |
Attachment | FW Development approval for 9-Nov-2017.msg [ 68120 ] | |
Attachment | FW Development approval for 9-Nov-2017.msg [ 68121 ] |
Dev Due Date | 15/Nov/2017 | 05/Dec/2017 |
Sprint | WT Sprint 41 - Bugs [ 95 ] |
Dev Due Date | 05/Dec/2017 | 12/Dec/2017 |
Dev Estimates | 35 | 40 |
QA | Venkatesh Pujari [ venkatesh.pujari ] | |
QA Estimates | 8 |
Development Approval | Yes [ 18474 ] |
Stage Due Date | 22/Dec/17 [ 2017-12-22 ] |
Assignee | Parmeshwar Jumbad [ parmeshwar.jumbade ] | Prasanna Karlekar [ prasanna ] |
Attachment | FW 1211 Sprint - Development Approval.msg [ 69872 ] |
Item State | Parent values: Development(10200)Level 1 values: In Progress(10206) | Parent values: Development(10200)Level 1 values: Ready for Local Testing(10209) |
Code Reviewed By | Jyoti Agarwal [ 16704 ] | Prasanna Karlekar [ 11907 ] |
Item State | Parent values: Development(10200)Level 1 values: Ready for Local Testing(10209) | Parent values: LB QA(10201)Level 1 values: LB Deployed(11600) |
Assignee | Prasanna Karlekar [ prasanna ] | Venkatesh Pujari [ venkatesh.pujari ] |
Item State | Parent values: LB QA(10201)Level 1 values: LB Deployed(11600) | Parent values: LB QA(10201)Level 1 values: In Testing(10210) |
Status | In Development [ 10007 ] | Local Testing [ 10200 ] |
Status | Local Testing [ 10200 ] | Reopen in Local [ 10018 ] |
Item State | Parent values: LB QA(10201)Level 1 values: In Testing(10210) | Parent values: LB QA(10201)Level 1 values: Re-open(10212) |
Time Spent | 22.75h [ 81900 ] | 26.75h [ 96300 ] |
Worklog Id | 96293 [ 96293 ] |
Assignee | Venkatesh Pujari [ venkatesh.pujari ] | Prasanna Karlekar [ prasanna ] |
Status | Reopen in Local [ 10018 ] | In Development [ 10007 ] |
Item State | Parent values: LB QA(10201)Level 1 values: Re-open(10212) | Parent values: LB QA(10201)Level 1 values: LB Deployed(11600) |
Time Spent | 26.75h [ 96300 ] | 29.25h [ 105300 ] |
Worklog Id | 96752 [ 96752 ] |
Assignee | Prasanna Karlekar [ prasanna ] | Sachin Hingole [ sachin.hingole ] |
Item State | Parent values: LB QA(10201)Level 1 values: LB Deployed(11600) | Parent values: LB QA(10201)Level 1 values: In Testing(10210) |
Assignee | Sachin Hingole [ sachin.hingole ] | Venkatesh Pujari [ venkatesh.pujari ] |
Status | In Development [ 10007 ] | Local Testing [ 10200 ] |
Time Spent | 29.25h [ 105300 ] | 32.25h [ 116100 ] |
Worklog Id | 96816 [ 96816 ] |
Status | Local Testing [ 10200 ] | Reopen in Local [ 10018 ] |
Item State | Parent values: LB QA(10201)Level 1 values: In Testing(10210) | Parent values: LB QA(10201)Level 1 values: Re-open(10212) |
Time Spent | 32.25h [ 116100 ] | 36.25h [ 130500 ] |
Worklog Id | 97058 [ 97058 ] |
Assignee | Venkatesh Pujari [ venkatesh.pujari ] | Jyoti Agrawal [ jyoti.agrawal ] |
Time Spent | 36.25h [ 130500 ] | 38.75h [ 139500 ] |
Worklog Id | 97084 [ 97084 ] |
Status | Reopen in Local [ 10018 ] | In Development [ 10007 ] |
Attachment | Invoice_Scenarios_TestData.xlsx [ 70479 ] |
Assignee | Jyoti Agrawal [ jyoti.agrawal ] | Venkatesh Pujari [ venkatesh.pujari ] |
Status | In Development [ 10007 ] | Local Testing [ 10200 ] |
Item State | Parent values: LB QA(10201)Level 1 values: Re-open(10212) | Parent values: LB QA(10201)Level 1 values: In Testing(10210) |
Attachment | Invoice_Scenarios_TestData.xlsx [ 70479 ] |
Attachment | Scenarios.xls [ 70494 ] |
Time Spent | 38.75h [ 139500 ] | 41.75h [ 150300 ] |
Worklog Id | 97184 [ 97184 ] |
Item State | Parent values: LB QA(10201)Level 1 values: In Testing(10210) | Parent values: LB QA(10201)Level 1 values: LB Deployed(11600) |
Comment |
[ Hi [~jyoti.agrawal], Please find the scenario for which the system is not working as per expectation:- Self Insured components for E+SP tier are 60$ and 80$ both billable. Now I enroll the EE + SP in the Venky SI plan effective from 08/01/2017. Now generated the Invoice for Dec 2017 month. Proper billing and adjustment records were displayed on the invoice. Now change one Self Insured component to Non- Billable and generate the Invoice for jan 2018 month. We can see proper billing for Jan 2018 month and also we can see that credits have been given to the EE, but billable components cost is not charged for this EE. *REOPEN* [~prasanna],[~sachin.hingole] Thanks, Venkatesh ] |
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) |
Time Spent | 41.75h [ 150300 ] | 49.25h [ 177300 ] |
Worklog Id | 97366 [ 97366 ] |
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) |
Deployment Approval | Approved for stage deployment [ 18455 ] | |
Production Due Date | 29/Dec/2017 |
Time Spent | 49.25h [ 177300 ] | 50h [ 180000 ] |
Worklog Id | 97901 [ 97901 ] |
Status | Local Testing [ 10200 ] | Stage Testing [ 10201 ] |
Item State | Parent values: Stage QA(10202)Level 1 values: Stage Deployed(11602) | Parent values: Stage QA(10202)Level 1 values: In Testing(10214) |
Time Spent | 50h [ 180000 ] | 52.5h [ 189000 ] |
Worklog Id | 98010 [ 98010 ] |
Time Spent | 52.5h [ 189000 ] | 55h [ 198000 ] |
Worklog Id | 98020 [ 98020 ] |
Item State | Parent values: Stage QA(10202)Level 1 values: In Testing(10214) | Parent values: Stage QA(10202)Level 1 values: Ready for Production(10217) |
Time Spent | 55h [ 198000 ] | 61h [ 219600 ] |
Worklog Id | 98076 [ 98076 ] |
Item State | Parent values: Stage QA(10202)Level 1 values: Ready for Production(10217) | Parent values: Production QA(10203)Level 1 values: Production Deployed(10221) |
Comments |
Hi All, Following point has been approved for production deployment on 12/29 Regards Gaurav |
|
Deployment Approval | Approved for stage deployment [ 18455 ] | Approved for production deployment [ 18457 ] |
Status | Stage Testing [ 10201 ] | Production Testing [ 10202 ] |
Item State | Parent values: Production QA(10203)Level 1 values: Production Deployed(10221) | Parent values: Production QA(10203)Level 1 values: In Testing(10218) |
Item State | Parent values: Production QA(10203)Level 1 values: In Testing(10218) | Parent values: Production Complete(10222)Level 1 values: Closed(10223) |
Assignee | Venkatesh Pujari [ venkatesh.pujari ] | Debbie Kulling [ dkulling ] |
Resolution | Fixed [ 1 ] | |
Status | Production Testing [ 10202 ] | Production Complete [ 10028 ] |
Time Spent | 61h [ 219600 ] | 68.5h [ 246600 ] |
Worklog Id | 99049 [ 99049 ] |
Time Spent | 68.5h [ 246600 ] | 69h [ 248400 ] |
Worklog Id | 99086 [ 99086 ] |
Time Spent | 69h [ 248400 ] | 69.5h [ 250200 ] |
Worklog Id | 99097 [ 99097 ] |
Time Spent | 69.5h [ 250200 ] | 70.25h [ 252900 ] |
Worklog Id | 99106 [ 99106 ] |
Remaining Estimate | 0h [ 0 ] | 0.75h [ 2700 ] |
Time Spent | 70.25h [ 252900 ] | 69.5h [ 250200 ] |
Worklog Id | 99106 [ 99106 ] | |
Worklog Time Spent | 0.75h [ 2700 ] |
Resolution | Done [ 10000 ] | |
Status | Production Complete [ 10028 ] | Closed [ 6 ] |