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

WT -> BCC Invoice Enhancement -> Did not show adjustments for first invoice

    Details

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

      Description

      TIBCO for HSPL
      Production

      • template created for FSA Admin and HSA Admin - all employee class
      • fetched out invoice for Jan 2017 - billing details shown correctly for Jan 2017 [billed rate mentioned in the mapped rate $5.15]
      • As discussed with client related to the first invoice - we are going to show adjustments for ongoing enrollments
      • Employee in the attached sheet (say Alexander Kolar) have enrollment from 01/01/2016 to NULL
      • as far as above fetched invoice for Jan 2017 is the first invoice - I expected the adjustments of $5.15 will appear from Jan 2016 to Nov 2017

      Invoice did not show me this adjustments

      CC - Rakesh Roy Deepali Tidke Venkatesh Pujari Hrishikesh Deshpande

        Attachments

          Issue Links

            Activity

            alankar.chavan Alankar Chavan (Inactive) created issue -
            alankar.chavan Alankar Chavan (Inactive) made changes -
            Field Original Value New Value
            Rank Ranked higher
            alankar.chavan Alankar Chavan (Inactive) made changes -
            Link This issue relates to WT-6331 [ WT-6331 ]
            jyoti.agrawal Jyoti Agrawal (Inactive) logged work - 09/Dec/16 08:38 AM
            • Time Spent:
              4h
               
              <No comment>
            prasanna Prasanna Karlekar (Inactive) made changes -
            Assignee Prasanna Karlekar [ prasanna ] Jyoti Agrawal [ jyoti.agrawal ]
            prasanna Prasanna Karlekar (Inactive) logged work - 09/Dec/16 09:49 PM - edited
            • Time Spent:
              2.5h
               

              Scenario discussion with QA and Developer.
              Root cause analysis and issue fix with Developer.
              Verification after fix done.

            prasanna Prasanna Karlekar (Inactive) made changes -
            Remaining Estimate 6h [ 21600 ] 4h [ 14400 ]
            Time Spent 2h [ 7200 ]
            Worklog Id 12401 [ 12401 ]
            prasanna Prasanna Karlekar (Inactive) made changes -
            Remaining Estimate 4h [ 14400 ] 3.5h [ 12600 ]
            Time Spent 2h [ 7200 ] 2.5h [ 9000 ]
            Worklog Id 12401 [ 12401 ]
            prasanna Prasanna Karlekar (Inactive) made changes -
            Worklog Id 12401 [ 12401 ]
            khandu.kshirsagar Khandu Kshirsagar (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
            jyoti.agrawal Jyoti Agrawal (Inactive) added a comment -

            Below are 3Cs :-
            Concern :- Did not show adjustments for first invoice.
            Cause :- If there was breakage in record like , a record with effective date '01/01/15' and termination date '12/31/15' and continuation of same enrollment with effective date '01/01/16' , we used to consider latest record. Due to this there were no adjustments shown before '01/01/16'.
            Correction :- We are considering all records which are continued.

            Show
            jyoti.agrawal Jyoti Agrawal (Inactive) added a comment - Below are 3Cs :- Concern :- Did not show adjustments for first invoice. Cause :- If there was breakage in record like , a record with effective date '01/01/15' and termination date '12/31/15' and continuation of same enrollment with effective date '01/01/16' , we used to consider latest record. Due to this there were no adjustments shown before '01/01/16'. Correction :- We are considering all records which are continued.
            jyoti.agrawal Jyoti Agrawal (Inactive) made changes -
            Remaining Estimate 3.5h [ 12600 ] 0h [ 0 ]
            Time Spent 2.5h [ 9000 ] 6.5h [ 23400 ]
            Worklog Id 12442 [ 12442 ]
            Hide
            alankar.chavan Alankar Chavan (Inactive) added a comment - - edited

            This is tested on LB - TIBCO - 12th Dec 2016

            Working well for Health as well as for Non Health enrollments.

            Invoices shows proper adjustments (except terminated ones - which is expected) for the first invoice.

            Ready for Stage

            CC - Hrishikesh Deshpande Deepali Tidke Venkatesh Pujari

            Show
            alankar.chavan Alankar Chavan (Inactive) added a comment - - edited This is tested on LB - TIBCO - 12th Dec 2016 Working well for Health as well as for Non Health enrollments. Invoices shows proper adjustments (except terminated ones - which is expected) for the first invoice. Ready for Stage CC - Hrishikesh Deshpande Deepali Tidke Venkatesh Pujari
            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 - 12/Dec/16 10:28 AM
            • Time Spent:
              4h
               

              Testing on LB
              Ready for Stage

            alankar.chavan Alankar Chavan (Inactive) made changes -
            Time Spent 6.5h [ 23400 ] 10.5h [ 37800 ]
            Worklog Id 12464 [ 12464 ]
            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)
            jyoti.agrawal Jyoti Agrawal (Inactive) logged work - 12/Dec/16 01:40 PM
            • Time Spent:
              2h
               

              Lb and stage code check-in and unit testing

            jyoti.agrawal Jyoti Agrawal (Inactive) made changes -
            Time Spent 10.5h [ 37800 ] 12.5h [ 45000 ]
            Worklog Id 12541 [ 12541 ]
            prasanna Prasanna Karlekar (Inactive) logged work - 12/Dec/16 02:39 PM
            • Time Spent:
              0.25h
               

              Discussion on scenario and fix to be given.

            prasanna Prasanna Karlekar (Inactive) made changes -
            Time Spent 12.5h [ 45000 ] 12.75h [ 45900 ]
            Worklog Id 12587 [ 12587 ]
            hrishikesh.deshpande Hrishikesh Deshpande (Inactive) made changes -
            Assignee Alankar Chavan [ alankar.chavan ] Venkatesh Pujari [ venkatesh.pujari ]
            venkatesh.pujari Venkatesh Pujari (Inactive) logged work - 13/Dec/16 07:29 AM - edited
            • Time Spent:
              1h
               
              <No comment>
            venkatesh.pujari Venkatesh Pujari (Inactive) made changes -
            Time Spent 12.75h [ 45900 ] 13.75h [ 49500 ]
            Worklog Id 12663 [ 12663 ]
            venkatesh.pujari Venkatesh Pujari (Inactive) made changes -
            Status Open [ 1 ] In Development [ 10007 ]
            venkatesh.pujari Venkatesh Pujari (Inactive) made changes -
            Status In Development [ 10007 ] Local Testing [ 10200 ]
            venkatesh.pujari Venkatesh Pujari (Inactive) made changes -
            Status Local Testing [ 10200 ] Stage Testing [ 10201 ]
            venkatesh.pujari Venkatesh Pujari (Inactive) made changes -
            Resolution Unresolved [ 10200 ]
            Status Stage Testing [ 10201 ] Reopen in Stage [ 10023 ]
            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: Re-open(10216)
            Hide
            venkatesh.pujari Venkatesh Pujari (Inactive) added a comment -

            Tested this on Stage on ASML for Hspl company - 13th Dec 2016

            template created for Flexible Spending Account,FSA,Limited FSA Benefit types - all employee class
            fetched out invoice for Jan 2017 - billing details shown correctly for Jan 2017 [billed rate mentioned in the mapped rate $5.15]
            As discussed with client related to the first invoice - we are going to show adjustments for ongoing enrollments
            For the above scenario adjustments are being displayed properly.

            But when I generate an Invoice for June 2016 for the above template I observe that there is no record for an EE but there are entries for the same EE in adjustment sections. This is not correct.

            Reopening the ticket.

            Alankar Chavan,Prasanna Karlekar,Rakesh Roy,

            Thanks,
            Venkatesh

            Show
            venkatesh.pujari Venkatesh Pujari (Inactive) added a comment - Tested this on Stage on ASML for Hspl company - 13th Dec 2016 template created for Flexible Spending Account,FSA,Limited FSA Benefit types - all employee class fetched out invoice for Jan 2017 - billing details shown correctly for Jan 2017 [billed rate mentioned in the mapped rate $5.15] As discussed with client related to the first invoice - we are going to show adjustments for ongoing enrollments For the above scenario adjustments are being displayed properly. But when I generate an Invoice for June 2016 for the above template I observe that there is no record for an EE but there are entries for the same EE in adjustment sections. This is not correct. Reopening the ticket. Alankar Chavan , Prasanna Karlekar , Rakesh Roy , Thanks, Venkatesh
            venkatesh.pujari Venkatesh Pujari (Inactive) made changes -
            Assignee Venkatesh Pujari [ venkatesh.pujari ] Jyoti Agrawal [ jyoti.agrawal ]
            venkatesh.pujari Venkatesh Pujari (Inactive) made changes -
            Worklog Id 12663 [ 12663 ]
            jyoti.agrawal Jyoti Agrawal (Inactive) made changes -
            Item State Parent values: Stage QA(10202)Level 1 values: Re-open(10216) 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 ]
            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 ]
            alankar.chavan Alankar Chavan (Inactive) made changes -
            Assignee Alankar Chavan [ alankar.chavan ] Venkatesh Pujari [ venkatesh.pujari ]
            Hide
            venkatesh.pujari Venkatesh Pujari (Inactive) added a comment -

            Tested this on LB on ZCC BCC Testing company.

            Adjustments and billing details are displayed correctly.

            Ready For Stage
            [only deploy this patch ahead with it's parent item WT-6331]

            Alankar Chavan,Prasanna Karlekar

            Show
            venkatesh.pujari Venkatesh Pujari (Inactive) added a comment - Tested this on LB on ZCC BCC Testing company. Adjustments and billing details are displayed correctly. Ready For Stage [only deploy this patch ahead with it's parent item WT-6331] Alankar Chavan , Prasanna Karlekar
            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: Ready for Stage(10213)
            venkatesh.pujari Venkatesh Pujari (Inactive) logged work - 22/Dec/16 09:40 AM
            • Time Spent:
              0.5h
               
              <No comment>
            venkatesh.pujari Venkatesh Pujari (Inactive) made changes -
            Time Spent 13.75h [ 49500 ] 14.25h [ 51300 ]
            Worklog Id 15006 [ 15006 ]
            rakeshr Rakesh Roy (Inactive) made changes -
            Developer Jyoti Agrawal [ jyoti.agrawal ]
            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 -

            Tested this Stage - 27th Dec 2016

            Adjustments and billing details are displayed correctly.

            Ready For Production

            [only deploy this patch ahead with it's parent item WT-6331]

            CC - Hrishikesh Deshpande Venkatesh Pujari Rakesh Roy

            Show
            alankar.chavan Alankar Chavan (Inactive) added a comment - Tested this Stage - 27th Dec 2016 Adjustments and billing details are displayed correctly. Ready For Production [only deploy this patch ahead with it's parent item WT-6331] CC - Hrishikesh Deshpande Venkatesh Pujari Rakesh Roy
            alankar.chavan Alankar Chavan (Inactive) made changes -
            Status Local Testing [ 10200 ] Stage Testing [ 10201 ]
            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) logged work - 27/Dec/16 12:50 PM
            • Time Spent:
              0.5h
               

              Stage Testing

            alankar.chavan Alankar Chavan (Inactive) made changes -
            Time Spent 14.25h [ 51300 ] 14.75h [ 53100 ]
            Worklog Id 15757 [ 15757 ]
            jyoti.agrawal Jyoti Agrawal (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)
            rakeshr Rakesh Roy (Inactive) made changes -
            Status Stage Testing [ 10201 ] Production Testing [ 10202 ]
            rakeshr Rakesh Roy (Inactive) made changes -
            Resolution Unresolved [ 10200 ] Fixed [ 1 ]
            Status Production Testing [ 10202 ] Production Complete [ 10028 ]
            rakeshr Rakesh Roy (Inactive) made changes -
            Item State Parent values: Production QA(10203)Level 1 values: Production Deployed(10221) Parent values: Production Complete(10222)
            satyap Satya made changes -
            Environment_New Production [ 18442 ]
            Transition Time In Source Status Execution Times
            Venkatesh Pujari (Inactive) made transition -
            Open In Development
            4d 7m 1
            Venkatesh Pujari (Inactive) made transition -
            Stage Testing Reopened in Stage
            4s 1
            Rakesh Roy (Inactive) made transition -
            Reopened in Stage In Development
            6d 5h 55m 1
            Rakesh Roy (Inactive) made transition -
            In Development In LB Testing
            8s 2
            Alankar Chavan (Inactive) made transition -
            In LB Testing Stage Testing
            7d 22h 38m 2
            Rakesh Roy (Inactive) made transition -
            Stage Testing In Production Testing
            42d 6h 37m 1
            Rakesh Roy (Inactive) made transition -
            In Production Testing Production Complete
            19d 9h 2m 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:

                  Time Tracking

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