Uploaded image for project: 'WORKTERRA'
  1. WORKTERRA
  2. WT-11470

Superheat - Billing Summary Report - Premium is not calculating correctly

    Details

    • Type: Bug
    • Status: Closed
    • Priority: Medium
    • Resolution: Done
    • Affects Version/s: None
    • Fix Version/s: None
    • Component/s: BenAdmin
    • Labels:
    • Environment:
      Production
    • Bug Type:
      Functional
    • Bug Severity:
      Critical
    • Module:
      BenAdmin - Report
    • Reported by:
      Client
    • Company:
      All Clients/Multiple Clients
    • Item State:
      Production Complete - Closed
    • Sprint:
      WT Sprint 41

      Description

      Please review the Billing Summary Report in Production - Client Name - Superheat FGH. This needs to be corrected as soon as possible, this is affecting the client and they as many other clients use this report to submit their volume and counts to their Life carriers to pay their premiums.

      The following plan premiums are not calculating correctly:
      Plan 1:
      Basic Life - Basic Life - Lincoln Financial Group
      Rate Name: 2016 - 2018 Basic Life-Basic Life
      Report shows $3,134.56, but when you manually calculate it the premium comes out to be $3,134.05 (volume*rate/coverage divisor) (16072050.00*0.1950/1000). There is a difference of $0.51.

      Plan 2:
      Plan: Basic AD&D-Basic AD&D-Lincoln Financial Group
      Rate Name: 2016 - 2018 Basic AD&D-Basic AD&D
      Report shows $401.33, but when you manually calculate it the premium comes out to be $400.83 (volume*rate/coverage divisor) (16033050.00*0.0250/1000). There is a difference of $0.50.

      Plan 3:
      Plan: Voluntary Child Life-Voluntary Child Life-Lincoln Financial Group
      Rate Name: 2016 - 2018 Vol Child life-Child Life
      Report shows $75.62, but when you manually calculate it the premium comes out to be $75.73 (volume*rate/coverage divisor) (380000.00*0.1993/1000). There is a difference of $0.11.

      This is also similar to WT 9738.

      Deborah Mascot
      lisa davison

        Attachments

        1. 1.png
          74 kB
          Sanjana Jadhav
        2. 2.png
          72 kB
          Sanjana Jadhav
        3. 3.png
          57 kB
          Sanjana Jadhav
        4. 4.png
          97 kB
          Sanjana Jadhav
        5. BasicAD&D_ratCal_OK.jpg
          159 kB
          Prasad Pise
        6. BasicLife_ratCal_OK.jpg
          166 kB
          Prasad Pise
        7. BillingSummaryReport.xls
          12 kB
          Priya Handepatil
        8. FW 1211 Sprint - Development Approval.msg
          51 kB
          Gaurav Sodani
        9. Superheat - Billing Summary Report - Calc is not correct - Basic Life_Basic ADD.PNG
          113 kB
          Yamilka Coca
        10. Superheat - Billing Summary Report - Calc is not correct - Child Life.PNG
          57 kB
          Yamilka Coca
        11. VolChildLife_ratCal_OK.jpg
          156 kB
          Prasad Pise
        12. WT-11470_Discrepancy.xlsx
          21 kB
          Prasanna Karlekar
        13. WT-11470.jpg
          256 kB
          Priya Handepatil
        14. WT-11470 - Superheat - Billing Summary Report_Test Scenarios.xls
          10 kB
          Meghana Joshi

          Issue Links

            Activity

            Hide
            parmeshwar.jumbad Parmeshwar Jumbad (Inactive) added a comment -

            Hi Jennifer Johnson,
            The code fix has been done and is ready for production. However, we have kept majority of the code releases on Production or stage on hold during the OE. We would request you to kindly reach out to CB team and take this up for production deployment approval.

            We are also taking this up for production deployment approval by our side as well.

            CC: Prasanna Karlekar Prasad Pise Gaurav Sodani Satya

            Show
            parmeshwar.jumbad Parmeshwar Jumbad (Inactive) added a comment - Hi Jennifer Johnson , The code fix has been done and is ready for production. However, we have kept majority of the code releases on Production or stage on hold during the OE. We would request you to kindly reach out to CB team and take this up for production deployment approval. We are also taking this up for production deployment approval by our side as well. CC: Prasanna Karlekar Prasad Pise Gaurav Sodani Satya
            Hide
            gaurav.sodani Gaurav Sodani (Inactive) added a comment -

            Hi All,

            Attaching the development approval email for your reference

            Regards
            Gaurav

            Show
            gaurav.sodani Gaurav Sodani (Inactive) added a comment - Hi All, Attaching the development approval email for your reference Regards Gaurav
            Hide
            gaurav.sodani Gaurav Sodani (Inactive) added a comment -

            Hi All,

            This ticket has been approved for stage deployment on 12/21/17.

            Regards
            Gaurav

            Show
            gaurav.sodani Gaurav Sodani (Inactive) added a comment - Hi All, This ticket has been approved for stage deployment on 12/21/17. Regards Gaurav
            Hide
            prasadp Prasad Pise (Inactive) added a comment -

            Hi Yamilka Coca

            We have verified the rate calculations & values of "Billing Summary Report" on production for " Superheat FGH For HSPL" company. No discrepancy observed.

            PFA following screenshots.


            Could you please confirm.
            CC Sanjana Jadhav [~parmeshwar.jumbade]SatyaGaurav Sodani

            Show
            prasadp Prasad Pise (Inactive) added a comment - Hi Yamilka Coca We have verified the rate calculations & values of "Billing Summary Report" on production for " Superheat FGH For HSPL" company. No discrepancy observed. PFA following screenshots. Could you please confirm. CC Sanjana Jadhav [~parmeshwar.jumbade] Satya Gaurav Sodani
            Hide
            gaurav.sodani Gaurav Sodani (Inactive) added a comment -

            Hi All,

            Attaching the production deployment approval email for reference

            Regards
            Gaurav

            Show
            gaurav.sodani Gaurav Sodani (Inactive) added a comment - Hi All, Attaching the production deployment approval email for reference Regards Gaurav

              People

              Assignee:
              Yamilka.Coca Yamilka Coca (Inactive)
              Reporter:
              Yamilka.Coca Yamilka Coca (Inactive)
              Account Executive:
              Yamilka Coca (Inactive)
              Developer:
              Parmeshwar Jumbad (Inactive)
              QA:
              Sanjana Jadhav (Inactive)
              Votes:
              0 Vote for this issue
              Watchers:
              8 Start watching this issue

                Dates

                Created:
                Updated:
                Resolved:
                Dev Due Date:
                Pre-Prod Due Date:
                Production Due Date:
                Code Review Date:

                  Time Tracking

                  Estimated:
                  Original Estimate - 35h Original Estimate - 35h
                  35h
                  Remaining:
                  Remaining Estimate - 0h
                  0h
                  Logged:
                  Time Spent - 51.5h
                  51.5h