Hi Prasanna Karlekar,[~parmeshwar.jumbade],

As per our discussion, we have checked to achieve discussed format but we can't achive this on export.

CC-Vinayak Kulkarni

Hi Debbie Kulling,

Have verified following discrepancies related to Billing Summary Report for Company - Barrow:

Count for Employee Optional Life matches.
Following is the reason for enrollment count discrepancy for Accident plan:
2 rates are mapped to this plan. 2018 - Accident - Employee and 2018 - Accident - Spouse. Summary report does not work for multiple Sub Rates. In case of multiple sub rates, as per data stored in system, sub rate that got stored first against an election is considered while processing summary. In our case for 600 elections, cost was first stored for rate 2018 - Accident - Employee. For remaining 156 elections, cost was first stored for rate 2018 - Accident - Spouse. All elections for this plan are done with coverage of Member type employee. But 2018 - Accident - Spouse rate is configured for Member type Spouse. Due to this member type discrepancy such records are getting excluded. Hence the difference in enrollment count.

Please validate, if the customization to map Spouse rate for Employee Optional Life plan is correct or not. If not then it needs to be unmapped and recalculation needs to be done. After which, discrepancy should get resolved between Enrollment and Billing Summary report

Hope this helps you.

Thank you!

Can you please unmap the rate and recalculate

also this need to be logged as a bug. There are times when we map two rates two one plan and when that happens the billing summary report should still work and be accurate

one more thing. This rate has been mapped for years. Why didn't we have this issue before

Hi Debbie Kulling,

We have created WT-13060 for issue "Billing Summary should work when multiple rates are mapped".
Regarding mapping of Spouse rate to Employee Accident plan:
We had this same issue last year too. Reference JIRA WT-7516. But at that time we handled it via corrections. Please refer below screenshot:

Hence now it is better, if we unmap and recalculate.
Assigning this JIRA to enrollment team for unmapping and recalculation. Post enrollment team's recalculation we will verify the Billing Summary report.

Thank you!

cc: Gaurav Sodani

Hi Jyoti Mayne,

Please unmap rate 2018 - Accident - Spouse for plan Employee Accident Coverage and recalculate. Assign the JIRA back to us for verification once recalculation is complete.

Thank you!

cc: Gaurav Sodani

can I please get an ETA on completion

Hi Prasanna Karlekar,

As requested, we have un-mapped "2018 - Accident - Spouse" rate from "Employee Accident Coverage" Plan in "Barrow for HSPL" on production. Please check and confirm.

Thanks and Regards,
:: Umesh Kadam

CC : Amruta Lohiya, Rohan J Khandave, Jyoti Mayne, [~parmeshwar.jumbade]

Hi Umesh Kadam,

Expected enrollment count is appearing on report. Please do the required on main copy.

Thank you!

cc: Amruta Lohiya, Jyoti Mayne

Hi Debbie Kulling,

As requested, we have un-mapped "2018 - Accident - Spouse" rate from "Employee Accident Coverage" Plan in LIVE copy of "Barrow" on production. Please check and confirm.

Thanks and Regards,
:: Umesh Kadam

CC : Amruta Lohiya, Rohan J Khandave, Jyoti Mayne, Prasanna Karlekar, [~parmeshwar.jumbade]