[WT-9293] Invoice Summary should have Volume and Coverage Months - Workterra Jira

Details

Type: Change Request
Status: Closed
Priority: High
Resolution: Done
Affects Version/s: None
Fix Version/s: None
Component/s: BenAdmin
Labels:
None

Module:
BenAdmin - Report
Reported by:
Client
Item State:
Production Complete - Closed
Issue Importance:
Must Have
Sprint:
WT Sprint 29
Severity:
Simple

Dev Estimates:
94
Code Reviewed By:

Prasanna Karlekar

Description

This JIRA is linked to ~~WT-8357~~.
Following changes are required to be done in current Invoice Summary:
1. Invoice Summary should include Volume for Life plans
2. Data should be populated per plan and Billing and Adjustment month wise.

For more details please refer ~~WT-8357~~ for more details.

Attachments

Options
- Sort By Name
- Sort By Date
- Ascending
- Descending
- Thumbnails
- List
- Download All

Attachments

ETA WT-9293 Invoice summary .xls
8 kB
05/May/17 12:20 PM
InvoiceSummary_Testcases.xls
36 kB
27/Jul/17 07:15 AM
InvoiceSummary.xls
10 kB
04/May/17 11:45 AM

Issue Links

relates to

WT-8357 Invoice Management Enhancement - Add invoice summary

Production Complete

NF-3361 Invoice Summary should have Volume and Coverage Months

Closed

WT-8007 BCC Invoice Management - Export Coverage corresponding to Rate

Pending for Approval

Activity

Ascending order - Click to sort in descending order

Prasanna Karlekar (Inactive) created issue - 21/Apr/17 09:27 AM

Prasanna Karlekar (Inactive) made changes - 21/Apr/17 09:28 AM

Field	Original Value	New Value
Summary	Invoice Summary having Volume and Coverage Months	Invoice Summary should have Volume and Coverage Months

Satya made changes - 24/Apr/17 11:36 AM

Link

This issue relates to ~~WT-8357~~ [ ~~WT-8357~~ ]

Satya made changes - 24/Apr/17 12:37 PM

Sprint

WT Sprint 28 [ 53 ]

Prasanna Karlekar (Inactive) made changes - 25/Apr/17 07:09 AM

Status

New Request [ 10029 ]

Pending for Approval [ 10002 ]

Prasanna Karlekar (Inactive) made changes - 25/Apr/17 07:10 AM

Status

Pending for Approval [ 10002 ]

Approved for Development [ 10003 ]

Jyoti Agrawal (Inactive) made changes - 25/Apr/17 09:07 AM

Link

This issue relates to WT-8007 [ WT-8007 ]

Permalink

Jyoti Agrawal (Inactive) logged work - 26/Apr/17 05:43 PM

Time Spent:

2h

Analysis, discussion

Jyoti Agrawal (Inactive) made changes - 27/Apr/17 05:44 AM

Remaining Estimate		0h [ 0 ]
Time Spent		2h [ 7200 ]
Worklog Id		41135 [ 41135 ]

Permalink

Jyoti Agrawal (Inactive) logged work - 27/Apr/17 06:25 PM

Time Spent:

3h

ETA analysis

Jyoti Agrawal (Inactive) made changes - 28/Apr/17 06:25 AM

Time Spent	2h [ 7200 ]	5h [ 18000 ]
Worklog Id		41763 [ 41763 ]

Permalink

Jyoti Agrawal (Inactive) logged work - 28/Apr/17 08:56 AM

Time Spent:

4h

Analysis

Jyoti Agrawal (Inactive) made changes - 28/Apr/17 08:56 AM

Time Spent	5h [ 18000 ]	9h [ 32400 ]
Worklog Id		42042 [ 42042 ]

Permalink

Jyoti Agrawal (Inactive) logged work - 02/May/17 04:09 PM

Time Spent:

5h

Analysis, queries find out, documentation, discussion

Permalink

Prasanna Karlekar (Inactive) logged work - 03/May/17 12:30 AM

Time Spent:

0.75h

Invoice Summary Query document go through and review

Jyoti Agrawal (Inactive) made changes - 03/May/17 04:10 AM

Time Spent	9h [ 32400 ]	14h [ 50400 ]
Worklog Id		42766 [ 42766 ]

Permalink

Jyoti Agrawal (Inactive) logged work - 03/May/17 04:22 PM

Time Spent:

1h

Documentation, discussion with Prasanna regarding client call

Permalink

Prasanna Karlekar (Inactive) logged work - 04/May/17 10:30 AM

