Issue analysis

3C
Concern:Input / Output Error on-while opening excel file after downloading invoice.
Cause: The code was not robust enough to handle large count of column and data.
Correction: Re coded the logic.

Difference with previous and current code: In the excel the company information , Data header and the adjustment area are now bold only there will be no background fill for this. This also apply in case viewing discrepancy Report in downloaded excel.

We are working on it. However it is not blocking the functionality to see data.

#WT-6335 is got also fixed in the same code.

Verified this on LB environment .
Exported invoice by selecting all plans and all classes employee.
File is exported Properly on
1]Generate and view Invoice
2]View finalizes Invoice.
Column Header is showing Properly.
Not getting any error

But one issue is fount to download excel mention in jira:WT-6335

Verified this on LB environment .
Exported invoice by selecting all plans and all classes employee.
File is exported Properly on
1]Generate and view Invoice
2]View finalizes Invoice.
3]View discrepancy
Column Header is showing Properly.

Working fine as expected

Verified on Lb Environment.
Discrepancy Excel exported in single tab and also it showing in proper color coding format for ADD, Update and Delete.
Working fine as expected.

Hello Aditya Vishwakarma,

We tried testing few more scenarios and those did not work properly -

Made a template for all classes and all plans.

1. added a new employee and enrolled him in a Medical Plan eff from 01/01/2017
2. fetched out invoices for Dec 2016 and Jan 2017

Expected Result : the newly added enrollment for my test employee should have been showed with a Green color
Actual Result : there was just a single entry with no color

1. the above employee was auto enrolled in STD plan (plan mentioned termination date is 12/31/216)
2. fetched out invoices for Dec 2016 and Jan 2017

Expected Result : the existing STD enrollment for my test employee should have been showed with a Red color as it was present in Dec 2016 invoice but absent in Jan 2017 invoice
Actual Result : there was just a single entry with no color

1. took an existing employee
2. enrolled in a new plan from 01/01/2017 - in which he was not enrolled ever
3. fetched out invoices for Dec 2016 and Jan 2017

Expected Result : the newly added enrollment for my employee should have been showed with a Green color as it was not present in Dec 2016 invoice but present in Jan 2017 invoice
Actual Result : there was just a single entry with no color

If these are issues - please let us know when we can expect it's fix/
Or else please let me know if we are making any mistake in understanding the discrepancy scenarios

CC - Rakesh Roy Deepali Tidke Hrishikesh Deshpande Venkatesh Pujari Prasanna Karlekar

Closing this
Please refer WT-7146 for the problems in Discrepancy Report

Other than this - all errors mentioned above are fixed till production

CC - Prasanna Karlekar Aditya Vishwakarma Rashmita Dudhe