Uploaded image for project: 'New Features 2017'
  1. New Features 2017
  2. NF-5533

Superheat - Billing Summary Report - Premium is not calculating correctly

    Details

    • Type: Bug
    • Status: Closed
    • Priority: Medium
    • Resolution: Bug Fixed
    • Affects Version/s: None
    • Fix Version/s: None
    • Component/s: UI Refresh
    • Labels:
    • Environment:
      Production
    • Bug Type:
      Functional
    • Bug Severity:
      Critical
    • Module:
      BenAdmin - Report
    • Reported by:
      Client
    • Company:
      All Clients/Multiple Clients
    • Item State:
      Stage QA - Production Deployment on Hold
    • 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
          1.png
          74 kB
        2. 2.png
          2.png
          72 kB
        3. 3.png
          3.png
          57 kB
        4. 4.png
          4.png
          97 kB
        5. Basic Life.png
          Basic Life.png
          36 kB
        6. BillingReportServerError.txt
          3 kB
        7. BillingReportServerError (a8f1a507-2238-45d4-aaf3-e3f9e544869c).txt
          3 kB
        8. BillingSummary_1.jpg
          BillingSummary_1.jpg
          263 kB
        9. BillingSummary_2.jpg
          BillingSummary_2.jpg
          208 kB
        10. BillingSummaryReport.xls
          12 kB
        11. FW 1211 Sprint - Development Approval.msg
          51 kB
        12. NF-5533_1.png
          NF-5533_1.png
          45 kB
        13. NF-5533_2.png
          NF-5533_2.png
          43 kB
        14. optional child life.png
          optional child life.png
          63 kB
        15. Superheat - Billing Summary Report - Calc is not correct - Basic Life_Basic ADD.PNG
          Superheat - Billing Summary Report - Calc is not correct - Basic Life_Basic ADD.PNG
          113 kB
        16. Superheat - Billing Summary Report - Calc is not correct - Child Life.PNG
          Superheat - Billing Summary Report - Calc is not correct - Child Life.PNG
          57 kB
        17. WT-11470_Discrepancy.xlsx
          21 kB
        18. WT-11470.jpg
          WT-11470.jpg
          256 kB
        19. WT-11470 - Superheat - Billing Summary Report_Test Scenarios.xls
          10 kB

          Issue Links

            Activity

            parmeshwar.jumbad Parmeshwar Jumbad (Inactive) logged work - 19/Dec/17 03:27 PM
            • Time Spent:
              0.75h
               

              JIRA creation and Update
              Code check-in into UI refresh LB and trunk branch

            priya.dhamande Priya Dhamande (Inactive) logged work - 20/Dec/17 08:36 AM
            • Time Spent:
              2h
               

              Codemap testing

            priya.dhamande Priya Dhamande (Inactive) logged work - 20/Dec/17 09:50 AM - edited
            • Time Spent:
              2h
               

              Codemap testing

            priya.dhamande Priya Dhamande (Inactive) logged work - 21/Dec/17 08:00 AM
            • Time Spent:
              0.5h
               
              <No comment>
            priya.dhamande Priya Dhamande (Inactive) logged work - 27/Dec/17 12:35 PM
            • Time Spent:
              0.5h
               
              • discussion with Parmeshwar
              • test for billing Summary report
            prasad.patil Prasad Patil (Inactive) logged work - 27/Dec/17 01:00 PM
            • Time Spent:
              1.5h
               

              Checking on Codemap.

            parmeshwar.jumbad Parmeshwar Jumbad (Inactive) logged work - 28/Dec/17 10:25 AM
            • Time Spent:
              4h
               

              Issue analysis
              Internal discussion
              JIRA update

            parmeshwar.jumbad Parmeshwar Jumbad (Inactive) logged work - 29/Dec/17 05:14 AM
            • Time Spent:
              5.75h
               

              Issue analysis for Total amount premium discrepancies
              Internal discussions
              JIRA update
              Email communication

            parmeshwar.jumbad Parmeshwar Jumbad (Inactive) logged work - 29/Dec/17 11:24 AM
            • Time Spent:
              2h
               

              Data analysis
              Check reason of issue blocker
              Internal discussion

            snehal.shabade Snehal Shabade (Inactive) logged work - 04/Jan/18 11:45 AM
            • Time Spent:
              2h
               
              • Discussion with Umesh and parmeshwar regarding issue
              • analysis on back end data
            umesh.kadam Umesh Kadam (Inactive) logged work - 04/Jan/18 05:30 PM
            • Time Spent:
              1.5h
               

              Initial Analysis and discussion with Jyoti
              Discussion with Snehal and Parmeshwar regarding issue and customization

            parmeshwar.jumbad Parmeshwar Jumbad (Inactive) logged work - 08/Jan/18 10:16 AM
            • Time Spent:
              2.5h
               

              Verified reports after rates recalculation through SA utility.
              Internal discussion with Snehal and JIRA Update.

            snehal.shabade Snehal Shabade (Inactive) logged work - 08/Jan/18 11:31 AM
            • Time Spent:
              0.5h
               
              • discussion with parmeshwar
              • analysis on back end data
            prasad.patil Prasad Patil (Inactive) logged work - 09/Jan/18 12:03 PM
            • Time Spent:
              1.5h
               

              Analysis and resolution verfication on Pre Prod.

            sanjana.jadhav Sanjana Jadhav (Inactive) logged work - 13/Mar/18 07:11 AM
            • Time Spent:
              1.7h
               

              Production testing

              People

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

                Dates

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

                  Time Tracking

                  Estimated:
                  Original Estimate - 35h
                  35h
                  Remaining:
                  Time Spent - 28.7h Remaining Estimate - 6.3h
                  6.3h
                  Logged:
                  Time Spent - 28.7h Remaining Estimate - 6.3h
                  28.7h