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

Masters Gallery Foods - November Invoice Adjustments

    Details

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

      Description

      Hi,

      Per BCC:

      Debbie/Kira – We notice an issue with the November invoice of Masters Gallery in PROD. The employee is showing adjustments for November for the Critical Illness and Accident plans in error. There is not a rate difference in this change so I’m not sure why the system is trying to give an adjustment. Can you have these adjustments removed from the invoice. We are hoping to release tomorrow so if you can escalate it would be appreciated, thanks!

      Employee: Robert Grapentine

      Thank you,
      Kira Hamilton
      Debbie Kulling

        Attachments

          Issue Links

            Activity

            prasanna Prasanna Karlekar (Inactive) logged work - 08/Dec/17 10:00 PM
            • Time Spent:
              3h
               

              Issue analysis
              Discussion
              JIRA update

            prasanna Prasanna Karlekar (Inactive) logged work - 14/Dec/17 01:00 AM
            • Time Spent:
              0.25h
               

              JIRA update

            jyoti.agrawal Jyoti Agrawal (Inactive) logged work - 27/Dec/17 11:56 AM
            • Time Spent:
              2h
               

              Ticket go through
              Discussion with Prasanna
              Issue repro
              ETA analysis and update

            prasanna Prasanna Karlekar (Inactive) logged work - 27/Dec/17 10:00 PM
            • Time Spent:
              1h
               

              Issue discussion
              Discussion on steps for scenario repro
              discussion on ways to resolve issue

            jyoti.agrawal Jyoti Agrawal (Inactive) logged work - 29/Dec/17 12:43 PM
            • Time Spent:
              1h
               

              WBS preparation

            jyoti.agrawal Jyoti Agrawal (Inactive) logged work - 08/Jan/18 01:12 PM
            • Time Spent:
              5h
               

              Issue repro
              Issue analysis
              Discussion with Prasanna

            prasanna Prasanna Karlekar (Inactive) logged work - 09/Jan/18 12:30 AM
            • Time Spent:
              1h
               

              Discussion on cost calculations
              Approach to fix the issue - Not finalized

            jyoti.agrawal Jyoti Agrawal (Inactive) logged work - 09/Jan/18 12:59 PM
            • Time Spent:
              7h
               

              Analysis
              Discussion with Prasanna and NandKumar
              Final approach finalization

            prasanna Prasanna Karlekar (Inactive) logged work - 09/Jan/18 10:30 PM
            • Time Spent:
              1.5h
               

              Discussion on issue fix
              Approach to fix the issue is finalized

            jyoti.agrawal Jyoti Agrawal (Inactive) logged work - 10/Jan/18 01:12 PM
            • Time Spent:
              6.5h
               

              Coding
              Discussion with Prasanna

            prasanna Prasanna Karlekar (Inactive) logged work - 11/Jan/18 02:00 AM
            • Time Spent:
              0.75h
               

              Discussed about code changes

            prasanna Prasanna Karlekar (Inactive) logged work - 11/Jan/18 10:00 PM - edited
            • Time Spent:
              1.5h
               

              Discussion on code changes when latest cost to be returned is a negative cost
              Discussion on incorrect retro add in case of multiple Self Insured Components

            jyoti.agrawal Jyoti Agrawal (Inactive) logged work - 12/Jan/18 02:42 PM
            • Time Spent:
              5h
               

              Unit Testing
              Plans Considered :
              1) Health - Plan with Billed Rate
              Plan With Self Insured Component
              2 )Non Health

              Billing policies combination for above plans :
              1) Add - Prorated Term -Prorated
              2)Add - Entire Term - Entire
              3)Add - Entire Term - Prorated
              4)Add - Prorated Term -Entire
              5)Add - Entire Term - Waived Cut off
              6) Add - Waived Cut off Term - Entire
              7) Add - Waived Cut off Term - Waived Cut off

              For all above plans and billing policies, verified whether proper adjustments are being displayed on invoice when 2-3 times mid month election changes are done.

            prasanna Prasanna Karlekar (Inactive) logged work - 12/Jan/18 11:00 PM
            • Time Spent:
              0.5h
               

              Scenario discussion

            jyoti.agrawal Jyoti Agrawal (Inactive) logged work - 15/Jan/18 01:32 PM
            • Time Spent:
              5h
               
              • Code fix go through
              • Code patch creation for review
              • Code changes (suggested in review)
              • Code check-in
              • JIRA comment writing
              • Discussion with Prasanna
              • Script preparation
            prasanna Prasanna Karlekar (Inactive) logged work - 15/Jan/18 07:30 PM
            • Time Spent:
              2h
               

              Code and functionality review
              Go through of JIRA update details
              Discussion on changes required for Date format data type
              Scenario verification

            jyoti.agrawal Jyoti Agrawal (Inactive) logged work - 16/Jan/18 02:24 PM - edited
            • Time Spent:
              2h
               

              Script creation to update Monthly cost and Enrollment term date in all existing invoices

            venkatesh.pujari Venkatesh Pujari (Inactive) logged work - 18/Jan/18 09:00 AM
            • Time Spent:
              4h
               

              Testing on LB

            venkatesh.pujari Venkatesh Pujari (Inactive) logged work - 18/Jan/18 12:36 PM
            • Time Spent:
              3.5h
               

              Testing on LB

            venkatesh.pujari Venkatesh Pujari (Inactive) logged work - 19/Jan/18 09:04 AM
            • Time Spent:
              4h
               

              Testing on Stage

            prasanna Prasanna Karlekar (Inactive) logged work - 23/Jan/18 01:30 AM
            • Time Spent:
              1.5h
               

              Data correction script go through after patch deployment in Production environment
              Discussion on Cost update for Retro Term records
              Discussion on approach to cross verify

            jyoti.agrawal Jyoti Agrawal (Inactive) logged work - 24/Jan/18 12:28 PM
            • Time Spent:
              6h
               

              Updated data for newly added column on production in all companies
              Verified data in production

            prasanna Prasanna Karlekar (Inactive) logged work - 24/Jan/18 11:30 PM
            • Time Spent:
              1.5h
               

              Pair Programming:
              Discussion on Invoice verification after data updation script
              Discussion on discrepancies observerd before and after update script

            venkatesh.pujari Venkatesh Pujari (Inactive) logged work - 25/Jan/18 11:22 AM
            • Time Spent:
              2h
               

              Testing on Production

              People

              Assignee:
              Kira.Hamilton Kira Hamilton (Inactive)
              Reporter:
              Kira.Hamilton Kira Hamilton (Inactive)
              Account Executive:
              Debbie Kulling
              Developer:
              Jyoti Agrawal (Inactive)
              QA:
              Venkatesh Pujari (Inactive)
              Votes:
              0 Vote for this issue
              Watchers:
              4 Start watching this issue

                Dates

                Created:
                Updated:
                Resolved:
                Dev Due Date:
                Code Review Date:

                  Time Tracking

                  Estimated:
                  Original Estimate - 0h
                  0h
                  Remaining:
                  Remaining Estimate - 0h
                  0h
                  Logged:
                  Time Spent - 67.5h
                  67.5h