Hello Kunal Kedari,

Please test export to excel feature for invoices.
Try taking maximum employees and maximum plans.
If this is working well - please make it Ready for Stage

CC - Rakesh Roy Prasanna Karlekar

Hi Prasanna Karlekar,

We have verified the fix on Local environment, but it seems that issue still persists with large amount of data. Attaching excel sheet. Please observe the column header get messed up. Hence reopening.

Test_Invoice_SA_2016-11-30 06-18-07 (1).xlsx

Please see the comment of WT-6327 https://workterra.atlassian.net/browse/WT-6327?focusedCommentId=74812&page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel#comment-74812

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.

But one issue is found .

getting server when click on View discrepancy excel refer below screen shots and error log

ErrorID : 0
ErrorSource : ControllerAppTier.SaveAndGetData->BenAdminControllerAppTier.SaveAndGetData->InvoiceDetails.SaveAndGetData->InvoiceDataSet.InvoiceDiscrepancyCreateExcelFile->InvoiceDataSet.CreateFileAndExportInvoiceDiscrepancyInExcel
ErrorMessage: Offset and length were out of bounds for the array or count is greater than the number of elements from index to the end of the source collection.

I have fixed download error while downloading Discrepancy Excel.

Highlighting of differences with color fills and remove of extra columns in beginning downloaded excel are in progress.

cc: Prasanna Karlekar

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.

but there are two known issue 1]Color coding on View discrepancy export file
2]exported discrepancy report are shown in two different tab

Following Fixed for LB environment
1] Color coding on View discrepancy export file
2] remove of extra columns in beginning of downloaded excel

exported discrepancy report are shown in two different tab - In progress

Exported discrepancy report are shown in two different tab - Fixed ( now report in one tab )

This is tested on Production - 19th Dec 2016

As far as the basic functianlity is concern related to exported invoice and discrepancy report - this is working well
Records grid - UI - multiple sheets problem has got solved - hence closing this ticket

A separate issue is open related to the exported version of discrepancy report
We will track it individually

CC - Deepali Tidke Rakesh Roy Venkatesh Pujari Hrishikesh Deshpande