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

TIBCO - August Invoice Issues

    XMLWordPrintable

    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
    • Dev Estimates:
      40
    • QA Estimates:
      8
    • Code Reviewed By:
      Prasanna Karlekar
    • Development Approval:
      Yes
    • Deployment Approval:
      Approved for production deployment

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

          Issue Links

            Activity

              People

              Assignee:
              dkulling Debbie Kulling
              Reporter:
              dkulling Debbie Kulling
              Account Executive:
              Debbie Kulling
              Developer:
              Prasanna Karlekar (Inactive)
              QA:
              Venkatesh Pujari
              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