Time Spent:

1h

Discussion and Review for Query related to Invoice Summary on UI

Jyoti Agrawal (Inactive) made changes - 04/May/17 11:45 AM

Attachment

InvoiceSummary.xls [ 47011 ]

Hide

Permalink

Jyoti Agrawal (Inactive) added a comment - 04/May/17 12:26 PM

Hi Debbie Kulling,

Yesterday while discusing changes related to invoice summary we had only considered the export to excel part.
How it should appear on UI was not considered by us, so this was not discussed in yesterday's call.
We think that Invoice Summary on UI should appear the same way as it is appearing currently, i.e. Plan wise display only.
But this will create difference in look and feel as excel will have more detailed version and on UI it will be just planwise summary.

In attached excel, on Tab named "Excel", we have shown how it will appear in Excel after download is done.
On Tab named "UI", we have shown how it will appear on UI.

Could you please confirm, whether both excel and UI output for summary is fine or not?

Thanks,
Jyoti Agrawal

Show

Jyoti Agrawal (Inactive) added a comment - 04/May/17 12:26 PM Hi Debbie Kulling , Yesterday while discusing changes related to invoice summary we had only considered the export to excel part. How it should appear on UI was not considered by us, so this was not discussed in yesterday's call. We think that Invoice Summary on UI should appear the same way as it is appearing currently, i.e. Plan wise display only. But this will create difference in look and feel as excel will have more detailed version and on UI it will be just planwise summary. In attached excel, on Tab named "Excel", we have shown how it will appear in Excel after download is done. On Tab named "UI", we have shown how it will appear on UI. Could you please confirm, whether both excel and UI output for summary is fine or not? Thanks, Jyoti Agrawal

Jyoti Agrawal (Inactive) made changes - 04/May/17 01:05 PM

Assignee

Jyoti Agrawal [ jyoti.agrawal ]

Debbie Kulling [ dkulling ]

Hide

Permalink

Debbie Kulling added a comment - 04/May/17 01:15 PM

I am checking with BCC. I will get back to you asap

Show

Debbie Kulling added a comment - 04/May/17 01:15 PM I am checking with BCC. I will get back to you asap

Permalink

Jyoti Agrawal (Inactive) logged work - 04/May/17 04:26 PM

Time Spent:

8h

Analysis of implementation, documentation for queries, discussion with Prasanna

Jyoti Agrawal (Inactive) made changes - 05/May/17 04:23 AM

Time Spent	14h [ 50400 ]	15h [ 54000 ]
Worklog Id		43259 [ 43259 ]

Jyoti Agrawal (Inactive) made changes - 05/May/17 04:27 AM

Time Spent	15h [ 54000 ]	23h [ 82800 ]
Worklog Id		43264 [ 43264 ]

Jyoti Agrawal (Inactive) made changes - 05/May/17 10:43 AM

Item State		Parent values: Development(10200)Level 1 values: In Analysis(10204)
Original Estimate		0h [ 0 ]

Jyoti Agrawal (Inactive) made changes - 05/May/17 10:43 AM

Status

Approved for Development [ 10003 ]

In Development [ 10007 ]

Prasanna Karlekar (Inactive) made changes - 05/May/17 11:52 AM

Time Spent	23h [ 82800 ]	23.75h [ 85500 ]
Worklog Id		43382 [ 43382 ]

Prasanna Karlekar (Inactive) made changes - 05/May/17 12:01 PM

Time Spent	23.75h [ 85500 ]	24.75h [ 89100 ]
Worklog Id		43401 [ 43401 ]

Prasanna Karlekar (Inactive) made changes - 05/May/17 12:04 PM

Time Spent	24.75h [ 89100 ]	25.5h [ 91800 ]
Worklog Id		43405 [ 43405 ]

Jyoti Agrawal (Inactive) made changes - 05/May/17 12:20 PM

Attachment

ETA WT-9293 Invoice summary .xls [ 47083 ]

Jyoti Agrawal (Inactive) made changes - 05/May/17 12:20 PM

Dev Estimates

Permalink

Jyoti Agrawal (Inactive) logged work - 05/May/17 01:00 PM

Time Spent:

7.5h

ETA preparation, Implementation Analysis, coding

Jyoti Agrawal (Inactive) made changes - 05/May/17 01:01 PM

Time Spent	25.5h [ 91800 ]	33h [ 118800 ]
Worklog Id		43507 [ 43507 ]

Permalink

Prasanna Karlekar (Inactive) logged work - 05/May/17 09:30 PM

