WORKTERRAProject Type: software

WORKTERRA

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
          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. BasicAD&D_ratCal_OK.jpg
          BasicAD&D_ratCal_OK.jpg
          159 kB
        6. BasicLife_ratCal_OK.jpg
          BasicLife_ratCal_OK.jpg
          166 kB
        7. BillingSummaryReport.xls
          12 kB
        8. FW 1211 Sprint - Development Approval.msg
          51 kB
        9. 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
        10. Superheat - Billing Summary Report - Calc is not correct - Child Life.PNG
          Superheat - Billing Summary Report - Calc is not correct - Child Life.PNG
          57 kB
        11. VolChildLife_ratCal_OK.jpg
          VolChildLife_ratCal_OK.jpg
          156 kB
        12. WT-11470_Discrepancy.xlsx
          21 kB
        13. WT-11470.jpg
          WT-11470.jpg
          256 kB
        14. 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
          is cloned by

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

          • Medium - Has the potential to affect progress.
          • Closed

            Activity

            Ascending order - Click to sort in descending order
            Yamilka.Coca Yamilka Coca (Inactive) created issue -
            venkatesh.pujari Venkatesh Pujari (Inactive) made changes -
            Field Original Value New Value
            Assignee Vijay Siddha [ vijays ] Prasanna Karlekar [ prasanna ]
            prasadp Prasad Pise (Inactive) made changes -
            Module Parent values: BenAdmin(10100) Parent values: BenAdmin(10100)Level 1 values: Report(10109)
            prasanna Prasanna Karlekar (Inactive) made changes -
            Status Open [ 1 ] In Development [ 10007 ]
            prasanna Prasanna Karlekar (Inactive) made changes -
            Item State Parent values: Development(10200)Level 1 values: In Analysis(10204)
            prasanna Prasanna Karlekar (Inactive) made changes -
            Attachment WT-11470_Discrepancy.xlsx [ 64064 ]
            prasanna Prasanna Karlekar (Inactive) made changes -
            Dev Due Date 01/Nov/2017
            gaurav.sodani Gaurav Sodani (Inactive) made changes -
            Sprint WT Sprint 40 - Bugs [ 94 ]
            jyoti.agrawal Jyoti Agrawal (Inactive) made changes -
            Dev Estimates 35
            jyoti.agrawal Jyoti Agrawal (Inactive) made changes -
            Remaining Estimate 35h [ 126000 ]
            Original Estimate 35h [ 126000 ]
            prasanna Prasanna Karlekar (Inactive) made changes -
            Assignee Prasanna Karlekar [ prasanna ] Parmeshwar Jumbad [ parmeshwar.jumbade ]
            prasanna Prasanna Karlekar (Inactive) made changes -
            Company All Clients/Multiple Clients [ 18434 ]
            Developer Parmeshwar Jumbad [ parmeshwar.jumbade ]
            prasanna Prasanna Karlekar (Inactive) made changes -
            Code Reviewed By Parmeshwar Jumbad [ 17800 ]
            prasanna Prasanna Karlekar (Inactive) made changes -
            Remaining Estimate 35h [ 126000 ] 32.75h [ 117900 ]
            Time Spent 2.25h [ 8100 ]
            Worklog Id 86485 [ 86485 ]
            prasanna Prasanna Karlekar (Inactive) made changes -
            Remaining Estimate 32.75h [ 117900 ] 31.75h [ 114300 ]
            Time Spent 2.25h [ 8100 ] 3.25h [ 11700 ]
            Worklog Id 86489 [ 86489 ]
            prasanna Prasanna Karlekar (Inactive) made changes -
            Remaining Estimate 31.75h [ 114300 ] 30.25h [ 108900 ]
            Time Spent 3.25h [ 11700 ] 4.75h [ 17100 ]
            Worklog Id 86559 [ 86559 ]
            prasanna Prasanna Karlekar (Inactive) made changes -
            Remaining Estimate 30.25h [ 108900 ] 29.5h [ 106200 ]
            Time Spent 4.75h [ 17100 ] 5.5h [ 19800 ]
            Worklog Id 86617 [ 86617 ]
            parmeshwar.jumbad Parmeshwar Jumbad (Inactive) made changes -
            Root Cause Bug [ 18430 ]
            prasanna Prasanna Karlekar (Inactive) made changes -
            Item State Parent values: Development(10200)Level 1 values: In Analysis(10204) Parent values: Development(10200)Level 1 values: In Progress(10206)
            parmeshwar.jumbad Parmeshwar Jumbad (Inactive) made changes -
            Remaining Estimate 29.5h [ 106200 ] 20.5h [ 73800 ]
            Time Spent 5.5h [ 19800 ] 14.5h [ 52200 ]
            Worklog Id 87079 [ 87079 ]
            parmeshwar.jumbad Parmeshwar Jumbad (Inactive) made changes -
            Remaining Estimate 20.5h [ 73800 ] 12.75h [ 45900 ]
            Time Spent 14.5h [ 52200 ] 22.25h [ 80100 ]
            Worklog Id 87082 [ 87082 ]
            parmeshwar.jumbad Parmeshwar Jumbad (Inactive) made changes -
            Remaining Estimate 12.75h [ 45900 ] 5.75h [ 20700 ]
            Time Spent 22.25h [ 80100 ] 29.25h [ 105300 ]
            Worklog Id 87083 [ 87083 ]
            parmeshwar.jumbad Parmeshwar Jumbad (Inactive) made changes -
            Remaining Estimate 5.75h [ 20700 ] 6.75h [ 24300 ]
            Time Spent 29.25h [ 105300 ] 28.25h [ 101700 ]
            Worklog Id 87083 [ 87083 ]
            parmeshwar.jumbad Parmeshwar Jumbad (Inactive) made changes -
            Remaining Estimate 6.75h [ 24300 ] 0h [ 0 ]
            Time Spent 28.25h [ 101700 ] 36.25h [ 130500 ]
            Worklog Id 87745 [ 87745 ]
            parmeshwar.jumbad Parmeshwar Jumbad (Inactive) made changes -
            Item State Parent values: Development(10200)Level 1 values: In Progress(10206) Parent values: Development(10200)Level 1 values: Ready for Review(10208)
            parmeshwar.jumbad Parmeshwar Jumbad (Inactive) made changes -
            Assignee Parmeshwar Jumbad [ parmeshwar.jumbade ] Prasanna Karlekar [ prasanna ]
            prasanna Prasanna Karlekar (Inactive) made changes -
            Time Spent 36.25h [ 130500 ] 37h [ 133200 ]
            Worklog Id 88255 [ 88255 ]
            prasanna Prasanna Karlekar (Inactive) made changes -
            Item State Parent values: Development(10200)Level 1 values: Ready for Review(10208) Parent values: Development(10200)Level 1 values: Ready for Local Testing(10209)
            prasanna Prasanna Karlekar (Inactive) made changes -
            Assignee Prasanna Karlekar [ prasanna ] Parmeshwar Jumbad [ parmeshwar.jumbade ]
            prasanna Prasanna Karlekar (Inactive) made changes -
            Time Spent 37h [ 133200 ] 38.5h [ 138600 ]
            Worklog Id 88360 [ 88360 ]
            parmeshwar.jumbad Parmeshwar Jumbad (Inactive) made changes -
            Code Review Date 30/Oct/2017
            Code Reviewed By Parmeshwar Jumbad [ 17800 ] Prasanna Karlekar [ 11907 ]
            Environment_New Production [ 18442 ]
            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 ]
            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)
            sachin.hingole Sachin Hingole (Inactive) made changes -
            Account Executive Yamilka Coca [ yamilka.coca ]
            Assignee Sachin Hingole [ sachin.hingole ] Priya Handepatil [ priya.handepatil ]
            Production Due Date 09/Nov/2017
            QA Priya Handepatil [ priya.handepatil ]
            Stage Due Date 6/Nov/17 [ 2017-11-06 ]
            parmeshwar.jumbad Parmeshwar Jumbad (Inactive) made changes -
            Labels Standard_Report
            parmeshwar.jumbad Parmeshwar Jumbad (Inactive) made changes -
            Labels Standard_Report Static_Reports
            priya.handepatil Priya Handepatil (Inactive) made changes -
            Time Spent 38.5h [ 138600 ] 39.5h [ 142200 ]
            Worklog Id 88857 [ 88857 ]
            parmeshwar.jumbad Parmeshwar Jumbad (Inactive) made changes -
            Time Spent 39.5h [ 142200 ] 39.75h [ 143100 ]
            Worklog Id 88913 [ 88913 ]
            priya.handepatil Priya Handepatil (Inactive) made changes -
            Attachment BillingSummaryReport.xls [ 67024 ]
            priya.handepatil Priya Handepatil (Inactive) made changes -
            Attachment WT-11470.jpg [ 67025 ]
            priya.handepatil Priya Handepatil (Inactive) made changes -
            Item State Parent values: LB QA(10201)Level 1 values: In Testing(10210) Parent values: LB QA(10201)Level 1 values: Ready for Stage(10213)
            priya.handepatil Priya Handepatil (Inactive) made changes -
            Time Spent 39.75h [ 143100 ] 41.75h [ 150300 ]
            Worklog Id 89452 [ 89452 ]
            sanjana.jadhav Sanjana Jadhav (Inactive) made changes -
            Item State Parent values: LB QA(10201)Level 1 values: Ready for Stage(10213) Parent values: Stage QA(10202)Level 1 values: In Testing(10214)
            sanjana.jadhav Sanjana Jadhav (Inactive) made changes -
            Status Local Testing [ 10200 ] Stage Testing [ 10201 ]
            sanjana.jadhav Sanjana Jadhav (Inactive) made changes -
            Attachment 1.png [ 67489 ]
            sanjana.jadhav Sanjana Jadhav (Inactive) made changes -
            Attachment 2.png [ 67490 ]
            sanjana.jadhav Sanjana Jadhav (Inactive) made changes -
            Attachment 3.png [ 67491 ]
            sanjana.jadhav Sanjana Jadhav (Inactive) made changes -
            Attachment 4.png [ 67492 ]
            sanjana.jadhav Sanjana Jadhav (Inactive) made changes -
            Item State Parent values: Stage QA(10202)Level 1 values: In Testing(10214) Parent values: Stage QA(10202)Level 1 values: Re-open(10216)
            sanjana.jadhav Sanjana Jadhav (Inactive) made changes -
            Resolution Unresolved [ 10200 ]
            Status Stage Testing [ 10201 ] Reopen in Stage [ 10023 ]
            sanjana.jadhav Sanjana Jadhav (Inactive) made changes -
            Assignee Priya Handepatil [ priya.handepatil ] Prasanna Karlekar [ prasanna ]
            sanjana.jadhav Sanjana Jadhav (Inactive) made changes -
            Time Spent 41.75h [ 150300 ] 43.45h [ 156420 ]
            Worklog Id 90296 [ 90296 ]
            sanjana.jadhav Sanjana Jadhav (Inactive) made changes -
            Time Spent 43.45h [ 156420 ] 43.75h [ 157500 ]
            Worklog Id 90296 [ 90296 ]
            ramya.tantry Ramya Tantry (Inactive) made changes -
            Link This issue causes WT-12096 [ WT-12096 ]
            khandu.kshirsagar Khandu Kshirsagar (Inactive) made changes -
            Item State Parent values: Stage QA(10202)Level 1 values: Re-open(10216) Parent values: Stage QA(10202)Level 1 values: Stage Deployed(11602)
            sanjana.jadhav Sanjana Jadhav (Inactive) made changes -
            Item State Parent values: Stage QA(10202)Level 1 values: Stage Deployed(11602) Parent values: Stage QA(10202)Level 1 values: Re-open(10216)
            parmeshwar.jumbad Parmeshwar Jumbad (Inactive) made changes -
            Assignee Prasanna Karlekar [ prasanna ] Sanjana Jadhav [ sanjana.jadhav ]
            parmeshwar.jumbad Parmeshwar Jumbad (Inactive) made changes -
            Status Reopen in Stage [ 10023 ] In Development [ 10007 ]
            parmeshwar.jumbad Parmeshwar Jumbad (Inactive) made changes -
            Status In Development [ 10007 ] Local Testing [ 10200 ]
            parmeshwar.jumbad Parmeshwar Jumbad (Inactive) made changes -
            Status Local Testing [ 10200 ] Stage Testing [ 10201 ]
            parmeshwar.jumbad Parmeshwar Jumbad (Inactive) made changes -
            Item State Parent values: Stage QA(10202)Level 1 values: Re-open(10216) Parent values: Stage QA(10202)Level 1 values: Stage Deployed(11602)
            parmeshwar.jumbad Parmeshwar Jumbad (Inactive) made changes -
            Time Spent 43.75h [ 157500 ] 44.25h [ 159300 ]
            Worklog Id 90345 [ 90345 ]
            sanjana.jadhav Sanjana Jadhav (Inactive) made changes -
            Item State Parent values: Stage QA(10202)Level 1 values: Stage Deployed(11602) Parent values: Stage QA(10202)Level 1 values: Ready for Production(10217)
            gaurav.sodani Gaurav Sodani (Inactive) made changes -
            Item State Parent values: Stage QA(10202)Level 1 values: Ready for Production(10217) Parent values: Stage QA(10202)Level 1 values: On Hold(10215)
            gaurav.sodani Gaurav Sodani (Inactive) made changes -
            Approval status Need approval for production [ 18456 ]
            gaurav.sodani Gaurav Sodani (Inactive) made changes -
            Sprint WT Sprint 40 - Bugs [ 94 ] WT Sprint 41 - Bugs [ 95 ]
            gaurav.sodani Gaurav Sodani (Inactive) made changes -
            Production Due Date 09/Nov/2017
            gaurav.sodani Gaurav Sodani (Inactive) made changes -
            Stage Due Date 6/Nov/17 [ 2017-11-06 ]
            gaurav.sodani Gaurav Sodani (Inactive) made changes -
            Sprint WT Sprint 41 - Bugs [ 95 ]
            gaurav.sodani Gaurav Sodani (Inactive) made changes -
            Sprint WT Sprint 41 - Bugs [ 95 ]
            hrishikesh.deshpande Hrishikesh Deshpande (Inactive) made changes -
            QA Priya Handepatil [ priya.handepatil ] Meghana Joshi [ meghana.kulkarni ]
            QA Estimates 4
            gaurav.sodani Gaurav Sodani (Inactive) made changes -
            Approval status Need approval for production [ 18456 ] Approved for development [ 18453 ]
            Development Approval Yes [ 18474 ]
            gaurav.sodani Gaurav Sodani (Inactive) made changes -
            Stage Due Date 22/Dec/17 [ 2017-12-22 ]
            gaurav.sodani Gaurav Sodani (Inactive) made changes -
            Attachment FW 1211 Sprint - Development Approval.msg [ 69878 ]
            meghana.joshi Meghana Joshi (Inactive) made changes -
            Attachment WT-11470 - Superheat - Billing Summary Report_Test Scenarios.xls [ 69967 ]
            meghana.joshi Meghana Joshi (Inactive) made changes -
            Time Spent 44.25h [ 159300 ] 48.25h [ 173700 ]
            Worklog Id 95909 [ 95909 ]
            meghana.joshi Meghana Joshi (Inactive) made changes -
            Attachment WT-11470 - Superheat - Billing Summary Report_Test Scenarios.xls [ 69967 ]
            parmeshwar.jumbad Parmeshwar Jumbad (Inactive) made changes -
            Time Spent 48.25h [ 173700 ] 48.5h [ 174600 ]
            Worklog Id 96021 [ 96021 ]
            sanjana.jadhav Sanjana Jadhav (Inactive) made changes -
            Time Spent 48.5h [ 174600 ] 49h [ 176400 ]
            Worklog Id 96258 [ 96258 ]
            sanjana.jadhav Sanjana Jadhav (Inactive) made changes -
            Time Spent 49h [ 176400 ] 49.5h [ 178200 ]
            Worklog Id 96259 [ 96259 ]
            meghana.joshi Meghana Joshi (Inactive) made changes -
            QA Meghana Joshi [ meghana.kulkarni ] Sanjana Jadhav [ sanjana.jadhav ]
            hrishikesh.deshpande Hrishikesh Deshpande (Inactive) made changes -
            Item State Parent values: Stage QA(10202)Level 1 values: On Hold(10215) Parent values: Stage QA(10202)Level 1 values: Ready for Production(10217)
            parmeshwar.jumbad Parmeshwar Jumbad (Inactive) made changes -
            Link This issue is cloned by WT-12815 [ WT-12815 ]
            gaurav.sodani Gaurav Sodani (Inactive) made changes -
            Deployment Approval Approved for stage deployment [ 18455 ]
            Production Due Date 29/Dec/2017
            khandu.kshirsagar Khandu Kshirsagar (Inactive) made changes -
            Item State Parent values: Stage QA(10202)Level 1 values: Ready for Production(10217) Parent values: Production QA(10203)Level 1 values: Production Deployed(10221)
            gaurav.sodani Gaurav Sodani (Inactive) made changes -
            Comments Hi All,

            Following point has been approved for production deployment on 12/29

            Regards
            Gaurav
            Deployment Approval Approved for stage deployment [ 18455 ] Approved for production deployment [ 18457 ]
            prasadp Prasad Pise (Inactive) made changes -
            Status Stage Testing [ 10201 ] Production Testing [ 10202 ]
            prasadp Prasad Pise (Inactive) made changes -
            Item State Parent values: Production QA(10203)Level 1 values: Production Deployed(10221) Parent values: Production QA(10203)Level 1 values: In Testing(10218)
            prasadp Prasad Pise (Inactive) made changes -
            Attachment BasicAD&D_ratCal_OK.jpg [ 70994 ]
            prasadp Prasad Pise (Inactive) made changes -
            Attachment VolChildLife_ratCal_OK.jpg [ 70995 ]
            prasadp Prasad Pise (Inactive) made changes -
            Attachment BasicLife_ratCal_OK.jpg [ 70996 ]
            prasadp Prasad Pise (Inactive) made changes -
            Time Spent 49.5h [ 178200 ] 51.5h [ 185400 ]
            Worklog Id 98827 [ 98827 ]
            sanjana.jadhav Sanjana Jadhav (Inactive) made changes -
            Item State Parent values: Production QA(10203)Level 1 values: In Testing(10218) Parent values: Production Complete(10222)Level 1 values: Closed(10223)
            sanjana.jadhav Sanjana Jadhav (Inactive) made changes -
            Assignee Sanjana Jadhav [ sanjana.jadhav ] Yamilka Coca [ yamilka.coca ]
            sanjana.jadhav Sanjana Jadhav (Inactive) made changes -
            Resolution Unresolved [ 10200 ] Fixed [ 1 ]
            Status Production Testing [ 10202 ] Production Complete [ 10028 ]
            sanjana.jadhav Sanjana Jadhav (Inactive) made changes -
            Status Production Complete [ 10028 ] Closed [ 6 ]
            parmeshwar.jumbad Parmeshwar Jumbad (Inactive) made changes -
            Link This issue relates to WT-13060 [ WT-13060 ]

              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