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

            Hide
            gaurav.sodani Gaurav Sodani (Inactive) added a comment -

            Hi All,

            This ticket has been approved for stage deployment on 12/21/17.

            Regards
            Gaurav

            Show
            gaurav.sodani Gaurav Sodani (Inactive) added a comment - Hi All, This ticket has been approved for stage deployment on 12/21/17. Regards Gaurav
            Hide
            venkatesh.pujari Venkatesh Pujari (Inactive) added a comment -

            Hi Prasanna Karlekar,

            Tested the Retro Add and Retro Term scenarios along with ADD/TERM Policies on Stage on 2018 CHMC For HSPL company. They are working fine as expected. This is ready for Production.

            Sachin Hingole,Jyoti Agrawal,Hrishikesh Deshpande,Gaurav Sodani

            Thanks,
            Venkatesh

            Show
            venkatesh.pujari Venkatesh Pujari (Inactive) added a comment - Hi Prasanna Karlekar , Tested the Retro Add and Retro Term scenarios along with ADD/TERM Policies on Stage on 2018 CHMC For HSPL company. They are working fine as expected. This is ready for Production. Sachin Hingole , Jyoti Agrawal , Hrishikesh Deshpande , Gaurav Sodani Thanks, Venkatesh
            Hide
            gaurav.sodani Gaurav Sodani (Inactive) added a comment -

            Hi All,

            Attaching the production deployment approval email for reference

            Regards
            Gaurav

            Show
            gaurav.sodani Gaurav Sodani (Inactive) added a comment - Hi All, Attaching the production deployment approval email for reference Regards Gaurav
            Hide
            venkatesh.pujari Venkatesh Pujari (Inactive) added a comment -

            Hi Prasanna Karlekar,

            Tested the Retro Add and Retro Term scenarios along with ADD/TERM Policies on Production on AFI For HSPL company. They are working fine as expected.

            Sachin Hingole,Hrishikesh Deshpande,Jyoti Agrawal

            Thanks,
            Venkatesh

            Show
            venkatesh.pujari Venkatesh Pujari (Inactive) added a comment - Hi Prasanna Karlekar , Tested the Retro Add and Retro Term scenarios along with ADD/TERM Policies on Production on AFI For HSPL company. They are working fine as expected. Sachin Hingole , Hrishikesh Deshpande , Jyoti Agrawal Thanks, Venkatesh
            Hide
            venkatesh.pujari Venkatesh Pujari (Inactive) added a comment -

            Hi Debbie Kulling,

            The issues have been resolved and also tested on Production. Could you please verify and close this ticket.

            Thanks,
            Venkatesh

            Show
            venkatesh.pujari Venkatesh Pujari (Inactive) added a comment - Hi Debbie Kulling , The issues have been resolved and also tested on Production. Could you please verify and close this ticket. Thanks, Venkatesh

              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