Time Spent:

0.75h

Discussion on Task breakdown for Invoice Summary
Queries related to Summary

Satya made changes - 08/May/17 06:02 AM

Sprint

WT Sprint 28 [ 53 ]

WT Sprint 29 [ 62 ]

Jyoti Agrawal (Inactive) made changes - 08/May/17 06:12 AM

Item State

Parent values: Development(10200)Level 1 values: In Analysis(10204)

Parent values: Development(10200)Level 1 values: In Progress(10206)

Permalink

Jyoti Agrawal (Inactive) logged work - 08/May/17 04:30 PM

Time Spent:

7.5h

Analysis, coding

Permalink

Jyoti Agrawal (Inactive) logged work - 09/May/17 04:34 PM

Time Spent:

6.5h

R&D for new implementation, coding

Jyoti Agrawal (Inactive) made changes - 10/May/17 04:31 AM

Time Spent	33h [ 118800 ]	40.5h [ 145800 ]
Worklog Id		44221 [ 44221 ]

Jyoti Agrawal (Inactive) made changes - 10/May/17 04:35 AM

Time Spent	40.5h [ 145800 ]	47h [ 169200 ]
Worklog Id		44223 [ 44223 ]

Hide

Permalink

Jyoti Agrawal (Inactive) added a comment - 10/May/17 12:39 PM

Hi Debbie Kulling,

We have started with the development of 'Excel' part of Invoice Summary. It will be helpful if you update us on how to display summary on UI.

Thanks,
Jyoti Agrawal

Show

Jyoti Agrawal (Inactive) added a comment - 10/May/17 12:39 PM Hi Debbie Kulling , We have started with the development of 'Excel' part of Invoice Summary. It will be helpful if you update us on how to display summary on UI. Thanks, Jyoti Agrawal

Satya made changes - 10/May/17 12:49 PM

Dev Estimates

Satya made changes - 10/May/17 12:49 PM

Dev Estimates

Vijay Siddha (Inactive) made changes - 10/May/17 12:51 PM

Original Estimate

0h [ 0 ]

94h [ 338400 ]

Permalink

Jyoti Agrawal (Inactive) logged work - 10/May/17 01:54 PM

Time Spent:

5h

Coding

Jyoti Agrawal (Inactive) made changes - 11/May/17 01:55 PM

Time Spent	47h [ 169200 ]	52h [ 187200 ]
Worklog Id		44857 [ 44857 ]

Permalink

Lalit Kumar (Inactive) logged work - 12/May/17 07:33 AM

Time Spent:

0.5h

Client Call

Hide

Permalink

Lalit Kumar (Inactive) added a comment - 12/May/17 01:20 PM

Below are updates from meeting on Friday 12 May.

1. Excel and UI for invoice summary needs to be same.
2. The current option to select number of records to display is fine.
3. Excel functionality can be delivered first followed by invoice summary on UI.

CC: Satya,Prasanna Karlekar,Jyoti Agrawal,Venkatesh Pujari

Regards,
Lalit Kumar

Show

Lalit Kumar (Inactive) added a comment - 12/May/17 01:20 PM Below are updates from meeting on Friday 12 May. 1. Excel and UI for invoice summary needs to be same. 2. The current option to select number of records to display is fine. 3. Excel functionality can be delivered first followed by invoice summary on UI. CC: Satya , Prasanna Karlekar , Jyoti Agrawal , Venkatesh Pujari Regards, Lalit Kumar

Permalink

Jyoti Agrawal (Inactive) logged work - 12/May/17 02:10 PM

Time Spent:

7h

Coding, testing, client call

Jyoti Agrawal (Inactive) made changes - 12/May/17 02:12 PM

Time Spent	52h [ 187200 ]	59h [ 212400 ]
Worklog Id		45314 [ 45314 ]

Jyoti Agrawal (Inactive) made changes - 12/May/17 02:12 PM

Assignee

Debbie Kulling [ dkulling ]

Jyoti Agrawal [ jyoti.agrawal ]

Permalink

Jyoti Agrawal (Inactive) logged work - 15/May/17 04:05 PM

Time Spent:

6h

Test cases preparation, discussion with Prasanna, Coding

Permalink

Prasanna Karlekar (Inactive) logged work - 15/May/17 10:30 PM

Time Spent:

3.5h

Analysis for month wise ordering issue for Invoice Summary

Jyoti Agrawal (Inactive) made changes - 16/May/17 04:06 AM

