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

Column-Wise Billing Report - Displayed blank effective date

    Details

    • Type: Bug
    • Status: Closed
    • Priority: Medium
    • Resolution: Bug Fixed
    • Affects Version/s: None
    • Fix Version/s: None
    • Component/s: BenAdmin
    • Labels:
    • Environment:
      Production, Stage, QA
    • Bug Type:
      Functional
    • Bug Severity:
      Medium
    • Level:
      Partner
    • Module:
      BenAdmin - Report
    • Reported by:
      Harbinger
    • Company:
      All Clients/Multiple Clients
    • Item State:
      LB QA - On Hold
    • Issue Importance:
      Must Have
    • Sprint:
      WT Sprint 37 - Bugs, WT Sprint 38 - Bugs

      Description

      Precondition :

      Create one Column-wise billing report like as :

      Replication Steps :
      1) Partner Login
      2) Navigate up to Billing Report
      3) Ran Report

      Issue : Displayed blank Enrollment Effective Date for particular plan. Extra column added at end of report to display effective date.

      CC - Sachin Hingole

        Attachments

        1. Fields.jpg
          Fields.jpg
          23 kB
        2. WT-10859_PROD_BillingReport.png
          WT-10859_PROD_BillingReport.png
          79 kB
        3. WT-10859.xls
          17 kB
        4. WT-10859.xls
          429 kB
        5. WT-10859.xls
          1.59 MB
        6. WT-10859 (c97352a5-72a8-4a47-9a02-2d725b57c4db).xls
          80 kB
        7. WT-10859-ETA.xls
          7 kB

          Activity

          meghana.joshi Meghana Joshi (Inactive) created issue -
          meghana.joshi Meghana Joshi (Inactive) made changes -
          Field Original Value New Value
          Link This issue relates to WT-8642 [ WT-8642 ]
          harshada.borole Harshada Borole (Inactive) made changes -
          Assignee Prasanna Karlekar [ prasanna ] Harshada Borole [ harshada.borole ]
          jyoti.agrawal Jyoti Agrawal (Inactive) made changes -
          Remaining Estimate 0h [ 0 ]
          Time Spent 0.5h [ 1800 ]
          Worklog Id 77699 [ 77699 ]
          harshada.borole Harshada Borole (Inactive) made changes -
          Developer Harshada Borole [ harshada.borole ]
          Remaining Estimate 0h [ 0 ]
          gaurav.sodani Gaurav Sodani (Inactive) made changes -
          Sprint WT Sprint 37 - Bugs [ 87 ]
          harshada.borole Harshada Borole (Inactive) made changes -
          Status Open [ 1 ] In Development [ 10007 ]
          harshada.borole Harshada Borole (Inactive) made changes -
          Item State Parent values: Development(10200)
          parmeshwar.jumbad Parmeshwar Jumbad (Inactive) made changes -
          Remaining Estimate 0h [ 0 ]
          Time Spent 0.5h [ 1800 ] 1.5h [ 5400 ]
          Worklog Id 78002 [ 78002 ]
          harshada.borole Harshada Borole (Inactive) made changes -
          Time Spent 1.5h [ 5400 ] 9.5h [ 34200 ]
          Worklog Id 78114 [ 78114 ]
          harshada.borole Harshada Borole (Inactive) made changes -
          Dev Due Date 12/Sep/2017
          Original Estimate 0h [ 0 ]
          harshada.borole Harshada Borole (Inactive) made changes -
          Code Review Date 13/Sep/2017
          Code Reviewed By Jyoti Agarwal [ 16704 ]
          khandu.kshirsagar Khandu Kshirsagar (Inactive) made changes -
          Item State Parent values: Development(10200) Parent values: LB QA(10201)Level 1 values: LB Deployed(11600)
          harshada.borole Harshada Borole (Inactive) made changes -
          Assignee Harshada Borole [ harshada.borole ] 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 -
          Assignee Sachin Hingole [ sachin.hingole ] Priya Handepatil [ priya.handepatil ]
          harshada.borole Harshada Borole (Inactive) made changes -
          Time Spent 9.5h [ 34200 ] 12h [ 43200 ]
          Worklog Id 78505 [ 78505 ]
          harshada.borole Harshada Borole (Inactive) made changes -
          Time Spent 12h [ 43200 ] 14h [ 50400 ]
          Worklog Id 78528 [ 78528 ]
          harshada.borole Harshada Borole (Inactive) made changes -
          Time Spent 14h [ 50400 ] 20h [ 72000 ]
          Worklog Id 78596 [ 78596 ]
          harshada.borole Harshada Borole (Inactive) made changes -
          Remaining Estimate 0h [ 0 ] 6h [ 21600 ]
          Time Spent 20h [ 72000 ] 14h [ 50400 ]
          Worklog Id 78596 [ 78596 ]
          Worklog Time Spent 6h [ 21600 ]
          harshada.borole Harshada Borole (Inactive) made changes -
          Remaining Estimate 6h [ 21600 ] 0h [ 0 ]
          Time Spent 14h [ 50400 ] 20h [ 72000 ]
          Worklog Id 78597 [ 78597 ]
          priya.handepatil Priya Handepatil (Inactive) made changes -
          Attachment WT-10859.xls [ 61447 ]
          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: Re-open(10212)
          priya.handepatil Priya Handepatil (Inactive) made changes -
          Assignee Priya Handepatil [ priya.handepatil ] Harshada Borole [ harshada.borole ]
          prasanna Prasanna Karlekar (Inactive) made changes -
          Attachment WT-10859_PROD_BillingReport.png [ 61461 ]
          prasanna Prasanna Karlekar (Inactive) made changes -
          Link This issue relates to WT-8642 [ WT-8642 ]
          priya.handepatil Priya Handepatil (Inactive) made changes -
          Time Spent 20h [ 72000 ] 21.3h [ 76680 ]
          Worklog Id 78727 [ 78727 ]
          jyoti.agrawal Jyoti Agrawal (Inactive) made changes -
          Time Spent 21.3h [ 76680 ] 21.8h [ 78480 ]
          Worklog Id 79037 [ 79037 ]
          jyoti.agrawal Jyoti Agrawal (Inactive) made changes -
          Time Spent 21.8h [ 78480 ] 22.8h [ 82080 ]
          Worklog Id 79062 [ 79062 ]
          prasanna Prasanna Karlekar (Inactive) made changes -
          Time Spent 22.8h [ 82080 ] 23.05h [ 82980 ]
          Worklog Id 79201 [ 79201 ]
          khandu.kshirsagar Khandu Kshirsagar (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)
          jyoti.agrawal Jyoti Agrawal (Inactive) made changes -
          Time Spent 23.05h [ 82980 ] 23.3h [ 83880 ]
          Worklog Id 79314 [ 79314 ]
          harshada.borole Harshada Borole (Inactive) made changes -
          Time Spent 23.3h [ 83880 ] 28.3h [ 101880 ]
          Worklog Id 79853 [ 79853 ]
          harshada.borole Harshada Borole (Inactive) made changes -
          Worklog Id 79853 [ 79853 ]
          harshada.borole Harshada Borole (Inactive) made changes -
          Time Spent 28.3h [ 101880 ] 29.3h [ 105480 ]
          Worklog Id 79854 [ 79854 ]
          harshada.borole Harshada Borole (Inactive) made changes -
          Assignee Harshada Borole [ harshada.borole ] Priya Handepatil [ priya.handepatil ]
          priya.handepatil Priya Handepatil (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.handepatil Priya Handepatil (Inactive) made changes -
          Attachment WT-10859.xls [ 62424 ]
          priya.handepatil Priya Handepatil (Inactive) made changes -
          Time Spent 29.3h [ 105480 ] 30.8h [ 110880 ]
          Worklog Id 80565 [ 80565 ]
          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: Re-open(10212)
          priya.handepatil Priya Handepatil (Inactive) made changes -
          Status Local Testing [ 10200 ] Reopen in Local [ 10018 ]
          priya.handepatil Priya Handepatil (Inactive) made changes -
          Assignee Priya Handepatil [ priya.handepatil ] Harshada Borole [ harshada.borole ]
          harshada.borole Harshada Borole (Inactive) made changes -
          Time Spent 30.8h [ 110880 ] 31.8h [ 114480 ]
          Worklog Id 80574 [ 80574 ]
          jyoti.agrawal Jyoti Agrawal (Inactive) made changes -
          Time Spent 31.8h [ 114480 ] 32.8h [ 118080 ]
          Worklog Id 80669 [ 80669 ]
          prasanna Prasanna Karlekar (Inactive) made changes -
          Status Reopen in Local [ 10018 ] In Development [ 10007 ]
          gaurav.sodani Gaurav Sodani (Inactive) made changes -
          Sprint WT Sprint 37 - Bugs [ 87 ] WT Sprint 37 - Bugs, WT Sprint 38 - Bugs [ 87, 89 ]
          harshada.borole Harshada Borole (Inactive) made changes -
          Attachment WT-10859-ETA.xls [ 62711 ]
          harshada.borole Harshada Borole (Inactive) made changes -
          Dev Due Date 12/Sep/2017 29/Sep/2017
          prasanna Prasanna Karlekar (Inactive) made changes -
          Time Spent 32.8h [ 118080 ] 33.05h [ 118980 ]
          Worklog Id 81415 [ 81415 ]
          parmeshwar.jumbad Parmeshwar Jumbad (Inactive) made changes -
          Time Spent 33.05h [ 118980 ] 34.05h [ 122580 ]
          Worklog Id 81558 [ 81558 ]
          harshada.borole Harshada Borole (Inactive) made changes -
          Time Spent 34.05h [ 122580 ] 35.05h [ 126180 ]
          Worklog Id 81592 [ 81592 ]
          jyoti.agrawal Jyoti Agrawal (Inactive) made changes -
          Time Spent 35.05h [ 126180 ] 35.55h [ 127980 ]
          Worklog Id 81687 [ 81687 ]
          harshada.borole Harshada Borole (Inactive) made changes -
          Item State Parent values: LB QA(10201)Level 1 values: Re-open(10212) Parent values: Development(10200)
          prasanna Prasanna Karlekar (Inactive) made changes -
          Code Review Date 13/Sep/2017
          prasanna Prasanna Karlekar (Inactive) made changes -
          Dev Estimates 16
          harshada.borole Harshada Borole (Inactive) made changes -
          Time Spent 35.55h [ 127980 ] 39.55h [ 142380 ]
          Worklog Id 82027 [ 82027 ]
          harshada.borole Harshada Borole (Inactive) made changes -
          Remaining Estimate 0h [ 0 ] 1h [ 3600 ]
          Time Spent 39.55h [ 142380 ] 38.55h [ 138780 ]
          Worklog Id 82027 [ 82027 ]
          harshada.borole Harshada Borole (Inactive) made changes -
          Remaining Estimate 1h [ 3600 ] 0h [ 0 ]
          Time Spent 38.55h [ 138780 ] 46.05h [ 165780 ]
          Worklog Id 82427 [ 82427 ]
          harshada.borole Harshada Borole (Inactive) made changes -
          Code Review Date 29/Sep/2017
          jyoti.agrawal Jyoti Agrawal (Inactive) made changes -
          Item State Parent values: Development(10200) Parent values: Development(10200)Level 1 values: Ready for Local Testing(10209)
          prasanna Prasanna Karlekar (Inactive) made changes -
          Time Spent 46.05h [ 165780 ] 46.55h [ 167580 ]
          Worklog Id 82730 [ 82730 ]
          prasanna Prasanna Karlekar (Inactive) made changes -
          Time Spent 46.55h [ 167580 ] 47.05h [ 169380 ]
          Worklog Id 82767 [ 82767 ]
          harshada.borole Harshada Borole (Inactive) made changes -
          Time Spent 47.05h [ 169380 ] 52.05h [ 187380 ]
          Worklog Id 82783 [ 82783 ]
          jyoti.agrawal Jyoti Agrawal (Inactive) made changes -
          Time Spent 52.05h [ 187380 ] 53.05h [ 190980 ]
          Worklog Id 82809 [ 82809 ]
          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)
          priya.handepatil Priya Handepatil (Inactive) made changes -
          Status In Development [ 10007 ] Local Testing [ 10200 ]
          harshada.borole Harshada Borole (Inactive) made changes -
          Assignee Harshada Borole [ harshada.borole ] Priya Handepatil [ priya.handepatil ]
          priya.handepatil Priya Handepatil (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.handepatil Priya Handepatil (Inactive) made changes -
          Attachment WT-10859.xls [ 63414 ]
          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 53.05h [ 190980 ] 53.8h [ 193680 ]
          Worklog Id 83158 [ 83158 ]
          priya.handepatil Priya Handepatil (Inactive) made changes -
          Production Due Date 12/Oct/2017
          Stage Due Date 9/Oct/17 [ 2017-10-09 ]
          harshada.borole Harshada Borole (Inactive) made changes -
          Status Local Testing [ 10200 ] Stage Testing [ 10201 ]
          harshada.borole Harshada Borole (Inactive) made changes -
          Time Spent 53.8h [ 193680 ] 58.8h [ 211680 ]
          Worklog Id 83467 [ 83467 ]
          harshada.borole Harshada Borole (Inactive) made changes -
          Worklog Id 83467 [ 83467 ]
          harshada.borole Harshada Borole (Inactive) made changes -
          Remaining Estimate 0h [ 0 ] 4.5h [ 16200 ]
          Time Spent 58.8h [ 211680 ] 54.3h [ 195480 ]
          Worklog Id 83467 [ 83467 ]
          rakeshr Rakesh Roy (Inactive) made changes -
          Resolution Unresolved [ 10200 ]
          Status Stage Testing [ 10201 ] Reopen in Stage [ 10023 ]
          rakeshr Rakesh Roy (Inactive) made changes -
          Status Reopen in Stage [ 10023 ] In Development [ 10007 ]
          rakeshr Rakesh Roy (Inactive) made changes -
          Status In Development [ 10007 ] Local Testing [ 10200 ]
          rakeshr Rakesh Roy (Inactive) made changes -
          QA Priya Handepatil [ priya.handepatil ]
          priya.handepatil Priya Handepatil (Inactive) made changes -
          Stage Due Date 9/Oct/17 [ 2017-10-09 ] 23/Oct/17 [ 2017-10-23 ]
          priya.handepatil Priya Handepatil (Inactive) made changes -
          Production Due Date 12/Oct/2017 25/Oct/2017
          priya.handepatil Priya Handepatil (Inactive) made changes -
          priya.handepatil Priya Handepatil (Inactive) made changes -
          Remaining Estimate 4.5h [ 16200 ] 4h [ 14400 ]
          Time Spent 54.3h [ 195480 ] 54.8h [ 197280 ]
          Worklog Id 85851 [ 85851 ]
          harshada.borole Harshada Borole (Inactive) made changes -
          Remaining Estimate 4h [ 14400 ] 3h [ 10800 ]
          Time Spent 54.8h [ 197280 ] 55.8h [ 200880 ]
          Worklog Id 88465 [ 88465 ]
          satyap Satya made changes -
          Labels Billing
          satyap Satya made changes -
          Environment_New LB [ 18444 ]
          gaurav.sodani Gaurav Sodani (Inactive) made changes -
          Item State Parent values: LB QA(10201)Level 1 values: Ready for Stage(10213) Parent values: LB QA(10201)Level 1 values: On Hold(10211)
          gaurav.sodani Gaurav Sodani (Inactive) made changes -
          Company All Clients/Multiple Clients [ 18434 ]
          gaurav.sodani Gaurav Sodani (Inactive) made changes -
          Environment LB [ 18444 ] Production,Stage,LB [ 18442, 18443, 18444 ]
          rakeshr Rakesh Roy (Inactive) made changes -
          Assignee Priya Handepatil [ priya.handepatil ] Venkatesh Pujari [ venkatesh.pujari ]
          venkatesh.pujari Venkatesh Pujari (Inactive) made changes -
          Status In LB Testing [ 10200 ] Stage Testing [ 10201 ]
          venkatesh.pujari Venkatesh Pujari (Inactive) made changes -
          Status Stage Testing [ 10201 ] Production Testing [ 10202 ]
          venkatesh.pujari Venkatesh Pujari (Inactive) made changes -
          Resolution Unresolved [ 10200 ] Bug Fixed [ 10402 ]
          Status Production Testing [ 10202 ] Production Complete [ 10028 ]
          venkatesh.pujari Venkatesh Pujari (Inactive) made changes -
          Status Production Complete [ 10028 ] Closed [ 6 ]

            People

            Assignee:
            venkatesh.pujari Venkatesh Pujari (Inactive)
            Reporter:
            meghana.joshi Meghana Joshi (Inactive)
            Developer:
            Harshada Borole (Inactive)
            QA:
            Priya Handepatil (Inactive)
            Votes:
            0 Vote for this issue
            Watchers:
            4 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 - 0h
                0h
                Remaining:
                Time Spent - 55.8h Remaining Estimate - 3h
                3h
                Logged:
                Time Spent - 55.8h Remaining Estimate - 3h
                55.8h