-
Type:
Bug
-
Status: Closed
-
Priority:
High
-
Resolution: Unresolved
-
Affects Version/s: None
-
Fix Version/s: None
-
Component/s: None
-
Labels:None
-
Environment:Production
-
Bug Type:Functional
-
Bug Severity:Medium
-
Module:BenAdmin - Report
-
Reported by:Client
-
Company:All Clients/Multiple Clients
-
Item State:Production Complete - Closed
Background: BCC has an incorrect update rule at the rate level that was causing the new elections to get a rate/age band as of January 1st. I had BCC correct the rule and manually go in an correct the impacted employees. That fixed the invoice amounts but there are some strange adjustments coming out on the August bill. My guess is after researching that some bad date/costs are in the billing table due to all the changes. This impacts two employees
Tim Ramsaur’s billing - he experienced a birthday in June and is being billed for entire month of June. His date of birth was June 25th? He should not be billed the increase rate until July's bill?
Gus Garcia DOB:4/22/72 (age 45)
Please note: Gus also had a volume change as the group first told us he should have 150k, then the group advised 100K, and finally it was decided that 150K was approved by Sun Life after all.
Invoice costs/adjustments before rate was corrected
April- $17.10 (age 44), volume 150K
May- we billed 11.40, volume 100K
June – we billed 25.65, volume 150K( adjustment for May, credit 11.40 and re-bill for 25.65)
July- we billed 25.65, volume 150K
After rate correction below are the adjustments on the current August invoice.
August – is billing correctly
July adj is a wash. – this is fine.
June is billing 42.75 and crediting 25.65?
May is billing 42.75 and crediting 25.65?
April is billing 5.13 and crediting 7.70? – Not sure why this adjustment is appearing for Garcia?
- is cloned by
-
-
- Closed
-
Hi Debbie Kulling,
We have done the code fix and deployed it on our QA environment. It will move on production as per build process.
We have also executed the fix on Production Sea tac. The adjustment of mentioned employees are proper now. Please verify.
Below are 3C's
Concern :- Invoice Adjustment Issue
Cause :- Term as never effective records were getting as retro add for non health plans
Correction :- We added condition to handle this.
Jyoti Agrawal (Inactive)
added a comment - Hi Debbie Kulling ,
We have done the code fix and deployed it on our QA environment. It will move on production as per build process.
We have also executed the fix on Production Sea tac. The adjustment of mentioned employees are proper now. Please verify.
Below are 3C's
Concern :- Invoice Adjustment Issue
Cause :- Term as never effective records were getting as retro add for non health plans
Correction :- We added condition to handle this. Affected files : OES_SP_GetRetroBillingDetails_InvoiceBenefitWise
Affected areas : Adjustment of billing for non helath
Tested scenarios :
Tested adjustment for termed as never active elections for non health plans
Jyoti Agrawal (Inactive)
added a comment - Affected files : OES_SP_GetRetroBillingDetails_InvoiceBenefitWise
Affected areas : Adjustment of billing for non helath
Tested scenarios :
Tested adjustment for termed as never active elections for non health plans Hi Jyoti Agrawal,
Could not reproduce the scenario which had caused the issue but verified invoice details for non health plans. Billing and adjustments displayed correctly. Please note that this scenario cannot be reproduced on Stage also. So I have tested the invoice on Production Hspl copy.
Prasanna Karlekar,Sachin Hingole
Thanks,
Venkatesh
Hi Debbie Kulling,
Verified invoice details for non health plans. Billing and adjustments displayed correctly. I have tested the invoice on Production main copy. Please could you verify and close this ticket
Prasanna Karlekar,Sachin Hingole
Thanks,
Venkatesh
Hi Debbie Kulling,
We have found the root cause and working on the fix.