Time Spent	59h [ 212400 ]	65h [ 234000 ]
Worklog Id		45717 [ 45717 ]

Permalink

Venkatesh Pujari (Inactive) logged work - 16/May/17 07:49 AM

Time Spent:

4h

Test cases

Hide

Permalink

Venkatesh Pujari (Inactive) added a comment - 16/May/17 07:49 AM

Hi Jyoti Agrawal,

Please find the attached test cases for Invoice summary tab only. Also let me know if anything needs to be added in these.

Prasanna Karlekar,Sachin Hingole

Thanks,
Venkatesh

Show

Venkatesh Pujari (Inactive) added a comment - 16/May/17 07:49 AM Hi Jyoti Agrawal , Please find the attached test cases for Invoice summary tab only. Also let me know if anything needs to be added in these. Prasanna Karlekar , Sachin Hingole Thanks, Venkatesh

Venkatesh Pujari (Inactive) made changes - 16/May/17 07:49 AM

Attachment

InvoiceSummary_Testcases.xls [ 48237 ]

Venkatesh Pujari (Inactive) made changes - 16/May/17 07:50 AM

Time Spent	65h [ 234000 ]	69h [ 248400 ]
Worklog Id		45821 [ 45821 ]

Venkatesh Pujari (Inactive) made changes - 16/May/17 09:17 AM

Attachment

InvoiceSummary_Testcases.xls [ 48237 ]

Permalink

Venkatesh Pujari (Inactive) logged work - 16/May/17 09:18 AM

Time Spent:

1h

Updated test cases

Venkatesh Pujari (Inactive) made changes - 16/May/17 09:18 AM

Attachment

InvoiceSummary_Testcases.xls [ 48304 ]

Venkatesh Pujari (Inactive) made changes - 16/May/17 09:18 AM

Time Spent	69h [ 248400 ]	70h [ 252000 ]
Worklog Id		45929 [ 45929 ]

Permalink

Jyoti Agrawal (Inactive) logged work - 16/May/17 04:30 PM

Time Spent:

8h

Coding, testing, discussion

Permalink

Prasanna Karlekar (Inactive) logged work - 16/May/17 07:00 PM

Time Spent:

1h

Analysis and coding to do ordering in different way
Discussion on Invoice summary output on excel

Prasanna Karlekar (Inactive) made changes - 17/May/17 08:08 AM

Time Spent	70h [ 252000 ]	73.5h [ 264600 ]
Worklog Id		46250 [ 46250 ]

Prasanna Karlekar (Inactive) made changes - 17/May/17 08:16 AM

Time Spent	73.5h [ 264600 ]	74.5h [ 268200 ]
Worklog Id		46301 [ 46301 ]

Jyoti Agrawal (Inactive) made changes - 17/May/17 11:28 AM

Item State

Parent values: Development(10200)Level 1 values: In Progress(10206)

Parent values: Development(10200)Level 1 values: Ready for Review(10208)

Permalink

Jyoti Agrawal (Inactive) logged work - 17/May/17 01:04 PM

Time Spent:

8h

Coding, testing, discussion

Jyoti Agrawal (Inactive) made changes - 17/May/17 01:04 PM

Time Spent	74.5h [ 268200 ]	82.5h [ 297000 ]
Worklog Id		46470 [ 46470 ]

Jyoti Agrawal (Inactive) made changes - 17/May/17 01:05 PM

Code Review Date

18/May/2017

Hide

Permalink

Jyoti Agrawal (Inactive) added a comment - 17/May/17 01:10 PM

Affected Areas : Invoice Summary in Excel

Affected files :
OES_SP_Report_GetBillingDetailsColumnWise_InvoiceBenefitWise
OES_SP_GetInvoiceSummary
CreateExcelFile.cs
InvoiceExportDetails.cs

Tested scenarios :-
Indivisual record :-
Correct enrollment count
Correct member count
Correct Volume sum
Correct Total sum

Plan level:-
All plans in one block
'Benefit Wise Total' after every plan block
Correct month order
Different +ve and -ve adjustment
Correct sum up all adjustment records
Correct 'Benefit Wise Total' records

Benefit level:-
One benefit in one block
'Benefit Wise Total' after every benefit level
Correct total

Grand total :-
Correct grand total

Show

