New Features 2017Project Type: software

New Features 2017

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

          causes

          Bug - A problem which impairs or prevents the functions of the product. WT-12096 Functional | Any company |ACA |Measurement stability period | An error is occurring during report process

          • Medium - Has the potential to affect progress.
          • Production Complete
          clones

          Bug - A problem which impairs or prevents the functions of the product. WT-11470 Superheat - Billing Summary Report - Premium is not calculating correctly

          • Medium - Has the potential to affect progress.
          • Closed
          is caused by

          Bug - A problem which impairs or prevents the functions of the product. NF-5395 Southern Regional>"From Date" and "To Date" validation messages are not similar

          • Low - Minor problem or easily worked around.
          • Closed

            Activity

            Ascending order - Click to sort in descending order
            parmeshwar.jumbad Parmeshwar Jumbad (Inactive) created issue -
            parmeshwar.jumbad Parmeshwar Jumbad (Inactive) made changes -
            Field Original Value New Value
            Link This issue clones WT-11470 [ WT-11470 ]
            parmeshwar.jumbad Parmeshwar Jumbad (Inactive) made changes -
            Link This issue causes WT-12096 [ WT-12096 ]
            parmeshwar.jumbad Parmeshwar Jumbad (Inactive) made changes -
            Component/s UI Refresh [ 10902 ]
            Component/s BenAdmin [ 10000 ]
            Environment_Old Production [ 10005 ]
            Key WT-12815 NF-5533
            Project WORKTERRA [ 10000 ] New Features 2017 [ 11000 ]
            parmeshwar.jumbad Parmeshwar Jumbad (Inactive) made changes -
            Assignee Sanjana Jadhav [ sanjana.jadhav ] Parmeshwar Jumbad [ parmeshwar.jumbade ]
            parmeshwar.jumbad Parmeshwar Jumbad (Inactive) made changes -
            Item State Parent values: Stage QA(10202)Level 1 values: Ready for Production(10217) Parent values: Development(10200)Level 1 values: Ready for Local Testing(10209)
            parmeshwar.jumbad Parmeshwar Jumbad (Inactive) made changes -
            Status Open [ 1 ] In Development [ 10007 ]
            parmeshwar.jumbad Parmeshwar Jumbad (Inactive) made changes -
            Summary CLONE - Superheat - Billing Summary Report - Premium is not calculating correctly Superheat - Billing Summary Report - Premium is not calculating correctly
            khandu.kshirsagar Khandu Kshirsagar (Inactive) made changes -
            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)
            parmeshwar.jumbad Parmeshwar Jumbad (Inactive) made changes -
            Assignee Parmeshwar Jumbad [ parmeshwar.jumbade ] Sachin Hingole [ sachin.hingole ]
            parmeshwar.jumbad Parmeshwar Jumbad (Inactive) made changes -
            Remaining Estimate 35h [ 126000 ] 34.25h [ 123300 ]
            Time Spent 0.75h [ 2700 ]
            Worklog Id 96997 [ 96997 ]
            sachin.hingole Sachin Hingole (Inactive) made changes -
            Status In Development [ 10007 ] Local Testing [ 10200 ]
            sachin.hingole Sachin Hingole (Inactive) made changes -
            Item State Parent values: LB QA(10201)Level 1 values: LB Deployed(11600) Parent values: LB QA(10201)Level 1 values: In Testing(10210)
            priya.dhamande Priya Dhamande (Inactive) made changes -
            Attachment BillingSummary_2.jpg [ 70462 ]
            priya.dhamande Priya Dhamande (Inactive) made changes -
            Attachment BillingSummary_1.jpg [ 70463 ]
            priya.dhamande Priya Dhamande (Inactive) made changes -
            Attachment BillingReportServerError.txt [ 70464 ]
            priya.dhamande Priya Dhamande (Inactive) made changes -
            Item State Parent values: LB QA(10201)Level 1 values: In Testing(10210) Parent values: LB QA(10201)Level 1 values: Re-open(10212)
            priya.dhamande Priya Dhamande (Inactive) made changes -
            Status Local Testing [ 10200 ] Reopen in Local [ 10018 ]
            priya.dhamande Priya Dhamande (Inactive) made changes -
            Assignee Sachin Hingole [ sachin.hingole ] Parmeshwar Jumbad [ parmeshwar.jumbade ]
            priya.dhamande Priya Dhamande (Inactive) made changes -
            Remaining Estimate 34.25h [ 123300 ] 32.25h [ 116100 ]
            Time Spent 0.75h [ 2700 ] 2.75h [ 9900 ]
            Worklog Id 97089 [ 97089 ]
            parmeshwar.jumbad Parmeshwar Jumbad (Inactive) made changes -
            Link This issue is caused by NF-5395 [ NF-5395 ]
            priya.dhamande Priya Dhamande (Inactive) made changes -
            Remaining Estimate 32.25h [ 116100 ] 29.75h [ 107100 ]
            Time Spent 2.75h [ 9900 ] 5.25h [ 18900 ]
            Worklog Id 97110 [ 97110 ]
            parmeshwar.jumbad Parmeshwar Jumbad (Inactive) made changes -
            Status Reopen in Local [ 10018 ] In Development [ 10007 ]
            parmeshwar.jumbad Parmeshwar Jumbad (Inactive) made changes -
            Item State Parent values: LB QA(10201)Level 1 values: Re-open(10212) Parent values: LB QA(10201)Level 1 values: LB Deployed(11600)
            parmeshwar.jumbad Parmeshwar Jumbad (Inactive) made changes -
            Assignee Parmeshwar Jumbad [ parmeshwar.jumbade ] Sachin Hingole [ sachin.hingole ]
            sachin.hingole Sachin Hingole (Inactive) made changes -
            Status In Development [ 10007 ] Local Testing [ 10200 ]
            sachin.hingole Sachin Hingole (Inactive) made changes -
            Assignee Sachin Hingole [ sachin.hingole ] Priya Dhamande [ priya.dhamande ]
            priya.dhamande Priya Dhamande (Inactive) made changes -
            Item State Parent values: LB QA(10201)Level 1 values: LB Deployed(11600) Parent values: LB QA(10201)Level 1 values: In Testing(10210)
            priya.dhamande Priya Dhamande (Inactive) made changes -
            Remaining Estimate 29.75h [ 107100 ] 29.25h [ 105300 ]
            Time Spent 5.25h [ 18900 ] 5.75h [ 20700 ]
            Worklog Id 97944 [ 97944 ]
            priya.dhamande Priya Dhamande (Inactive) made changes -
            Remaining Estimate 29.25h [ 105300 ] 29.75h [ 107100 ]
            Time Spent 5.75h [ 20700 ] 5.25h [ 18900 ]
            Worklog Id 97110 [ 97110 ]
            priya.dhamande Priya Dhamande (Inactive) made changes -
            Assignee Priya Dhamande [ priya.dhamande ] Parmeshwar Jumbad [ parmeshwar.jumbade ]
            priya.dhamande Priya Dhamande (Inactive) made changes -
            Status Local Testing [ 10200 ] Reopen in Local [ 10018 ]
            priya.dhamande Priya Dhamande (Inactive) made changes -
            Item State Parent values: LB QA(10201)Level 1 values: In Testing(10210) Parent values: LB QA(10201)Level 1 values: Re-open(10212)
            parmeshwar.jumbad Parmeshwar Jumbad (Inactive) made changes -
            Assignee Parmeshwar Jumbad [ parmeshwar.jumbade ] Priya Dhamande [ priya.dhamande ]
            parmeshwar.jumbad Parmeshwar Jumbad (Inactive) made changes -
            Status Reopen in Local [ 10018 ] In Development [ 10007 ]
            parmeshwar.jumbad Parmeshwar Jumbad (Inactive) made changes -
            Item State Parent values: LB QA(10201)Level 1 values: Re-open(10212) Parent values: LB QA(10201)Level 1 values: LB Deployed(11600)
            sachin.hingole Sachin Hingole (Inactive) made changes -
            Status In Development [ 10007 ] Local Testing [ 10200 ]
            sachin.hingole Sachin Hingole (Inactive) made changes -
            Item State Parent values: LB QA(10201)Level 1 values: LB Deployed(11600) Parent values: LB QA(10201)Level 1 values: In Testing(10210)
            prasad.patil Prasad Patil (Inactive) made changes -
            Attachment optional child life.png [ 70831 ]
            prasad.patil Prasad Patil (Inactive) made changes -
            Attachment Basic Life.png [ 70832 ]
            prasad.patil Prasad Patil (Inactive) made changes -
            Status Local Testing [ 10200 ] Reopen in Local [ 10018 ]
            prasad.patil Prasad Patil (Inactive) made changes -
            Assignee Priya Dhamande [ priya.dhamande ] Parmeshwar Jumbad [ parmeshwar.jumbade ]
            prasad.patil Prasad Patil (Inactive) made changes -
            Item State Parent values: LB QA(10201)Level 1 values: In Testing(10210) Parent values: LB QA(10201)Level 1 values: Re-open(10212)
            priya.dhamande Priya Dhamande (Inactive) made changes -
            Remaining Estimate 29.75h [ 107100 ] 29.25h [ 105300 ]
            Time Spent 5.25h [ 18900 ] 5.75h [ 20700 ]
            Worklog Id 98079 [ 98079 ]
            prasad.patil Prasad Patil (Inactive) made changes -
            Remaining Estimate 29.25h [ 105300 ] 27.75h [ 99900 ]
            Time Spent 5.75h [ 20700 ] 7.25h [ 26100 ]
            Worklog Id 98100 [ 98100 ]
            parmeshwar.jumbad Parmeshwar Jumbad (Inactive) made changes -
            Status Reopen in Local [ 10018 ] In Development [ 10007 ]
            parmeshwar.jumbad Parmeshwar Jumbad (Inactive) made changes -
            Item State Parent values: LB QA(10201)Level 1 values: Re-open(10212) Parent values: Development(10200)Level 1 values: In Analysis(10204)
            khandu.kshirsagar Khandu Kshirsagar (Inactive) made changes -
            Item State Parent values: Development(10200)Level 1 values: In Analysis(10204) Parent values: Stage QA(10202)Level 1 values: Stage Deployed(11602)
            sachin.hingole Sachin Hingole (Inactive) made changes -
            Item State Parent values: Stage QA(10202)Level 1 values: Stage Deployed(11602) Parent values: Development(10200)Level 1 values: In Analysis(10204)
            parmeshwar.jumbad Parmeshwar Jumbad (Inactive) made changes -
            Assignee Parmeshwar Jumbad [ parmeshwar.jumbade ] Prasad Patil [ prasad.patil ]
            parmeshwar.jumbad Parmeshwar Jumbad (Inactive) made changes -
            Item State Parent values: Development(10200)Level 1 values: In Analysis(10204) Parent values: LB QA(10201)Level 1 values: LB Deployed(11600)
            parmeshwar.jumbad Parmeshwar Jumbad (Inactive) made changes -
            Remaining Estimate 27.75h [ 99900 ] 23.75h [ 85500 ]
            Time Spent 7.25h [ 26100 ] 11.25h [ 40500 ]
            Worklog Id 98259 [ 98259 ]
            parmeshwar.jumbad Parmeshwar Jumbad (Inactive) made changes -
            Link This issue is blocked by WT-9147 [ WT-9147 ]
            parmeshwar.jumbad Parmeshwar Jumbad (Inactive) made changes -
            Remaining Estimate 23.75h [ 85500 ] 18h [ 64800 ]
            Time Spent 11.25h [ 40500 ] 17h [ 61200 ]
            Worklog Id 98452 [ 98452 ]
            parmeshwar.jumbad Parmeshwar Jumbad (Inactive) made changes -
            Link This issue is blocked by WT-9147 [ WT-9147 ]
            parmeshwar.jumbad Parmeshwar Jumbad (Inactive) made changes -
            Assignee Prasad Patil [ prasad.patil ] Umesh Kadam [ umesh.kadam ]
            parmeshwar.jumbad Parmeshwar Jumbad (Inactive) made changes -
            Item State Parent values: LB QA(10201)Level 1 values: LB Deployed(11600) Parent values: Development(10200)Level 1 values: In Analysis(10204)
            parmeshwar.jumbad Parmeshwar Jumbad (Inactive) made changes -
            Remaining Estimate 18h [ 64800 ] 16h [ 57600 ]
            Time Spent 17h [ 61200 ] 19h [ 68400 ]
            Worklog Id 98769 [ 98769 ]
            umesh.kadam Umesh Kadam (Inactive) made changes -
            Developer Parmeshwar Jumbad [ parmeshwar.jumbade ] Umesh Kadam [ umesh.kadam ]
            snehal.shabade Snehal Shabade (Inactive) made changes -
            Assignee Umesh Kadam [ umesh.kadam ] Parmeshwar Jumbad [ parmeshwar.jumbade ]
            umesh.kadam Umesh Kadam (Inactive) made changes -
            Remaining Estimate 16h [ 57600 ] 14.5h [ 52200 ]
            Time Spent 19h [ 68400 ] 20.5h [ 73800 ]
            Worklog Id 99337 [ 99337 ]
            snehal.shabade Snehal Shabade (Inactive) made changes -
            Remaining Estimate 14.5h [ 52200 ] 12.5h [ 45000 ]
            Time Spent 20.5h [ 73800 ] 22.5h [ 81000 ]
            Worklog Id 99338 [ 99338 ]
            parmeshwar.jumbad Parmeshwar Jumbad (Inactive) made changes -
            Assignee Parmeshwar Jumbad [ parmeshwar.jumbade ] Prasad Patil [ prasad.patil ]
            parmeshwar.jumbad Parmeshwar Jumbad (Inactive) made changes -
            Remaining Estimate 12.5h [ 45000 ] 10h [ 36000 ]
            Time Spent 22.5h [ 81000 ] 25h [ 90000 ]
            Worklog Id 99607 [ 99607 ]
            snehal.shabade Snehal Shabade (Inactive) made changes -
            Remaining Estimate 10h [ 36000 ] 9.5h [ 34200 ]
            Time Spent 25h [ 90000 ] 25.5h [ 91800 ]
            Worklog Id 99610 [ 99610 ]
            prasad.patil Prasad Patil (Inactive) made changes -
            Status In Development [ 10007 ] Local Testing [ 10200 ]
            prasad.patil Prasad Patil (Inactive) made changes -
            Status Local Testing [ 10200 ] Stage Testing [ 10201 ]
            prasad.patil Prasad Patil (Inactive) made changes -
            Item State Parent values: Development(10200)Level 1 values: In Analysis(10204) Parent values: Stage QA(10202)
            prasad.patil Prasad Patil (Inactive) made changes -
            Item State Parent values: Stage QA(10202) Parent values: Stage QA(10202)Level 1 values: Production Deployment on Hold(10224)
            prasad.patil Prasad Patil (Inactive) made changes -
            Assignee Prasad Patil [ prasad.patil ] Parmeshwar Jumbad [ parmeshwar.jumbade ]
            hrishikesh.deshpande Hrishikesh Deshpande (Inactive) made changes -
            Assignee Parmeshwar Jumbad [ parmeshwar.jumbade ] Priya Dhamande [ priya.dhamande ]
            prasad.patil Prasad Patil (Inactive) made changes -
            Remaining Estimate 9.5h [ 34200 ] 8h [ 28800 ]
            Time Spent 25.5h [ 91800 ] 27h [ 97200 ]
            Worklog Id 99762 [ 99762 ]
            parmeshwar.jumbad Parmeshwar Jumbad (Inactive) made changes -
            Labels Static_Reports Sprint_41
            sanjana.jadhav Sanjana Jadhav (Inactive) made changes -
            Attachment NF-5533_2.png [ 74543 ]
            sanjana.jadhav Sanjana Jadhav (Inactive) made changes -
            Attachment NF-5533_1.png [ 74544 ]
            sanjana.jadhav Sanjana Jadhav (Inactive) made changes -
            Status Stage Testing [ 10201 ] Production Testing [ 10202 ]
            sanjana.jadhav Sanjana Jadhav (Inactive) made changes -
            Assignee Priya Dhamande [ priya.dhamande ] Yamilka Coca [ yamilka.coca ]
            sanjana.jadhav Sanjana Jadhav (Inactive) made changes -
            Remaining Estimate 8h [ 28800 ] 6.3h [ 22680 ]
            Time Spent 27h [ 97200 ] 28.7h [ 103320 ]
            Worklog Id 108099 [ 108099 ]
            sanjana.jadhav Sanjana Jadhav (Inactive) made changes -
            Resolution Bug Fixed [ 10402 ]
            Status Production Testing [ 10202 ] Production Complete [ 10028 ]
            sanjana.jadhav Sanjana Jadhav (Inactive) made changes -
            Status Production Complete [ 10028 ] Closed [ 6 ]

              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