WORKTERRAProject Type: software

WORKTERRA

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

WT -> BCC Invoice Enhancement -> Same month billing and adjustment | Positive Negative Costs Sequence | Duplicate entries

    Details

    • Type: Change Request
    • Status: Closed
    • Priority: Medium
    • Resolution: Done
    • Affects Version/s: None
    • Fix Version/s: None
    • Component/s: BenAdmin
    • Labels:
      None
    • Module:
      BenAdmin - Report
    • Reported by:
      Harbinger
    • Item State:
      Production Complete - Closed
    • Sprint:
      WT Sprint 27

      Description

      Plan- Vision
      Rate - mapped rate has billed Rate (16)

      • enrollment exists from 09/01/2016 to 12/31/2016
      • fetched invoices for Sept Oct Nov 2016 - worked expected [showed billed rate costs ie, 16 in all months billing data]
      • changed billed rate value from 16 to 20
      • fetched invoice for Dec 2016 & below are the issues -
      1. though the invoice is for Dec 2016 : adjustments are also shown for the same month ie, Dec 2016 [this is not dependent on the Billing Period Policies flag on general plan design - checked]
      2. the positive and negative adjustments shown for the same month should be in same order. We can keep it as Positive first and then the Negative ones
      3. In case of enrollments in multiple plans within a benefit type - as discussed with Prasanna we are showing the only latest enrollments. Here system shown the duplicate records

      CC - Deepali Tidke Venkatesh PujariRakesh Roy Hrishikesh Deshpande

        Attachments

        1. #21.xlsx
          324 kB
        2. 7257 change rquest .doc
          42 kB
        3. Duplicate Entries.png
          Duplicate Entries.png
          141 kB
        4. Pos Neg Alternate.png
          Pos Neg Alternate.png
          138 kB
        5. Same Month Adjustment.png
          Same Month Adjustment.png
          89 kB

          Issue Links

          relates to

          Enhancement - An improvement or enhancement to an existing feature or task. WT-6331 BCC Invoice Management - Adjustments in future Invoice

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

            Activity

            Ascending order - Click to sort in descending order
            alankar.chavan Alankar Chavan (Inactive) created issue -
            alankar.chavan Alankar Chavan (Inactive) made changes -
            Field Original Value New Value
            Link This issue relates to WT-6331 [ WT-6331 ]
            alankar.chavan Alankar Chavan (Inactive) made changes -
            Attachment #21.xlsx [ 35434 ]
            Permalink
            prasanna Prasanna Karlekar (Inactive) logged work - 20/Dec/16 02:34 PM
            • Time Spent:
              0.5h
               

              Issue discussion.

            prasanna Prasanna Karlekar (Inactive) made changes -
            Remaining Estimate 6h [ 21600 ] 5.5h [ 19800 ]
            Time Spent 0.5h [ 1800 ]
            Worklog Id 14572 [ 14572 ]
            prasanna Prasanna Karlekar (Inactive) made changes -
            Assignee Prasanna Karlekar [ prasanna ] Jyoti Agrawal [ jyoti.agrawal ]
            Permalink
            jyoti.agrawal Jyoti Agrawal (Inactive) logged work - 21/Dec/16 01:39 PM
            • Time Spent:
              4h
               

              Analysis for Point 1 and 2, Discussion, Coding

            jyoti.agrawal Jyoti Agrawal (Inactive) made changes -
            Remaining Estimate 5.5h [ 19800 ] 1.5h [ 5400 ]
            Time Spent 0.5h [ 1800 ] 4.5h [ 16200 ]
            Worklog Id 14803 [ 14803 ]
            Permalink
            prasanna Prasanna Karlekar (Inactive) logged work - 22/Dec/16 10:30 PM
            • Time Spent:
              0.75h
               

              Discussion and issue resolution on positive/negative cost sequence for Adjustments.
              Issue not resolved.

            prasanna Prasanna Karlekar (Inactive) made changes -
            Remaining Estimate 1.5h [ 5400 ] 0.75h [ 2700 ]
            Time Spent 4.5h [ 16200 ] 5.25h [ 18900 ]
            Worklog Id 15407 [ 15407 ]
            prasanna Prasanna Karlekar (Inactive) made changes -
            Environment LB [ 10800 ]
            Issue Type Bug [ 1 ] Change Request [ 10002 ]
            Status Open [ 1 ] New Request [ 10029 ]
            Workflow WT_Defects [ 29219 ] WT_Features [ 29691 ]
            Hide
            Permalink
            prasanna Prasanna Karlekar (Inactive) added a comment -

            Making this as change/request, as following was not considered:

            • Sequence of adjustments
            • Enrollments in multiple plans within a benefit type
            Show
            prasanna Prasanna Karlekar (Inactive) added a comment - Making this as change/request, as following was not considered: Sequence of adjustments Enrollments in multiple plans within a benefit type
            Permalink
            jyoti.agrawal Jyoti Agrawal (Inactive) logged work - 22/Feb/17 06:41 PM
            • Time Spent:
              1h
               

              Verification

            jyoti.agrawal Jyoti Agrawal (Inactive) made changes -
            Remaining Estimate 0.75h [ 2700 ] 0h [ 0 ]
            Time Spent 5.25h [ 18900 ] 6.25h [ 22500 ]
            Worklog Id 27041 [ 27041 ]
            satyap Satya made changes -
            Sprint WT Sprint 27 [ 52 ]
            jyoti.agrawal Jyoti Agrawal (Inactive) made changes -
            Dev Estimates 30
            jyoti.agrawal Jyoti Agrawal (Inactive) made changes -
            Dev Due Date 21/Apr/2017
            jyoti.agrawal Jyoti Agrawal (Inactive) made changes -
            Status New Request [ 10029 ] Pending for Approval [ 10002 ]
            jyoti.agrawal Jyoti Agrawal (Inactive) made changes -
            Status Pending for Approval [ 10002 ] Approved for Development [ 10003 ]
            jyoti.agrawal Jyoti Agrawal (Inactive) made changes -
            Status Approved for Development [ 10003 ] In Development [ 10007 ]
            Permalink
            jyoti.agrawal Jyoti Agrawal (Inactive) logged work - 17/Apr/17 01:26 PM
            • Time Spent:
              6h
               

              coding, discussion,testing

            Permalink
            prasanna Prasanna Karlekar (Inactive) logged work - 17/Apr/17 10:30 PM
            • Time Spent:
              0.75h
               

              Scenario discussion
              Discussion on pulling records for returns to be done

            prasanna Prasanna Karlekar (Inactive) made changes -
            Time Spent 6.25h [ 22500 ] 7h [ 25200 ]
            Worklog Id 38878 [ 38878 ]
            Permalink
            jyoti.agrawal Jyoti Agrawal (Inactive) logged work - 18/Apr/17 03:45 PM - edited
            • Time Spent:
              2h
               

              Unit testing

            Permalink
            prasanna Prasanna Karlekar (Inactive) logged work - 19/Apr/17 12:30 AM
            • Time Spent:
              0.75h
               

              Issue discussion on scenario:
              Mid month Tier change and latter cost changes for both elections

            prasanna Prasanna Karlekar (Inactive) made changes -
            Time Spent 7h [ 25200 ] 7.75h [ 27900 ]
            Worklog Id 39156 [ 39156 ]
            jyoti.agrawal Jyoti Agrawal (Inactive) made changes -
            Attachment 7257 change rquest .doc [ 45813 ]
            Permalink
            jyoti.agrawal Jyoti Agrawal (Inactive) logged work - 19/Apr/17 12:06 PM
            • Time Spent:
              5h
               

              Testing, documentation, code review

            jyoti.agrawal Jyoti Agrawal (Inactive) made changes -
            Time Spent 7.75h [ 27900 ] 12.75h [ 45900 ]
            Worklog Id 39308 [ 39308 ]
            jyoti.agrawal Jyoti Agrawal (Inactive) made changes -
            Item State Parent values: Development(10200)Level 1 values: Ready for Review(10208)
            jyoti.agrawal Jyoti Agrawal (Inactive) made changes -
            Code Review Date 20/Apr/2017
            Code Reviewed By Prasanna Karlekar [ 11907 ]
            Hide
            Permalink
            jyoti.agrawal Jyoti Agrawal (Inactive) added a comment -

            Affected Areas :- Adjustment section of Invoice

            Affected DB Files :-

            1. OES_SP_Invoice_Display_BenefitWiseBilling
            2. OES_SP_Report_GetBillingDetailsColumnWise_InvoiceBenefitWise

            Tested Scenarios :-
            Tested sequence of positive negative cost

            • by selecting single benefit in template
            • by selecting multiple benefit in template
            • cost change in one plan
            • simultaneous cost/coverage change in multiple plans
            • Tier change
            • Cost/Coverage change for several employee for same month invoice
            Show
            jyoti.agrawal Jyoti Agrawal (Inactive) added a comment - Affected Areas :- Adjustment section of Invoice Affected DB Files :- OES_SP_Invoice_Display_BenefitWiseBilling OES_SP_Report_GetBillingDetailsColumnWise_InvoiceBenefitWise Tested Scenarios :- Tested sequence of positive negative cost by selecting single benefit in template by selecting multiple benefit in template cost change in one plan simultaneous cost/coverage change in multiple plans Tier change Cost/Coverage change for several employee for same month invoice
            jyoti.agrawal Jyoti Agrawal (Inactive) made changes -
            Time Spent 12.75h [ 45900 ] 18.75h [ 67500 ]
            Worklog Id 39409 [ 39409 ]
            Permalink
            prasanna Prasanna Karlekar (Inactive) logged work - 19/Apr/17 10:00 PM
            • Time Spent:
              1.5h
               

              Scenario and scope discussion
              Go through of document for Change Request

            jyoti.agrawal Jyoti Agrawal (Inactive) made changes -
            Time Spent 18.75h [ 67500 ] 20.75h [ 74700 ]
            Worklog Id 39479 [ 39479 ]
            jyoti.agrawal Jyoti Agrawal (Inactive) made changes -
            Worklog Id 39479 [ 39479 ]
            jyoti.agrawal Jyoti Agrawal (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)
            Hide
            Permalink
            jyoti.agrawal Jyoti Agrawal (Inactive) added a comment -

            Hi Venkatesh Pujari,

            The issues mentioned in this ticket Same month billing and adjustment and Duplicate entries were fixed in WT-7760.
            Now we are giving fix for Positive Negative Costs Sequence only.

            Show
            jyoti.agrawal Jyoti Agrawal (Inactive) added a comment - Hi Venkatesh Pujari , The issues mentioned in this ticket Same month billing and adjustment and Duplicate entries were fixed in WT-7760 . Now we are giving fix for Positive Negative Costs Sequence only.
            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)
            Permalink
            jyoti.agrawal Jyoti Agrawal (Inactive) logged work - 20/Apr/17 02:17 PM
            • Time Spent:
              1h
               

              Testing, code check-in, ticket update

            prasanna Prasanna Karlekar (Inactive) made changes -
            Assignee Jyoti Agrawal [ jyoti.agrawal ] Venkatesh Pujari [ venkatesh.pujari ]
            prasanna Prasanna Karlekar (Inactive) made changes -
            Time Spent 20.75h [ 74700 ] 22.25h [ 80100 ]
            Worklog Id 39788 [ 39788 ]
            venkatesh.pujari Venkatesh Pujari (Inactive) made changes -
            Status In Development [ 10007 ] Local Testing [ 10200 ]
            venkatesh.pujari Venkatesh Pujari (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)
            jyoti.agrawal Jyoti Agrawal (Inactive) made changes -
            Time Spent 22.25h [ 80100 ] 23.25h [ 83700 ]
            Worklog Id 40117 [ 40117 ]
            Permalink
            venkatesh.pujari Venkatesh Pujari (Inactive) logged work - 24/Apr/17 11:57 AM
            • Time Spent:
              3h
               

              Testing on LB

            venkatesh.pujari Venkatesh Pujari (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)
            venkatesh.pujari Venkatesh Pujari (Inactive) made changes -
            Time Spent 23.25h [ 83700 ] 26.25h [ 94500 ]
            Worklog Id 40344 [ 40344 ]
            Hide
            Permalink
            venkatesh.pujari Venkatesh Pujari (Inactive) added a comment -

            Hi Jyoti Agrawal,

            Tested the mentioned scenarios on LB on ASML company. In all the scenarios positive cost is displayed before any negative cost.If only negative cost is present then only negative is displayed correctly. This is ready for Stage

            Sachin Hingole

            Thanks,
            Venkatesh

            Show
            venkatesh.pujari Venkatesh Pujari (Inactive) added a comment - Hi Jyoti Agrawal , Tested the mentioned scenarios on LB on ASML company. In all the scenarios positive cost is displayed before any negative cost.If only negative cost is present then only negative is displayed correctly. This is ready for Stage Sachin Hingole Thanks, Venkatesh
            venkatesh.pujari Venkatesh Pujari (Inactive) made changes -
            Status Local Testing [ 10200 ] Pending for Stage Approval [ 10300 ]
            prasanna Prasanna Karlekar (Inactive) made changes -
            Developer Jyoti Agrawal [ jyoti.agrawal ]
            khandu.kshirsagar Khandu Kshirsagar (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: Stage Deployed(11602)
            venkatesh.pujari Venkatesh Pujari (Inactive) made changes -
            Status Pending for Stage Approval [ 10300 ] Approved for Stage [ 10030 ]
            venkatesh.pujari Venkatesh Pujari (Inactive) made changes -
            Status Approved for Stage [ 10030 ] Stage Testing [ 10201 ]
            venkatesh.pujari Venkatesh Pujari (Inactive) made changes -
            Item State Parent values: Stage QA(10202)Level 1 values: Stage Deployed(11602) Parent values: Stage QA(10202)Level 1 values: In Testing(10214)
            venkatesh.pujari Venkatesh Pujari (Inactive) made changes -
            Item State Parent values: Stage QA(10202)Level 1 values: In Testing(10214) Parent values: Stage QA(10202)Level 1 values: Ready for Production(10217)
            Permalink
            venkatesh.pujari Venkatesh Pujari (Inactive) logged work - 27/Apr/17 07:03 AM
            • Time Spent:
              3h
               

              Testing on Stage

            Hide
            Permalink
            venkatesh.pujari Venkatesh Pujari (Inactive) added a comment -

            Hi Jyoti Agrawal,

            Tested the mentioned scenarios on Stage on AFI For Hspl company. In all the scenarios positive cost is displayed before any negative cost.If only negative cost is present then only negative is displayed correctly. This is ready for Production

            Sachin Hingole

            Thanks,
            Venkatesh

            Show
            venkatesh.pujari Venkatesh Pujari (Inactive) added a comment - Hi Jyoti Agrawal , Tested the mentioned scenarios on Stage on AFI For Hspl company. In all the scenarios positive cost is displayed before any negative cost.If only negative cost is present then only negative is displayed correctly. This is ready for Production Sachin Hingole Thanks, Venkatesh
            venkatesh.pujari Venkatesh Pujari (Inactive) made changes -
            Time Spent 26.25h [ 94500 ] 29.25h [ 105300 ]
            Worklog Id 41173 [ 41173 ]
            venkatesh.pujari Venkatesh Pujari (Inactive) made changes -
            Status Stage Testing [ 10201 ] Pending for Production Approval [ 10301 ]
            ashwin.wankhede Ashwin Wankhede (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)
            venkatesh.pujari Venkatesh Pujari (Inactive) made changes -
            Status Pending for Production Approval [ 10301 ] Approved for production [ 10034 ]
            venkatesh.pujari Venkatesh Pujari (Inactive) made changes -
            Status Approved for production [ 10034 ] Production Testing [ 10202 ]
            venkatesh.pujari Venkatesh Pujari (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)
            Permalink
            venkatesh.pujari Venkatesh Pujari (Inactive) logged work - 02/May/17 11:23 AM
            • Time Spent:
              3h
               

              Production Testing

            venkatesh.pujari Venkatesh Pujari (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)
            Hide
            Permalink
            venkatesh.pujari Venkatesh Pujari (Inactive) added a comment -

            Hi Jyoti Agrawal,

            Tested the mentioned scenarios on Production on AFI For Hspl company. In all the scenarios positive cost is displayed before any negative cost.If only negative cost is present then only negative is displayed correctly.

            Sachin Hingole

            Thanks,
            Venkatesh

            Show
            venkatesh.pujari Venkatesh Pujari (Inactive) added a comment - Hi Jyoti Agrawal , Tested the mentioned scenarios on Production on AFI For Hspl company. In all the scenarios positive cost is displayed before any negative cost.If only negative cost is present then only negative is displayed correctly. Sachin Hingole Thanks, Venkatesh
            venkatesh.pujari Venkatesh Pujari (Inactive) made changes -
            Time Spent 29.25h [ 105300 ] 32.25h [ 116100 ]
            Worklog Id 42670 [ 42670 ]
            venkatesh.pujari Venkatesh Pujari (Inactive) made changes -
            Resolution Done [ 10000 ]
            Status Production Testing [ 10202 ] Production Complete [ 10028 ]
            venkatesh.pujari Venkatesh Pujari (Inactive) made changes -
            Resolution Done [ 10000 ] Fixed [ 1 ]
            Status Production Complete [ 10028 ] Closed [ 6 ]
            Transition Time In Source Status Execution Times
            Prasanna Karlekar (Inactive) made transition -
            Open New Request
            		10d 1h 37m 1
            Jyoti Agrawal (Inactive) made transition -
            New Request Pending for Approval
            		107d 17h 52m 1
            Jyoti Agrawal (Inactive) made transition -
            Pending for Approval Approved for Development
            		4s 1
            Jyoti Agrawal (Inactive) made transition -
            Approved for Development In Development
            		3s 1
            Venkatesh Pujari (Inactive) made transition -
            In Development In LB Testing
            		4d 5h 34m 1
            Venkatesh Pujari (Inactive) made transition -
            In LB Testing Pending for Stage Approval
            		3d 35m 1
            Venkatesh Pujari (Inactive) made transition -
            Pending for Stage Approval Approved for Stage
            		1d 21h 20m 1
            Venkatesh Pujari (Inactive) made transition -
            Approved for Stage Stage Testing
            		2s 1
            Venkatesh Pujari (Inactive) made transition -
            Stage Testing Pending for Production Approval
            		21h 43m 1
            Venkatesh Pujari (Inactive) made transition -
            Pending for Production Approval Approved for production
            		5d 1h 50m 1
            Venkatesh Pujari (Inactive) made transition -
            Approved for production In Production Testing
            		2s 1
            Venkatesh Pujari (Inactive) made transition -
            In Production Testing Production Complete
            		2h 33m 1
            Venkatesh Pujari (Inactive) made transition -
            Production Complete Closed
            		3s 1

              People

              Assignee:
              venkatesh.pujari Venkatesh Pujari (Inactive)
              Reporter:
              alankar.chavan Alankar Chavan (Inactive)
              Developer:
              Jyoti Agrawal (Inactive)
              Votes:
              0 Vote for this issue
              Watchers:
              3 Start watching this issue

                Dates

                Created:
                Updated:
                Resolved:
                Dev Due Date:
                Code Review Date:

                  Time Tracking

                  Estimated:
                  Original Estimate - 6h Original Estimate - 6h
                  6h
                  Remaining:
                  Remaining Estimate - 0h
                  0h
                  Logged:
                  Time Spent - 32.25h
                  32.25h