Jyoti Agrawal (Inactive) added a comment - 17/May/17 01:10 PM Affected Areas : Invoice Summary in Excel Affected files : OES_SP_Report_GetBillingDetailsColumnWise_InvoiceBenefitWise OES_SP_GetInvoiceSummary CreateExcelFile.cs InvoiceExportDetails.cs Tested scenarios :- Indivisual record :- Correct enrollment count Correct member count Correct Volume sum Correct Total sum Plan level:- All plans in one block 'Benefit Wise Total' after every plan block Correct month order Different +ve and -ve adjustment Correct sum up all adjustment records Correct 'Benefit Wise Total' records Benefit level:- One benefit in one block 'Benefit Wise Total' after every benefit level Correct total Grand total :- Correct grand total

Khandu Kshirsagar (Inactive) made changes - 18/May/17 11:33 AM

Item State

Parent values: Development(10200)Level 1 values: Ready for Review(10208)

Parent values: LB QA(10201)Level 1 values: LB Deployed(11600)

Jyoti Agrawal (Inactive) made changes - 18/May/17 12:04 PM

Assignee

Jyoti Agrawal [ jyoti.agrawal ]

Sachin Hingole [ sachin.hingole ]

Permalink

Jyoti Agrawal (Inactive) logged work - 18/May/17 04:23 PM

Time Spent:

1.5h

Discussion on code review, Code changes after review, testing, code checkin

Venkatesh Pujari (Inactive) made changes - 19/May/17 04:18 AM

Assignee

Sachin Hingole [ sachin.hingole ]

Venkatesh Pujari [ venkatesh.pujari ]

Jyoti Agrawal (Inactive) made changes - 19/May/17 04:25 AM

Time Spent	82.5h [ 297000 ]	84h [ 302400 ]
Worklog Id		46850 [ 46850 ]

Jyoti Agrawal (Inactive) made changes - 19/May/17 04:30 AM

Time Spent	84h [ 302400 ]	92h [ 331200 ]
Worklog Id		46855 [ 46855 ]

Venkatesh Pujari (Inactive) made changes - 19/May/17 05:29 AM

Status

In Development [ 10007 ]

Local Testing [ 10200 ]

Venkatesh Pujari (Inactive) made changes - 19/May/17 05:29 AM

Item State

Parent values: LB QA(10201)Level 1 values: LB Deployed(11600)

Parent values: LB QA(10201)Level 1 values: In Testing(10210)

Permalink

Venkatesh Pujari (Inactive) logged work - 19/May/17 11:56 AM

Time Spent:

3h

Testing on LB

Venkatesh Pujari (Inactive) made changes - 19/May/17 11:56 AM

Time Spent	92h [ 331200 ]	95h [ 342000 ]
Worklog Id		47068 [ 47068 ]

Hide

Permalink

Venkatesh Pujari (Inactive) added a comment - 19/May/17 01:01 PM

Hi Jyoti Agrawal,

Testing is in progress. Will update you once all scenarios are tested.

Thanks,
Venkatesh

Show

Venkatesh Pujari (Inactive) added a comment - 19/May/17 01:01 PM Hi Jyoti Agrawal , Testing is in progress. Will update you once all scenarios are tested. Thanks, Venkatesh

Permalink

Prasanna Karlekar (Inactive) logged work - 19/May/17 11:30 PM

Time Spent:

0.25h

Invoice Summary
Issue discussion with QA

Permalink

Venkatesh Pujari (Inactive) logged work - 22/May/17 07:18 AM

Time Spent:

3h

Scenario testing on LB

Venkatesh Pujari (Inactive) made changes - 22/May/17 07:18 AM

Time Spent	95h [ 342000 ]	98h [ 352800 ]
Worklog Id		47544 [ 47544 ]

Hide

Permalink

Venkatesh Pujari (Inactive) added a comment - 22/May/17 09:37 AM

Hi Jyoti Agrawal,

I have tested this enhancement on LB on ASML and City of Durham companies. Tested the below listed scenarios and they seem to be working as per expectation:-

Individual record :-
Correct enrollment count
Correct member count
Correct Volume sum
Correct Total sum

Plan level:-
All plans in one block
'Benefit Wise Total' after every plan block
Correct month order
Different +ve and -ve adjustment
Correct sum up all adjustment records
Correct 'Benefit Wise Total' records

Benefit level:-
One benefit in one block
'Benefit Wise Total' after every benefit level
Correct total

Grand total :-
Correct grand total

Also verified by changing the coverage after first invoice is generated. Proper adjustments are displayed on the next invoice

This is ready for Stage

Sachin Hingole,Prasanna Karlekar

Thanks,
Venkatesh

Show

