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

WT -> BCC Invoice Enhancement -> Same month billing and adjustment | Positive Negative Costs Sequence | Duplicate entries

    Details

    • Type: Change Request
    • Status: Closed
    • Priority: Medium
    • Resolution: Done
    • Affects Version/s: None
    • Fix Version/s: None
    • Component/s: BenAdmin
    • Labels:
      None
    • Module:
      BenAdmin - Report
    • Reported by:
      Harbinger
    • Item State:
      Production Complete - Closed
    • Sprint:
      WT Sprint 27

      Description

      Plan- Vision
      Rate - mapped rate has billed Rate (16)

      • enrollment exists from 09/01/2016 to 12/31/2016
      • fetched invoices for Sept Oct Nov 2016 - worked expected [showed billed rate costs ie, 16 in all months billing data]
      • changed billed rate value from 16 to 20
      • fetched invoice for Dec 2016 & below are the issues -
      1. though the invoice is for Dec 2016 : adjustments are also shown for the same month ie, Dec 2016 [this is not dependent on the Billing Period Policies flag on general plan design - checked]
      2. the positive and negative adjustments shown for the same month should be in same order. We can keep it as Positive first and then the Negative ones
      3. In case of enrollments in multiple plans within a benefit type - as discussed with Prasanna we are showing the only latest enrollments. Here system shown the duplicate records

      CC - Deepali Tidke Venkatesh PujariRakesh Roy Hrishikesh Deshpande

        Attachments

        1. #21.xlsx
          324 kB
        2. 7257 change rquest .doc
          42 kB
        3. Duplicate Entries.png
          Duplicate Entries.png
          141 kB
        4. Pos Neg Alternate.png
          Pos Neg Alternate.png
          138 kB
        5. Same Month Adjustment.png
          Same Month Adjustment.png
          89 kB

          Issue Links

            Activity

            Hide
            prasanna Prasanna Karlekar (Inactive) added a comment -

            Making this as change/request, as following was not considered:

            • Sequence of adjustments
            • Enrollments in multiple plans within a benefit type
            Show
            prasanna Prasanna Karlekar (Inactive) added a comment - Making this as change/request, as following was not considered: Sequence of adjustments Enrollments in multiple plans within a benefit type
            Hide
            jyoti.agrawal Jyoti Agrawal (Inactive) added a comment -

            Affected Areas :- Adjustment section of Invoice

            Affected DB Files :-

            1. OES_SP_Invoice_Display_BenefitWiseBilling
            2. OES_SP_Report_GetBillingDetailsColumnWise_InvoiceBenefitWise

            Tested Scenarios :-
            Tested sequence of positive negative cost

            • by selecting single benefit in template
            • by selecting multiple benefit in template
            • cost change in one plan
            • simultaneous cost/coverage change in multiple plans
            • Tier change
            • Cost/Coverage change for several employee for same month invoice
            Show
            jyoti.agrawal Jyoti Agrawal (Inactive) added a comment - Affected Areas :- Adjustment section of Invoice Affected DB Files :- OES_SP_Invoice_Display_BenefitWiseBilling OES_SP_Report_GetBillingDetailsColumnWise_InvoiceBenefitWise Tested Scenarios :- Tested sequence of positive negative cost by selecting single benefit in template by selecting multiple benefit in template cost change in one plan simultaneous cost/coverage change in multiple plans Tier change Cost/Coverage change for several employee for same month invoice
            Hide
            jyoti.agrawal Jyoti Agrawal (Inactive) added a comment -

            Hi Venkatesh Pujari,

            The issues mentioned in this ticket Same month billing and adjustment and Duplicate entries were fixed in WT-7760.
            Now we are giving fix for Positive Negative Costs Sequence only.

            Show
            jyoti.agrawal Jyoti Agrawal (Inactive) added a comment - Hi Venkatesh Pujari , The issues mentioned in this ticket Same month billing and adjustment and Duplicate entries were fixed in WT-7760 . Now we are giving fix for Positive Negative Costs Sequence only.
            Hide
            venkatesh.pujari Venkatesh Pujari (Inactive) added a comment -

            Hi Jyoti Agrawal,

            Tested the mentioned scenarios on LB on ASML company. In all the scenarios positive cost is displayed before any negative cost.If only negative cost is present then only negative is displayed correctly. This is ready for Stage

            Sachin Hingole

            Thanks,
            Venkatesh

            Show
            venkatesh.pujari Venkatesh Pujari (Inactive) added a comment - Hi Jyoti Agrawal , Tested the mentioned scenarios on LB on ASML company. In all the scenarios positive cost is displayed before any negative cost.If only negative cost is present then only negative is displayed correctly. This is ready for Stage Sachin Hingole Thanks, Venkatesh
            Hide
            venkatesh.pujari Venkatesh Pujari (Inactive) added a comment -

            Hi Jyoti Agrawal,

            Tested the mentioned scenarios on Stage on AFI For Hspl company. In all the scenarios positive cost is displayed before any negative cost.If only negative cost is present then only negative is displayed correctly. This is ready for Production

            Sachin Hingole

            Thanks,
            Venkatesh

            Show
            venkatesh.pujari Venkatesh Pujari (Inactive) added a comment - Hi Jyoti Agrawal , Tested the mentioned scenarios on Stage on AFI For Hspl company. In all the scenarios positive cost is displayed before any negative cost.If only negative cost is present then only negative is displayed correctly. This is ready for Production Sachin Hingole Thanks, Venkatesh
            Hide
            venkatesh.pujari Venkatesh Pujari (Inactive) added a comment -

            Hi Jyoti Agrawal,

            Tested the mentioned scenarios on Production on AFI For Hspl company. In all the scenarios positive cost is displayed before any negative cost.If only negative cost is present then only negative is displayed correctly.

            Sachin Hingole

            Thanks,
            Venkatesh

            Show
            venkatesh.pujari Venkatesh Pujari (Inactive) added a comment - Hi Jyoti Agrawal , Tested the mentioned scenarios on Production on AFI For Hspl company. In all the scenarios positive cost is displayed before any negative cost.If only negative cost is present then only negative is displayed correctly. Sachin Hingole Thanks, Venkatesh

              People

              Assignee:
              venkatesh.pujari Venkatesh Pujari (Inactive)
              Reporter:
              alankar.chavan Alankar Chavan (Inactive)
              Developer:
              Jyoti Agrawal (Inactive)
              Votes:
              0 Vote for this issue
              Watchers:
              3 Start watching this issue

                Dates

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

                  Time Tracking

                  Estimated:
                  Original Estimate - 6h Original Estimate - 6h
                  6h
                  Remaining:
                  Remaining Estimate - 0h
                  0h
                  Logged:
                  Time Spent - 32.25h
                  32.25h