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

TIBCO - August Invoice Issues

    Details

    • Type: Bug
    • Status: Closed
    • Priority: High
    • Resolution: Unresolved
    • Affects Version/s: None
    • Fix Version/s: None
    • Component/s: BenAdmin
    • Environment:
      Production
    • Bug Severity:
      Medium
    • Module:
      BenAdmin - Report
    • Reported by:
      Client
    • Company:
      TIBCO
    • Item State:
      Production Complete - Closed
    • Sprint:
      WT Sprint 41

      Description

      Please see the adjustment issues BCC is having with TIBCO's August bill.

      Issue 1: LTD coverage is being unbilled and rebilled at a pro-rated monthly portion. Example: Alec Cross Originally billing for January for Long-Term Disability at $16.25 on the January Invoice. On the August invoice he is being credited for January in the Amount of -$16.25 and being rebilled at $3.67. We did load a new salary effective 1/25/2017, but no billing adjustment should have occurred. The system looks like it is trying to pro-rate for those last 7 days of the month. (16.25/31*7=$3.67)

      Other examples: Aaron Shoffa, Adrian Johnson, and many more.

      Issue 2: Abay Prajapati terminated 5/31/2017 via a file load that occurred on 6/13/2017. The adjustments on the August invoice look correct with the exception of the COBRA Admin Coverage. COBRA admin did not credit for June or July and COBRA admin is still being billed for August. Even stranger he is being rebilled for January through May which he was previously billed during those billing cycles. Another example of same issue is Shaohua Qu.

      Issue 3: Barton Wright his ADD is not age reducing correctly. His age reduction should be the same as life with a volume of $169,000.00. The system for ADD is crediting $110,000 and re-billing at a volume of $260,000 February through current month of August. It looks like the system has not been doing the ADD age reductions correctly from the beginning. The system was reducing the amount to $110,000 versus $169,000

        Attachments

        1. AD&D Plan.png
          AD&D Plan.png
          178 kB
        2. FW 1211 Sprint - Development Approval.msg
          51 kB
        3. FW Development approval for 9-Nov-2017.msg
          141 kB
        4. FW Development approval for 9-Nov-2017.msg
          141 kB
        5. Life Plan.png
          Life Plan.png
          177 kB
        6. Payroll Changes.png
          Payroll Changes.png
          139 kB
        7. Scenarios.xls
          20 kB

          Issue Links

            Activity

            dkulling Debbie Kulling created issue -
            rakeshr Rakesh Roy (Inactive) made changes -
            Field Original Value New Value
            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 -
            Assignee Prasanna Karlekar [ prasanna ] Debbie Kulling [ dkulling ]
            venkatesh.pujari Venkatesh Pujari (Inactive) made changes -
            Remaining Estimate 2h [ 7200 ]
            Original Estimate 2h [ 7200 ]
            venkatesh.pujari Venkatesh Pujari (Inactive) made changes -
            Remaining Estimate 2h [ 7200 ] 0.5h [ 1800 ]
            Time Spent 1.5h [ 5400 ]
            Worklog Id 65024 [ 65024 ]
            jyoti.mayne Jyoti Mayne made changes -
            Attachment Life Plan.png [ 56201 ]
            jyoti.mayne Jyoti Mayne made changes -
            Attachment AD&D Plan.png [ 56202 ]
            jyoti.mayne Jyoti Mayne made changes -
            Attachment Payroll Changes.png [ 56203 ]
            prasanna Prasanna Karlekar (Inactive) made changes -
            Remaining Estimate 0.5h [ 1800 ] 0h [ 0 ]
            Time Spent 1.5h [ 5400 ] 5h [ 18000 ]
            Worklog Id 65900 [ 65900 ]
            prasanna Prasanna Karlekar (Inactive) made changes -
            Time Spent 5h [ 18000 ] 7.25h [ 26100 ]
            Worklog Id 65908 [ 65908 ]
            prasanna Prasanna Karlekar (Inactive) made changes -
            Time Spent 7.25h [ 26100 ] 12.75h [ 45900 ]
            Worklog Id 65911 [ 65911 ]
            prasanna Prasanna Karlekar (Inactive) made changes -
            Time Spent 12.75h [ 45900 ] 14.75h [ 53100 ]
            Worklog Id 65917 [ 65917 ]
            jyoti.agrawal Jyoti Agrawal (Inactive) made changes -
            Time Spent 14.75h [ 53100 ] 16.75h [ 60300 ]
            Worklog Id 66927 [ 66927 ]
            prasanna Prasanna Karlekar (Inactive) made changes -
            Assignee Debbie Kulling [ dkulling ] Prasanna Karlekar [ prasanna ]
            jyoti.mayne Jyoti Mayne made changes -
            Time Spent 16.75h [ 60300 ] 19.25h [ 69300 ]
            Worklog Id 67861 [ 67861 ]
            prasanna Prasanna Karlekar (Inactive) made changes -
            Sprint WT Sprint 34-Bugs [ 79 ]
            prasanna Prasanna Karlekar (Inactive) made changes -
            Dev Due Date 04/Aug/2017
            prasanna Prasanna Karlekar (Inactive) made changes -
            Code Reviewed By Prasanna Karlekar [ 11907 ]
            Dev Estimates 35
            gaurav.sodani Gaurav Sodani (Inactive) made changes -
            Sprint WT Sprint 34-Bugs [ 79 ] WT Sprint 35 - Bugs [ 81 ]
            gaurav.sodani Gaurav Sodani (Inactive) made changes -
            Company TIBCO [ 13656 ]
            prasanna Prasanna Karlekar (Inactive) made changes -
            Time Spent 19.25h [ 69300 ] 19.5h [ 70200 ]
            Worklog Id 72527 [ 72527 ]
            prasanna Prasanna Karlekar (Inactive) made changes -
            Time Spent 19.5h [ 70200 ] 19.75h [ 71100 ]
            Worklog Id 72536 [ 72536 ]
            prasanna Prasanna Karlekar (Inactive) made changes -
            Time Spent 19.75h [ 71100 ] 20.75h [ 74700 ]
            Worklog Id 72551 [ 72551 ]
            prasanna Prasanna Karlekar (Inactive) made changes -
            Time Spent 20.75h [ 74700 ] 21.25h [ 76500 ]
            Worklog Id 72578 [ 72578 ]
            gaurav.sodani Gaurav Sodani (Inactive) made changes -
            Sprint WT Sprint 35 - Bugs [ 81 ]
            prasanna Prasanna Karlekar (Inactive) made changes -
            Time Spent 21.25h [ 76500 ] 21.75h [ 78300 ]
            Worklog Id 75152 [ 75152 ]
            gaurav.sodani Gaurav Sodani (Inactive) made changes -
            Dev Due Date 04/Aug/2017 04/Aug/2017
            Item State Parent values: Development(10200)Level 1 values: On Hold(10207)
            prasanna Prasanna Karlekar (Inactive) made changes -
            Dev Due Date 04/Aug/2017 04/Oct/2018
            prasanna Prasanna Karlekar (Inactive) made changes -
            Dev Due Date 04/Oct/2018
            parmeshwar.jumbad Parmeshwar Jumbad (Inactive) made changes -
            Labels Invoice_Management
            satyap Satya made changes -
            Root Cause Bug [ 18430 ]
            satyap Satya made changes -
            Environment_New Production [ 18442 ]
            prasanna Prasanna Karlekar (Inactive) made changes -
            Time Spent 21.75h [ 78300 ] 22.75h [ 81900 ]
            Worklog Id 89334 [ 89334 ]
            prasanna Prasanna Karlekar (Inactive) made changes -
            Code Reviewed By Prasanna Karlekar [ 11907 ] Jyoti Agarwal [ 16704 ]
            Dev Due Date 15/Nov/2017
            Developer Prasanna Karlekar [ prasanna ]
            prasanna Prasanna Karlekar (Inactive) made changes -
            Item State Parent values: Development(10200)Level 1 values: On Hold(10207) Parent values: Development(10200)Level 1 values: In Progress(10206)
            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: On Hold(10207)
            gaurav.sodani Gaurav Sodani (Inactive) made changes -
            Item State Parent values: Development(10200)Level 1 values: On Hold(10207) Parent values: Development(10200)Level 1 values: In Progress(10206)
            gaurav.sodani Gaurav Sodani (Inactive) made changes -
            Assignee Prasanna Karlekar [ prasanna ] Parmeshwar Jumbad [ parmeshwar.jumbade ]
            gaurav.sodani Gaurav Sodani (Inactive) made changes -
            Approval status Approved for development [ 18453 ]
            Attachment FW Development approval for 9-Nov-2017.msg [ 68120 ]
            Attachment FW Development approval for 9-Nov-2017.msg [ 68121 ]
            parmeshwar.jumbad Parmeshwar Jumbad (Inactive) made changes -
            Dev Due Date 15/Nov/2017 05/Dec/2017
            gaurav.sodani Gaurav Sodani (Inactive) made changes -
            Sprint WT Sprint 41 - Bugs [ 95 ]
            parmeshwar.jumbad Parmeshwar Jumbad (Inactive) made changes -
            Dev Due Date 05/Dec/2017 12/Dec/2017
            Dev Estimates 35 40
            hrishikesh.deshpande Hrishikesh Deshpande (Inactive) made changes -
            QA Venkatesh Pujari [ venkatesh.pujari ]
            QA Estimates 8
            gaurav.sodani Gaurav Sodani (Inactive) made changes -
            Development Approval Yes [ 18474 ]
            gaurav.sodani Gaurav Sodani (Inactive) made changes -
            Stage Due Date 22/Dec/17 [ 2017-12-22 ]
            parmeshwar.jumbad Parmeshwar Jumbad (Inactive) made changes -
            Assignee Parmeshwar Jumbad [ parmeshwar.jumbade ] Prasanna Karlekar [ prasanna ]
            gaurav.sodani Gaurav Sodani (Inactive) made changes -
            prasanna Prasanna Karlekar (Inactive) made changes -
            Item State Parent values: Development(10200)Level 1 values: In Progress(10206) Parent values: Development(10200)Level 1 values: Ready for Local Testing(10209)
            prasanna Prasanna Karlekar (Inactive) made changes -
            Code Reviewed By Jyoti Agarwal [ 16704 ] Prasanna Karlekar [ 11907 ]
            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)
            prasanna Prasanna Karlekar (Inactive) made changes -
            Assignee Prasanna Karlekar [ prasanna ] Venkatesh Pujari [ venkatesh.pujari ]
            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)
            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 ] Reopen in Local [ 10018 ]
            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: Re-open(10212)
            venkatesh.pujari Venkatesh Pujari (Inactive) made changes -
            Time Spent 22.75h [ 81900 ] 26.75h [ 96300 ]
            Worklog Id 96293 [ 96293 ]
            venkatesh.pujari Venkatesh Pujari (Inactive) made changes -
            Assignee Venkatesh Pujari [ venkatesh.pujari ] Prasanna Karlekar [ prasanna ]
            prasanna Prasanna Karlekar (Inactive) made changes -
            Status Reopen in Local [ 10018 ] In Development [ 10007 ]
            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)
            prasanna Prasanna Karlekar (Inactive) made changes -
            Time Spent 26.75h [ 96300 ] 29.25h [ 105300 ]
            Worklog Id 96752 [ 96752 ]
            prasanna Prasanna Karlekar (Inactive) made changes -
            Assignee Prasanna Karlekar [ prasanna ] Sachin Hingole [ sachin.hingole ]
            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)
            venkatesh.pujari Venkatesh Pujari (Inactive) made changes -
            Assignee Sachin Hingole [ sachin.hingole ] Venkatesh Pujari [ venkatesh.pujari ]
            venkatesh.pujari Venkatesh Pujari (Inactive) made changes -
            Status In Development [ 10007 ] Local Testing [ 10200 ]
            prasanna Prasanna Karlekar (Inactive) made changes -
            Link This issue relates to NF-5537 [ NF-5537 ]
            venkatesh.pujari Venkatesh Pujari (Inactive) made changes -
            Time Spent 29.25h [ 105300 ] 32.25h [ 116100 ]
            Worklog Id 96816 [ 96816 ]
            venkatesh.pujari Venkatesh Pujari (Inactive) made changes -
            Status Local Testing [ 10200 ] Reopen in Local [ 10018 ]
            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: Re-open(10212)
            venkatesh.pujari Venkatesh Pujari (Inactive) made changes -
            Time Spent 32.25h [ 116100 ] 36.25h [ 130500 ]
            Worklog Id 97058 [ 97058 ]
            venkatesh.pujari Venkatesh Pujari (Inactive) made changes -
            Assignee Venkatesh Pujari [ venkatesh.pujari ] Jyoti Agrawal [ jyoti.agrawal ]
            prasanna Prasanna Karlekar (Inactive) made changes -
            Time Spent 36.25h [ 130500 ] 38.75h [ 139500 ]
            Worklog Id 97084 [ 97084 ]
            prasanna Prasanna Karlekar (Inactive) made changes -
            Status Reopen in Local [ 10018 ] In Development [ 10007 ]
            venkatesh.pujari Venkatesh Pujari (Inactive) made changes -
            Attachment Invoice_Scenarios_TestData.xlsx [ 70479 ]
            prasanna Prasanna Karlekar (Inactive) made changes -
            Assignee Jyoti Agrawal [ jyoti.agrawal ] Venkatesh Pujari [ venkatesh.pujari ]
            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: Re-open(10212) Parent values: LB QA(10201)Level 1 values: In Testing(10210)
            venkatesh.pujari Venkatesh Pujari (Inactive) made changes -
            Attachment Invoice_Scenarios_TestData.xlsx [ 70479 ]
            venkatesh.pujari Venkatesh Pujari (Inactive) made changes -
            Attachment Scenarios.xls [ 70494 ]
            venkatesh.pujari Venkatesh Pujari (Inactive) made changes -
            Time Spent 38.75h [ 139500 ] 41.75h [ 150300 ]
            Worklog Id 97184 [ 97184 ]
            khandu.kshirsagar Khandu Kshirsagar (Inactive) made changes -
            Item State Parent values: LB QA(10201)Level 1 values: In Testing(10210) Parent values: LB QA(10201)Level 1 values: LB Deployed(11600)
            venkatesh.pujari Venkatesh Pujari (Inactive) made changes -
            Comment [ Hi [~jyoti.agrawal],

            Please find the scenario for which the system is not working as per expectation:-

            Self Insured components for E+SP tier are 60$ and 80$ both billable.
            Now I enroll the EE + SP in the Venky SI plan effective from 08/01/2017.
            Now generated the Invoice for Dec 2017 month. Proper billing and adjustment records were displayed on the invoice.
            Now change one Self Insured component to Non- Billable and generate the Invoice for jan 2018 month. We can see proper billing for Jan 2018 month and also we can see that credits have been given to the EE, but billable components cost is not charged for this EE.


            *REOPEN*
            [~prasanna],[~sachin.hingole]

            Thanks,
            Venkatesh ]
            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) made changes -
            Time Spent 41.75h [ 150300 ] 49.25h [ 177300 ]
            Worklog Id 97366 [ 97366 ]
            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)
            gaurav.sodani Gaurav Sodani (Inactive) made changes -
            Deployment Approval Approved for stage deployment [ 18455 ]
            Production Due Date 29/Dec/2017
            prasanna Prasanna Karlekar (Inactive) made changes -
            Time Spent 49.25h [ 177300 ] 50h [ 180000 ]
            Worklog Id 97901 [ 97901 ]
            venkatesh.pujari Venkatesh Pujari (Inactive) made changes -
            Status Local Testing [ 10200 ] Stage Testing [ 10201 ]
            sachin.hingole Sachin Hingole (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)
            prasanna Prasanna Karlekar (Inactive) made changes -
            Time Spent 50h [ 180000 ] 52.5h [ 189000 ]
            Worklog Id 98010 [ 98010 ]
            prasanna Prasanna Karlekar (Inactive) made changes -
            Time Spent 52.5h [ 189000 ] 55h [ 198000 ]
            Worklog Id 98020 [ 98020 ]
            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)
            venkatesh.pujari Venkatesh Pujari (Inactive) made changes -
            Time Spent 55h [ 198000 ] 61h [ 219600 ]
            Worklog Id 98076 [ 98076 ]
            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 ]
            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: Production QA(10203)Level 1 values: Production Deployed(10221) Parent values: Production QA(10203)Level 1 values: In Testing(10218)
            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 -
            Assignee Venkatesh Pujari [ venkatesh.pujari ] Debbie Kulling [ dkulling ]
            Resolution Fixed [ 1 ]
            Status Production Testing [ 10202 ] Production Complete [ 10028 ]
            venkatesh.pujari Venkatesh Pujari (Inactive) made changes -
            Time Spent 61h [ 219600 ] 68.5h [ 246600 ]
            Worklog Id 99049 [ 99049 ]
            prasanna Prasanna Karlekar (Inactive) made changes -
            Time Spent 68.5h [ 246600 ] 69h [ 248400 ]
            Worklog Id 99086 [ 99086 ]
            prasanna Prasanna Karlekar (Inactive) made changes -
            Time Spent 69h [ 248400 ] 69.5h [ 250200 ]
            Worklog Id 99097 [ 99097 ]
            prasanna Prasanna Karlekar (Inactive) made changes -
            Time Spent 69.5h [ 250200 ] 70.25h [ 252900 ]
            Worklog Id 99106 [ 99106 ]
            prasanna Prasanna Karlekar (Inactive) made changes -
            Remaining Estimate 0h [ 0 ] 0.75h [ 2700 ]
            Time Spent 70.25h [ 252900 ] 69.5h [ 250200 ]
            Worklog Id 99106 [ 99106 ]
            Worklog Time Spent 0.75h [ 2700 ]
            prasanna Prasanna Karlekar (Inactive) made changes -
            Link This issue causes WT-13063 [ WT-13063 ]
            dkulling Debbie Kulling made changes -
            Resolution Done [ 10000 ]
            Status Production Complete [ 10028 ] Closed [ 6 ]

              People

              Assignee:
              dkulling Debbie Kulling
              Reporter:
              dkulling Debbie Kulling
              Account Executive:
              Debbie Kulling
              Developer:
              Prasanna Karlekar (Inactive)
              QA:
              Venkatesh Pujari (Inactive)
              Votes:
              0 Vote for this issue
              Watchers:
              5 Start watching this issue

                Dates

                Created:
                Updated:
                Dev Due Date:
                Pre-Prod Due Date:
                Production Due Date:

                  Time Tracking

                  Estimated:
                  Original Estimate - 2h Original Estimate - 2h
                  2h
                  Remaining:
                  Time Spent - 69.5h Remaining Estimate - 0.75h
                  0.75h
                  Logged:
                  Time Spent - 69.5h Remaining Estimate - 0.75h
                  69.5h