Venkatesh Pujari (Inactive) added a comment - 22/May/17 09:37 AM Hi Jyoti Agrawal , I have tested this enhancement on LB on ASML and City of Durham companies. Tested the below listed scenarios and they seem to be working as per expectation:- Individual record :- Correct enrollment count Correct member count Correct Volume sum Correct Total sum Plan level :- All plans in one block 'Benefit Wise Total' after every plan block Correct month order Different +ve and -ve adjustment Correct sum up all adjustment records Correct 'Benefit Wise Total' records Benefit level :- One benefit in one block 'Benefit Wise Total' after every benefit level Correct total Grand total :- Correct grand total Also verified by changing the coverage after first invoice is generated. Proper adjustments are displayed on the next invoice This is ready for Stage Sachin Hingole , Prasanna Karlekar Thanks, Venkatesh

Permalink

Venkatesh Pujari (Inactive) logged work - 22/May/17 09:38 AM

Time Spent:

2h

Testing on LB for all the scenarios mentioned

Venkatesh Pujari (Inactive) made changes - 22/May/17 09:38 AM

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 (Inactive) made changes - 22/May/17 09:38 AM

Time Spent	98h [ 352800 ]	100h [ 360000 ]
Worklog Id		47616 [ 47616 ]

Permalink

Prasanna Karlekar (Inactive) logged work - 22/May/17 10:00 PM

Time Spent:

0.5h

Invoice discussion of retro add records and summary

Khandu Kshirsagar (Inactive) made changes - 24/May/17 07:09 AM

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)

Permalink

Jyoti Agrawal (Inactive) logged work - 24/May/17 12:48 PM

Time Spent:

0.25h

code check-in

Permalink

Jyoti Agrawal (Inactive) logged work - 24/May/17 12:49 PM

Time Spent:

4h

Coding, testing, code review, code check-in

Venkatesh Pujari (Inactive) made changes - 24/May/17 05:15 PM

Status

Local Testing [ 10200 ]

Pending for Stage Approval [ 10300 ]

Venkatesh Pujari (Inactive) made changes - 24/May/17 05:15 PM

Status

Pending for Stage Approval [ 10300 ]

Approved for Stage [ 10030 ]

Venkatesh Pujari (Inactive) made changes - 24/May/17 05:15 PM

Status

Approved for Stage [ 10030 ]

Stage Testing [ 10201 ]

Venkatesh Pujari (Inactive) made changes - 25/May/17 05:20 AM

Item State

Parent values: Stage QA(10202)Level 1 values: Stage Deployed(11602)

Parent values: Stage QA(10202)Level 1 values: In Testing(10214)

Lalit Kumar (Inactive) made changes - 25/May/17 07:33 AM

Time Spent	100h [ 360000 ]	100.5h [ 361800 ]
Worklog Id		48662 [ 48662 ]

Permalink

Venkatesh Pujari (Inactive) logged work - 25/May/17 10:24 AM

Time Spent:

6h

Testing on Stage

Venkatesh Pujari (Inactive) made changes - 25/May/17 10:24 AM

Time Spent	100.5h [ 361800 ]	106.5h [ 383400 ]
Worklog Id		48759 [ 48759 ]

Jyoti Agrawal (Inactive) made changes - 25/May/17 12:48 PM

Time Spent	106.5h [ 383400 ]	106.75h [ 384300 ]
Worklog Id		48879 [ 48879 ]

Jyoti Agrawal (Inactive) made changes - 25/May/17 12:49 PM

Time Spent	106.75h [ 384300 ]	110.75h [ 398700 ]
Worklog Id		48881 [ 48881 ]

Permalink

Venkatesh Pujari (Inactive) logged work - 25/May/17 04:09 PM

Time Spent:

2h

Stage testing

Hide

Permalink

Venkatesh Pujari (Inactive) added a comment - 26/May/17 04:09 AM - edited

Hi Jyoti Agrawal,

I have tested this enhancement on Stage on AFI For Hspl company. Tested the below listed scenarios and they seem to be working as per expectation:-

Individual record :-
Correct enrollment count
Correct member count
Correct Volume sum
Correct Total sum

Benefit level:-
One benefit in one block
'Benefit Wise Total' after every benefit level
Correct total

Grand total :-
Correct grand total
Also verified by changing the coverage after first invoice is generated. Proper adjustments are displayed on the next invoice

This is ready for Production.

Sachin Hingole,Prasanna Karlekar

Thanks,
Venkatesh

Show

