WORKTERRAProject Type: software

WORKTERRA

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

WT -> BCC Invoice Enhancement -> Issues related to billing details after exporting to excel.

    Details

    • Type: Bug
    • Status: Closed
    • Priority: Medium
    • Resolution: Done
    • Affects Version/s: None
    • Fix Version/s: None
    • Component/s: BenAdmin
    • Labels:
      None
    • Environment:
      QA
    • Module:
      BenAdmin - Report
    • Reported by:
      Harbinger
    • Item State:
      Production Complete - Closed

      Description

      emphasized text# 1] Login to the application as a partner.
      2] Navigate to Invoice Management>View Invoice>Click on Download icon in front of any record.
      3] Verify the data exported to excel and data on the screen.

      Cc: Alankar Chavan
      Following issues are observed:
      1] Proper column headers are not displaying.
      2] Unnecessary tab "Recovered_sheet" is displaying.

        Attachments

          Issue Links

          relates to

          Enhancement - An improvement or enhancement to an existing feature or task. WT-3862 BCC - Client Bill Upload Functionality

          • High - Serious problem that could block progress.
          • Closed

            Activity

            Descending order - Click to sort in ascending order
            Hide
            Permalink
            alankar.chavan Alankar Chavan (Inactive) added a comment -

            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

            Show
            alankar.chavan Alankar Chavan (Inactive) added a comment - 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
            Hide
            Permalink
            aditya.vishwakarma Aditya Vishwakarma (Inactive) added a comment -

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

            Show
            aditya.vishwakarma Aditya Vishwakarma (Inactive) added a comment - Exported discrepancy report are shown in two different tab - Fixed ( now report in one tab )
            Hide
            Permalink
            aditya.vishwakarma Aditya Vishwakarma (Inactive) added a comment -

            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

            Show
            aditya.vishwakarma Aditya Vishwakarma (Inactive) added a comment - 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
            Hide
            Permalink
            rashmita.dudhe Rashmita Dudhe (Inactive) added a comment -

            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

            Show
            rashmita.dudhe Rashmita Dudhe (Inactive) added a comment - 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
            Hide
            Permalink
            aditya.vishwakarma Aditya Vishwakarma (Inactive) added a comment -

            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

            Show
            aditya.vishwakarma Aditya Vishwakarma (Inactive) added a comment - 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
            Hide
            Permalink
            rashmita.dudhe Rashmita Dudhe (Inactive) added a comment -

            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.

            Show
            rashmita.dudhe Rashmita Dudhe (Inactive) added a comment - 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.
            Hide
            Permalink
            aditya.vishwakarma Aditya Vishwakarma (Inactive) added a comment -

            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

            Show
            aditya.vishwakarma Aditya Vishwakarma (Inactive) added a comment - 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
            Hide
            Permalink
            kunal.kedari Kunal Kedari (Inactive) added a comment -

            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

            Show
            kunal.kedari Kunal Kedari (Inactive) added a comment - 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
            Hide
            Permalink
            alankar.chavan Alankar Chavan (Inactive) added a comment -

            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

            Show
            alankar.chavan Alankar Chavan (Inactive) added a comment - 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

              People

              Assignee:
              venkatesh.pujari Venkatesh Pujari (Inactive)
              Reporter:
              kunal.kedari Kunal Kedari (Inactive)
              Votes:
              0 Vote for this issue
              Watchers:
              4 Start watching this issue

                Dates

                Created:
                Updated:
                Resolved:

                  Time Tracking

                  Estimated:
                  Original Estimate - 16.75h Original Estimate - 16.75h
                  16.75h
                  Remaining:
                  Remaining Estimate - 0h
                  0h
                  Logged:
                  Time Spent - 17.25h
                  17.25h