Uploaded image for project: 'New Features 2017'
  1. New Features 2017
  2. NF-5137

County of Sutter-Invoice Adjustment Errors

    Details

    • Type: Bug
    • Status: Closed
    • Priority: Medium
    • Resolution: Bug Fixed
    • Affects Version/s: None
    • Fix Version/s: None
    • Component/s: UI Refresh
    • Labels:
      None
    • Environment:
      Others
    • Bug Severity:
      Medium
    • Module:
      BenAdmin
    • Reported by:
      Client
    • Company:
      All Clients/Multiple Clients
    • Item State:
      Stage QA - Ready for Production
    • Issue Importance:
      Must Have

      Description

      Hello,
      Per the client: County of Sutter has notified BCC they are having an issue with the billing adjustments on their August invoice (please see attached).

      We have looked into the issue with Harminder Dosanjh:
      1. Beginning May 1, 2017 when BCC begins administration of COSR, Employee is enrolled in the Anthem PPO 500 plan as Employee + 1 Child (Rate $1,463.00)
      2. On June 20, 2017 QE Add Newborn occurs, takes the Anthem PPO 500 plan enrollment to Employee + 2 Children (Rate $2,072.00)
      3. Billing rule is Free In/Pay Out and is built in the Billing Period Policies on the General Plan Design page as follows:
      a. Billing Period Adds = Premiums Waived After the Cut-Off Day; Day of Billing Period = 1
      b. Billing Period Changes/Terminations = Bill for Entire Month; Day of Billing Period = 0
      4. The August invoice incorrectly credits the June premium.
      5. The August invoice does correctly credit and bill the July adjustments
      6. The August invoice does correctly bill for the month of August
      Kenya Olivas is having the exact same issue as Harminder Dosanjh
      a. EE has been effective since 5/1/17 on the Anthem PPO 1000 plan with EE + SP + 2+ Children on the plan (Rate $1,698.00)
      b. On 6/23/17 QE Add Newborn was initiated for a baby born 5/24/17. This has no effect on the enrollment level as the EE already has 2+ Children on the plan
      c. Billing rule is Free In/Pay Out and is built in the Billing Period Policies on the General Plan Design page as follows:
      i. Billing Period Adds = Premiums Waived After the Cut-Off Day; Day of Billing Period = 1
      ii. Billing Period Changes/Terminations = Bill for Entire Month; Day of Billing Period = 0
      d. The August invoice incorrectly credits the May premium
      e. The August invoice does correctly credit and bill the June and July adjustments
      f. The August invoice does correctly bill for the month of August

      Could you please have your development team look into this ASAP, the group is extremely unhappy with their invoices.

        Attachments

          Issue Links

            Activity

            jyoti.agrawal Jyoti Agrawal (Inactive) created issue -
            jyoti.agrawal Jyoti Agrawal (Inactive) made changes -
            Field Original Value New Value
            Link This issue clones WT-11244 [ WT-11244 ]
            harshada.borole Harshada Borole (Inactive) made changes -
            Dev Due Date 27/Nov/2017
            harshada.borole Harshada Borole (Inactive) made changes -
            Status Open [ 1 ] In Development [ 10007 ]
            harshada.borole Harshada Borole (Inactive) made changes -
            Item State Parent values: Development(10200)Level 1 values: Ready for Local Testing(10209)
            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)
            harshada.borole Harshada Borole (Inactive) made changes -
            Assignee Jyoti Agrawal [ jyoti.agrawal ] Sachin Hingole [ sachin.hingole ]
            sachin.hingole Sachin Hingole (Inactive) made changes -
            Status In Development [ 10007 ] Local Testing [ 10200 ]
            sachin.hingole Sachin Hingole (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 -
            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 -
            Assignee Sachin Hingole [ sachin.hingole ] Jyoti Agrawal [ jyoti.agrawal ]
            venkatesh.pujari Venkatesh Pujari (Inactive) made changes -
            Remaining Estimate 4h [ 14400 ]
            Original Estimate 4h [ 14400 ]
            venkatesh.pujari Venkatesh Pujari (Inactive) made changes -
            Remaining Estimate 4h [ 14400 ] 0h [ 0 ]
            Time Spent 4h [ 14400 ]
            Worklog Id 94541 [ 94541 ]
            jyoti.agrawal Jyoti Agrawal (Inactive) made changes -
            Dev Due Date 27/Nov/2017 05/Dec/2017
            venkatesh.pujari Venkatesh Pujari (Inactive) made changes -
            Status Local Testing [ 10200 ] Reopen in Local [ 10018 ]
            jyoti.agrawal Jyoti Agrawal (Inactive) made changes -
            Status Reopen in Local [ 10018 ] In Development [ 10007 ]
            jyoti.agrawal Jyoti Agrawal (Inactive) made changes -
            Item State Parent values: LB QA(10201)Level 1 values: Re-open(10212) Parent values: Development(10200)Level 1 values: In Analysis(10204)
            venkatesh.pujari Venkatesh Pujari (Inactive) made changes -
            Time Spent 4h [ 14400 ] 5h [ 18000 ]
            Worklog Id 94541 [ 94541 ]
            jyoti.agrawal Jyoti Agrawal (Inactive) made changes -
            Time Spent 5h [ 18000 ] 7h [ 25200 ]
            Worklog Id 94586 [ 94586 ]
            jyoti.agrawal Jyoti Agrawal (Inactive) made changes -
            Item State Parent values: Development(10200)Level 1 values: In Analysis(10204) Parent values: Development(10200)Level 1 values: Ready for Review(10208)
            jyoti.agrawal Jyoti Agrawal (Inactive) made changes -
            Assignee Jyoti Agrawal [ jyoti.agrawal ] Prasanna Karlekar [ prasanna ]
            jyoti.agrawal Jyoti Agrawal (Inactive) made changes -
            Time Spent 7h [ 25200 ] 9h [ 32400 ]
            Worklog Id 94712 [ 94712 ]
            prasanna Prasanna Karlekar (Inactive) made changes -
            Item State Parent values: Development(10200)Level 1 values: Ready for Review(10208) Parent values: Development(10200)Level 1 values: Ready for Local Testing(10209)
            nidhi.kaul Nidhi Kaul (Inactive) made changes -
            Issue Importance Must Have [ 11800 ]
            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 ] Sachin Hingole [ sachin.hingole ]
            sachin.hingole Sachin Hingole (Inactive) made changes -
            Status In Development [ 10007 ] Local Testing [ 10200 ]
            sachin.hingole Sachin Hingole (Inactive) made changes -
            Assignee Sachin Hingole [ sachin.hingole ] Kunal Kedari [ kunal.kedari ]
            sachin.hingole Sachin Hingole (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)
            kunal.kedari Kunal Kedari (Inactive) made changes -
            Assignee Kunal Kedari [ kunal.kedari ] Venkatesh Pujari [ venkatesh.pujari ]
            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: Ready for Stage(10213)
            venkatesh.pujari Venkatesh Pujari (Inactive) made changes -
            Time Spent 9h [ 32400 ] 11h [ 39600 ]
            Worklog Id 97974 [ 97974 ]
            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)
            venkatesh.pujari Venkatesh Pujari (Inactive) made changes -
            Status Local Testing [ 10200 ] Stage Testing [ 10201 ]
            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: In Testing(10214)
            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 11h [ 39600 ] 13h [ 46800 ]
            Worklog Id 98393 [ 98393 ]
            prasanna Prasanna Karlekar (Inactive) made changes -
            Time Spent 13h [ 46800 ] 13.5h [ 48600 ]
            Worklog Id 99102 [ 99102 ]
            prasanna Prasanna Karlekar (Inactive) made changes -
            Time Spent 13.5h [ 48600 ] 13.75h [ 49500 ]
            Worklog Id 99105 [ 99105 ]
            venkatesh.pujari Venkatesh Pujari (Inactive) made changes -
            Status Stage Testing [ 10201 ] Production Testing [ 10202 ]
            venkatesh.pujari Venkatesh Pujari (Inactive) made changes -
            Time Spent 13.75h [ 49500 ] 15.75h [ 56700 ]
            Worklog Id 108132 [ 108132 ]
            venkatesh.pujari Venkatesh Pujari (Inactive) made changes -
            Resolution Bug Fixed [ 10402 ]
            Status Production Testing [ 10202 ] Production Complete [ 10028 ]
            venkatesh.pujari Venkatesh Pujari (Inactive) made changes -
            Status Production Complete [ 10028 ] Closed [ 6 ]

              People

              Assignee:
              venkatesh.pujari Venkatesh Pujari (Inactive)
              Reporter:
              jyoti.agrawal Jyoti Agrawal (Inactive)
              Votes:
              0 Vote for this issue
              Watchers:
              4 Start watching this issue

                Dates

                Created:
                Updated:
                Resolved:
                Dev Due Date:

                  Time Tracking

                  Estimated:
                  Original Estimate - 4h Original Estimate - 4h
                  4h
                  Remaining:
                  Remaining Estimate - 0h
                  0h
                  Logged:
                  Time Spent - 15.75h
                  15.75h