Venkatesh Pujari (Inactive) added a comment - 26/May/17 04:09 AM - edited Hi Jyoti Agrawal , I have tested this enhancement on Stage on AFI For Hspl company. Tested the below listed scenarios and they seem to be working as per expectation:- Individual record :- Correct enrollment count Correct member count Correct Volume sum Correct Total sum Plan level:- All plans in one block 'Benefit Wise Total' after every plan block Correct month order Different +ve and -ve adjustment Correct sum up all adjustment records Correct 'Benefit Wise Total' records Benefit level:- One benefit in one block 'Benefit Wise Total' after every benefit level Correct total Grand total :- Correct grand total Also verified by changing the coverage after first invoice is generated. Proper adjustments are displayed on the next invoice This is ready for Production. Sachin Hingole , Prasanna Karlekar Thanks, Venkatesh

Venkatesh Pujari (Inactive) made changes - 26/May/17 04:10 AM

Time Spent	110.75h [ 398700 ]	112.75h [ 405900 ]
Worklog Id		49020 [ 49020 ]

Venkatesh Pujari (Inactive) made changes - 26/May/17 04:10 AM

Status

Stage Testing [ 10201 ]

Pending for Production Approval [ 10301 ]

Venkatesh Pujari (Inactive) made changes - 26/May/17 04:10 AM

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)

Hide

Permalink

Venkatesh Pujari (Inactive) added a comment - 26/May/17 05:16 AM

Hi Debbie Kulling,

The enhancement has been deployed on Stage and also tested by QA. Please could you also verify at your end. Below are the points which are not covered in this ticket:-

1] Covered Salary part is not done
2] Family rates coverage part is also not covered yet.

Please let us know if you have any queries on this

Prasanna Karlekar

Thanks,
Venkatesh

Show

Venkatesh Pujari (Inactive) added a comment - 26/May/17 05:16 AM Hi Debbie Kulling , The enhancement has been deployed on Stage and also tested by QA. Please could you also verify at your end. Below are the points which are not covered in this ticket:- 1] Covered Salary part is not done 2] Family rates coverage part is also not covered yet. Please let us know if you have any queries on this Prasanna Karlekar Thanks, Venkatesh

Prasanna Karlekar (Inactive) made changes - 26/May/17 06:59 AM

Time Spent	112.75h [ 405900 ]	113h [ 406800 ]
Worklog Id		49102 [ 49102 ]

Prasanna Karlekar (Inactive) made changes - 26/May/17 07:03 AM

Time Spent	113h [ 406800 ]	113.5h [ 408600 ]
Worklog Id		49107 [ 49107 ]

Khandu Kshirsagar (Inactive) made changes - 30/May/17 06:45 AM

Item State

Parent values: Stage QA(10202)Level 1 values: Ready for Production(10217)

Parent values: Production QA(10203)Level 1 values: Production Deployed(10221)

Venkatesh Pujari (Inactive) made changes - 30/May/17 08:35 AM

Status

Pending for Production Approval [ 10301 ]

Approved for production [ 10034 ]

Venkatesh Pujari (Inactive) made changes - 30/May/17 08:35 AM

Status

Approved for production [ 10034 ]

Production Testing [ 10202 ]

Venkatesh Pujari (Inactive) made changes - 30/May/17 08:35 AM

Item State

Parent values: Production QA(10203)Level 1 values: Production Deployed(10221)

Parent values: Production QA(10203)Level 1 values: In Testing(10218)

Venkatesh Pujari (Inactive) made changes - 30/May/17 11:16 AM

Item State

Parent values: Production QA(10203)Level 1 values: In Testing(10218)

Parent values: Production Complete(10222)Level 1 values: Closed(10223)

Permalink

Venkatesh Pujari (Inactive) logged work - 30/May/17 11:28 AM - edited

Time Spent:

3h

Testing on Production

Hide

Permalink

Venkatesh Pujari (Inactive) added a comment - 30/May/17 11:28 AM

Hi Debbie Kulling,

This request has been deployed on production and also tested. Please could you verify and let us know if you have any queries on this.

Prasanna Karlekar,Jyoti Agrawal

Thanks,
Venkatesh

Show

Venkatesh Pujari (Inactive) added a comment - 30/May/17 11:28 AM Hi Debbie Kulling , This request has been deployed on production and also tested. Please could you verify and let us know if you have any queries on this. Prasanna Karlekar , Jyoti Agrawal Thanks, Venkatesh

Venkatesh Pujari (Inactive) made changes - 30/May/17 11:28 AM

