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

WT -> BCC Invoice Enhancement -> Did not give the correct adjustment amounts in case of updates in Self Insured Component

    Details

    • Type: Bug
    • Status: Closed
    • Priority: High
    • Resolution: Done
    • Affects Version/s: None
    • Fix Version/s: None
    • Component/s: BenAdmin
    • Labels:
      None
    • Environment:
      QA
    • Module:
      BenAdmin - Report
    • Reported by:
      Harbinger
    • Item State:
      Production Complete - Closed

      Description

      Plan - Vision
      Rate - has 2 billable self insured components iwth each having costs as $10 [total $20]

      • employee enrolled from 01/01/2016 [date time stamp in Dec 2016]
      • fetched invoices fro Jan Feb March April 2016 - showed billing details of $20 - Expected
      • now I changed one of the self insured component's cost from 10 to 15 [total becomes $25]
      • fetched May 2016 invoice

      Expected and Actual Results -

      1. billing cost of $25 fir moth May 2016 - worked well
      2. adjustment of $-20 from Jan to April - worked well
      3. adjustment of $25 from Jan to April - did not work well - system showed this cost as $15 !

      CC - Deepali Tidke Rakesh Roy Hrishikesh Deshpande Venkatesh Pujari

        Attachments

          Issue Links

            Activity

            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 ]
            prasanna Prasanna Karlekar (Inactive) made changes -
            Assignee Prasanna Karlekar [ prasanna ] Jyoti Agrawal [ jyoti.agrawal ]
            prasanna Prasanna Karlekar (Inactive) logged work - 20/Dec/16 02:31 PM
            • Time Spent:
              1.5h
               

              Discussion on root cause.
              Code fix to resolve the issue.

            prasanna Prasanna Karlekar (Inactive) made changes -
            Remaining Estimate 5h [ 18000 ] 3.5h [ 12600 ]
            Time Spent 1.5h [ 5400 ]
            Worklog Id 14571 [ 14571 ]
            jyoti.agrawal Jyoti Agrawal (Inactive) logged work - 20/Dec/16 04:23 PM
            • Time Spent:
              4h
               

              Scenario generation, analysis, discussion

            jyoti.agrawal Jyoti Agrawal (Inactive) made changes -
            Remaining Estimate 3.5h [ 12600 ] 0h [ 0 ]
            Time Spent 1.5h [ 5400 ] 5.5h [ 19800 ]
            Worklog Id 14620 [ 14620 ]
            jyoti.agrawal Jyoti Agrawal (Inactive) made changes -
            Item State Parent values: LB QA(10201)Level 1 values: LB Deployed(11600)
            jyoti.agrawal Jyoti Agrawal (Inactive) made changes -
            Assignee Jyoti Agrawal [ jyoti.agrawal ] Alankar Chavan [ alankar.chavan ]
            Hide
            alankar.chavan Alankar Chavan (Inactive) added a comment -

            Hello Jyoti Agrawal,

            Please update the 3C's and assign this back to us.
            If possible let us know the impacted areas for better testing.

            CC - Prasanna Karlekar Rakesh Roy

            Show
            alankar.chavan Alankar Chavan (Inactive) added a comment - Hello Jyoti Agrawal , Please update the 3C's and assign this back to us. If possible let us know the impacted areas for better testing. CC - Prasanna Karlekar Rakesh Roy
            alankar.chavan Alankar Chavan (Inactive) made changes -
            Assignee Alankar Chavan [ alankar.chavan ] Jyoti Agrawal [ jyoti.agrawal ]
            jyoti.agrawal Jyoti Agrawal (Inactive) logged work - 21/Dec/16 01:36 PM
            • Time Spent:
              0.5h
               
              <No comment>
            Hide
            jyoti.agrawal Jyoti Agrawal (Inactive) added a comment -

            Below are 3C's :-
            Concern :- Did not give the correct adjustment amounts in case of updates in Self Insured Component
            Cause :- For cost updates, only those were considered in adjustment which were made change. Since there were two Self Insured components mapped, the one which was changed was only considered for adjustment.
            Correction :- Consider total cost (Sum of all billable Self insured component) mapped for a rate despite cost changes made in one or all.

            Show
            jyoti.agrawal Jyoti Agrawal (Inactive) added a comment - Below are 3C's :- Concern :- Did not give the correct adjustment amounts in case of updates in Self Insured Component Cause :- For cost updates, only those were considered in adjustment which were made change. Since there were two Self Insured components mapped, the one which was changed was only considered for adjustment. Correction :- Consider total cost (Sum of all billable Self insured component) mapped for a rate despite cost changes made in one or all.
            jyoti.agrawal Jyoti Agrawal (Inactive) made changes -
            Time Spent 5.5h [ 19800 ] 6h [ 21600 ]
            Worklog Id 14795 [ 14795 ]
            jyoti.agrawal Jyoti Agrawal (Inactive) made changes -
            Assignee Jyoti Agrawal [ jyoti.agrawal ] Alankar Chavan [ alankar.chavan ]
            jyoti.agrawal Jyoti Agrawal (Inactive) made changes -
            Status Open [ 1 ] In Development [ 10007 ]
            alankar.chavan Alankar Chavan (Inactive) made changes -
            Status In Development [ 10007 ] Local Testing [ 10200 ]
            Hide
            alankar.chavan Alankar Chavan (Inactive) added a comment -

            This is tested on WT Stage - 23rd Dec 2016
            Working well

            Invoices are showing proper self insured component's costs in billing as well as in billing adjustments sections (summation of all billable self insured component's)

            Ready for Stage

            CC - Venkatesh Pujari Rakesh Roy Prasanna KarlekarHrishikesh Deshpande

            Show
            alankar.chavan Alankar Chavan (Inactive) added a comment - This is tested on WT Stage - 23rd Dec 2016 Working well Invoices are showing proper self insured component's costs in billing as well as in billing adjustments sections (summation of all billable self insured component's) Ready for Stage CC - Venkatesh Pujari Rakesh Roy Prasanna Karlekar Hrishikesh Deshpande
            alankar.chavan Alankar Chavan (Inactive) made changes -
            Item State Parent values: LB QA(10201)Level 1 values: LB Deployed(11600) Parent values: LB QA(10201)Level 1 values: Ready for Stage(10213)
            alankar.chavan Alankar Chavan (Inactive) logged work - 23/Dec/16 12:34 PM
            • Time Spent:
              2h
               

              LB Testing

            alankar.chavan Alankar Chavan (Inactive) made changes -
            Time Spent 6h [ 21600 ] 8h [ 28800 ]
            Worklog Id 15250 [ 15250 ]
            prasanna Prasanna Karlekar (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)
            Hide
            alankar.chavan Alankar Chavan (Inactive) added a comment -

            This is tested on Stage - 27th Dec 2016 - TIBCO FOR HSPL
            Working well
            Invoices are showing proper self insured component's costs in billing as well as in billing adjustments sections (summation of all billable self insured component's)

            Ready for Production
            [please deploy this on production along with it's parent item WT-6331]

            CC - Prasanna Karlekar Hrishikesh Deshpande Rakesh Roy Venkatesh Pujari

            Show
            alankar.chavan Alankar Chavan (Inactive) added a comment - This is tested on Stage - 27th Dec 2016 - TIBCO FOR HSPL Working well Invoices are showing proper self insured component's costs in billing as well as in billing adjustments sections (summation of all billable self insured component's) Ready for Production [please deploy this on production along with it's parent item WT-6331] CC - Prasanna Karlekar Hrishikesh Deshpande Rakesh Roy Venkatesh Pujari
            alankar.chavan Alankar Chavan (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)
            alankar.chavan Alankar Chavan (Inactive) made changes -
            Status Local Testing [ 10200 ] Stage Testing [ 10201 ]
            alankar.chavan Alankar Chavan (Inactive) logged work - 27/Dec/16 12:49 PM
            • Time Spent:
              0.5h
               

              Stage Testing

            alankar.chavan Alankar Chavan (Inactive) made changes -
            Time Spent 8h [ 28800 ] 8.5h [ 30600 ]
            Worklog Id 15750 [ 15750 ]
            alankar.chavan Alankar Chavan (Inactive) made changes -
            Assignee Alankar Chavan [ alankar.chavan ] Venkatesh Pujari [ venkatesh.pujari ]
            venkatesh.pujari Venkatesh Pujari (Inactive) made changes -
            Status Stage Testing [ 10201 ] Production Testing [ 10202 ]
            venkatesh.pujari Venkatesh Pujari (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: In Testing(10218)
            venkatesh.pujari Venkatesh Pujari (Inactive) logged work - 11/Jan/17 11:15 AM
            • Time Spent:
              0.5h
               
              <No comment>
            Hide
            venkatesh.pujari Venkatesh Pujari (Inactive) added a comment -

            This is tested on Production on ASML for HSPL company

            Working well

            Invoices are showing proper self insured component's costs in billing as well as in billing adjustments sections (summation of all billable self insured component's)

            Alankar Chavan,Prasanna Karlekar,Jyoti Agrawal

            Show
            venkatesh.pujari Venkatesh Pujari (Inactive) added a comment - This is tested on Production on ASML for HSPL company Working well Invoices are showing proper self insured component's costs in billing as well as in billing adjustments sections (summation of all billable self insured component's) Alankar Chavan , Prasanna Karlekar , Jyoti Agrawal
            venkatesh.pujari Venkatesh Pujari (Inactive) made changes -
            Resolution Fixed [ 1 ]
            Status Production Testing [ 10202 ] Production Complete [ 10028 ]
            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)
            venkatesh.pujari Venkatesh Pujari (Inactive) made changes -
            Time Spent 8.5h [ 30600 ] 9h [ 32400 ]
            Worklog Id 18422 [ 18422 ]
            venkatesh.pujari Venkatesh Pujari (Inactive) made changes -
            Status Production Complete [ 10028 ] Closed [ 6 ]
            satyap Satya made changes -
            Environment_New LB [ 18444 ]
            Transition Time In Source Status Execution Times
            Jyoti Agrawal (Inactive) made transition -
            Open In Development
            2d 4m 1
            Alankar Chavan (Inactive) made transition -
            In Development In LB Testing
            1h 17m 1
            Alankar Chavan (Inactive) made transition -
            In LB Testing Stage Testing
            5d 7m 1
            Venkatesh Pujari (Inactive) made transition -
            Stage Testing In Production Testing
            14d 18h 53m 1
            Venkatesh Pujari (Inactive) made transition -
            In Production Testing Production Complete
            4h 27m 1
            Venkatesh Pujari (Inactive) made transition -
            Production Complete Closed
            42s 1

              People

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

                Dates

                Created:
                Updated:
                Resolved:

                  Time Tracking

                  Estimated:
                  Original Estimate - 5h Original Estimate - 5h
                  5h
                  Remaining:
                  Remaining Estimate - 0h
                  0h
                  Logged:
                  Time Spent - 9h
                  9h