Assignee	Venkatesh Pujari [ venkatesh.pujari ]	Debbie Kulling [ dkulling ]
Resolution		Done [ 10000 ]
Status	Production Testing [ 10202 ]	Production Complete [ 10028 ]

Venkatesh Pujari (Inactive) made changes - 30/May/17 11:28 AM

Time Spent	113.5h [ 408600 ]	115.5h [ 415800 ]
Worklog Id		50345 [ 50345 ]

Venkatesh Pujari (Inactive) made changes - 30/May/17 11:29 AM

Time Spent	115.5h [ 415800 ]	116.5h [ 419400 ]
Worklog Id		50345 [ 50345 ]

Permalink

Jyoti Agrawal (Inactive) logged work - 30/May/17 05:49 PM - edited

Time Spent:

1.5h

Code check-in in production, Script execution for existing companies, data verification, discussion

Permalink

Prasanna Karlekar (Inactive) logged work - 30/May/17 09:00 PM

Time Spent:

0.5h

Discussion on Coverage Member Count update for existing data

Jyoti Agrawal (Inactive) made changes - 31/May/17 05:51 AM

Time Spent	116.5h [ 419400 ]	118h [ 424800 ]
Worklog Id		50803 [ 50803 ]

Jyoti Agrawal (Inactive) made changes - 31/May/17 05:56 AM

Worklog Id

50803 [ 50803 ]

Prasanna Karlekar (Inactive) made changes - 31/May/17 11:39 AM

Time Spent	118h [ 424800 ]	118.5h [ 426600 ]
Worklog Id		51122 [ 51122 ]

Rakesh Roy (Inactive) made changes - 09/Jun/17 11:06 AM

Resolution	Done [ 10000 ]	Fixed [ 1 ]
Status	Production Complete [ 10028 ]	Closed [ 6 ]

Jyoti Agrawal (Inactive) made changes - 07/Jul/17 10:05 AM

Link

This issue relates to ~~NF-3361~~ [ ~~NF-3361~~ ]

Venkatesh Pujari (Inactive) made changes - 27/Jul/17 07:15 AM

Attachment

InvoiceSummary_Testcases.xls [ 48304 ]

Venkatesh Pujari (Inactive) made changes - 27/Jul/17 07:15 AM

Attachment

InvoiceSummary_Testcases.xls [ 56914 ]

Transition	Time In Source Status	Execution Times

Prasanna Karlekar (Inactive) made transition - 25/Apr/17 07:09 AM

New Request

Pending for Approval

3d 21h 42m

Prasanna Karlekar (Inactive) made transition - 25/Apr/17 07:10 AM

Pending for Approval

Approved for Development

Jyoti Agrawal (Inactive) made transition - 05/May/17 10:43 AM

Approved for Development

In Development

10d 3h 33m

Venkatesh Pujari (Inactive) made transition - 19/May/17 05:29 AM

In Development

In LB Testing

13d 18h 46m

Venkatesh Pujari (Inactive) made transition - 24/May/17 05:15 PM

In LB Testing

Pending for Stage Approval

5d 11h 45m

Venkatesh Pujari (Inactive) made transition - 24/May/17 05:15 PM

Pending for Stage Approval

Approved for Stage

Venkatesh Pujari (Inactive) made transition - 24/May/17 05:15 PM

Approved for Stage

Stage Testing

Venkatesh Pujari (Inactive) made transition - 26/May/17 04:10 AM

Stage Testing

Pending for Production Approval

1d 10h 54m

Venkatesh Pujari (Inactive) made transition - 30/May/17 08:35 AM

Pending for Production Approval

Approved for production

4d 4h 25m

Venkatesh Pujari (Inactive) made transition - 30/May/17 08:35 AM

Approved for production

In Production Testing

Venkatesh Pujari (Inactive) made transition - 30/May/17 11:28 AM

In Production Testing

Production Complete

2h 52m

Rakesh Roy (Inactive) made transition - 09/Jun/17 11:06 AM

Production Complete

Closed

9d 23h 38m

People

Assignee:: Debbie Kulling

Reporter:: Prasanna Karlekar (Inactive)

Account Executive:: Debbie Kulling

Developer:: Jyoti Agrawal (Inactive)

Votes:: 0 Vote for this issue

Watchers:: 4 Start watching this issue

Dates

Created:: 21/Apr/17 09:27 AM

Updated:: 27/Jul/17 07:15 AM

Resolved:: 09/Jun/17 11:06 AM

Code Review Date:: 18/May/2017

Time Tracking

Estimated:

94h

Remaining:

Logged:

118.5h