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

            Ascending order - Click to sort in descending order
            kunal.kedari Kunal Kedari (Inactive) created issue -
            kunal.kedari Kunal Kedari (Inactive) made changes -
            Field Original Value New Value
            Link This issue relates to WT-3862 [ WT-3862 ]
            prasanna Prasanna Karlekar (Inactive) made changes -
            Description 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.             		# 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.
            prasanna Prasanna Karlekar (Inactive) made changes -
            Description # 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.             		_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.
            khandu.kshirsagar Khandu Kshirsagar (Inactive) made changes -
            Item State Parent values: LB QA(10201)Level 1 values: LB Deployed(11600)
            prasanna Prasanna Karlekar (Inactive) made changes -
            Assignee Prasanna Karlekar [ prasanna ] Alankar Chavan [ alankar.chavan ]
            prasanna Prasanna Karlekar (Inactive) made changes -
            Status Open [ 1 ] In Development [ 10007 ]
            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
            alankar.chavan Alankar Chavan (Inactive) made changes -
            Assignee Alankar Chavan [ alankar.chavan ] Kunal Kedari [ kunal.kedari ]
            kunal.kedari Kunal Kedari (Inactive) made changes -
            Item State Parent values: LB QA(10201)Level 1 values: LB Deployed(11600) Parent values: LB QA(10201)Level 1 values: In Testing(10210)
            kunal.kedari Kunal Kedari (Inactive) made changes -
            Attachment Test_Invoice_SA_2016-11-30 06-18-07 (1).xlsx [ 33914 ]
            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
            kunal.kedari Kunal Kedari (Inactive) made changes -
            Status In Development [ 10007 ] Local Testing [ 10200 ]
            kunal.kedari Kunal Kedari (Inactive) made changes -
            Status Local Testing [ 10200 ] Reopen in Local [ 10018 ]
            kunal.kedari Kunal Kedari (Inactive) made changes -
            Assignee Kunal Kedari [ kunal.kedari ] Prasanna Karlekar [ prasanna ]
            kunal.kedari Kunal Kedari (Inactive) made changes -
            Item State Parent values: LB QA(10201)Level 1 values: In Testing(10210) Parent values: LB QA(10201)Level 1 values: Re-open(10212)
            aditya.vishwakarma Aditya Vishwakarma (Inactive) made changes -
            Assignee Prasanna Karlekar [ prasanna ] Aditya Vishwakarma [ aditya.vishwakarma ]
            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
            aditya.vishwakarma Aditya Vishwakarma (Inactive) made changes -
            Assignee Aditya Vishwakarma [ aditya.vishwakarma ] Kunal Kedari [ kunal.kedari ]
            aditya.vishwakarma Aditya Vishwakarma (Inactive) made changes -
            Item State Parent values: LB QA(10201)Level 1 values: Re-open(10212) Parent values: LB QA(10201)
            ashwin.wankhede Ashwin Wankhede (Inactive) made changes -
            Item State Parent values: LB QA(10201) Parent values: LB QA(10201)Level 1 values: LB Deployed(11600)
            rashmita.dudhe Rashmita Dudhe (Inactive) made changes -
            Attachment view_discripancy.png [ 34373 ]
            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.
            Permalink
            rashmita.dudhe Rashmita Dudhe (Inactive) logged work - 03/Dec/16 12:44 PM
            • Time Spent:
              2h
               
              <No comment>
            rashmita.dudhe Rashmita Dudhe (Inactive) made changes -
            Remaining Estimate 2h [ 7200 ]
            Original Estimate 2h [ 7200 ]
            rashmita.dudhe Rashmita Dudhe (Inactive) made changes -
            Remaining Estimate 2h [ 7200 ] 0h [ 0 ]
            Time Spent 2h [ 7200 ]
            Worklog Id 11384 [ 11384 ]
            rashmita.dudhe Rashmita Dudhe (Inactive) made changes -
            Item State Parent values: LB QA(10201)Level 1 values: LB Deployed(11600) Parent values: LB QA(10201)Level 1 values: Re-open(10212)
            rashmita.dudhe Rashmita Dudhe (Inactive) made changes -
            Assignee Kunal Kedari [ kunal.kedari ] Aditya Vishwakarma [ aditya.vishwakarma ]
            Permalink
            aditya.vishwakarma Aditya Vishwakarma (Inactive) logged work - 05/Dec/16 03:13 AM - edited
            • Time Spent:
              4h
               

              Finding root cause and coding for downloading excel

            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
            aditya.vishwakarma Aditya Vishwakarma (Inactive) made changes -
            Time Spent 2h [ 7200 ] 6h [ 21600 ]
            Worklog Id 11537 [ 11537 ]
            khandu.kshirsagar Khandu Kshirsagar (Inactive) made changes -
            Item State Parent values: LB QA(10201)Level 1 values: Re-open(10212) Parent values: LB QA(10201)Level 1 values: LB Deployed(11600)
            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
            rashmita.dudhe Rashmita Dudhe (Inactive) made changes -
            Item State Parent values: LB QA(10201)Level 1 values: LB Deployed(11600) Parent values: LB QA(10201)Level 1 values: Ready for Stage(10213)
            Permalink
            prasanna Prasanna Karlekar (Inactive) logged work - 05/Dec/16 03:22 PM - edited
            • Time Spent:
              1.5h
               

              Discussion for way to resolve Discrepancy issue.
              Tried changing code for font color changes.

            prasanna Prasanna Karlekar (Inactive) made changes -
            Time Spent 6h [ 21600 ] 7.3h [ 26280 ]
            Worklog Id 11642 [ 11642 ]
            prasanna Prasanna Karlekar (Inactive) made changes -
            Time Spent 7.3h [ 26280 ] 7.5h [ 27000 ]
            Worklog Id 11642 [ 11642 ]
            Permalink
            aditya.vishwakarma Aditya Vishwakarma (Inactive) logged work - 06/Dec/16 06:05 AM - edited
            • Time Spent:
              1.25h
               

              Code check in on LB for fixed point
              1] Color coding on View discrepancy export file
              2] remove of extra columns in beginning downloaded excel

            khandu.kshirsagar Khandu Kshirsagar (Inactive) made changes -
            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
            aditya.vishwakarma Aditya Vishwakarma (Inactive) logged work - 06/Dec/16 10:35 AM
            • Time Spent:
              5h
               

              1] Color coding on View discrepancy export file
              2] remove of extra columns in beginning downloaded excel

            aditya.vishwakarma Aditya Vishwakarma (Inactive) made changes -
            Time Spent 7.5h [ 27000 ] 12.5h [ 45000 ]
            Worklog Id 11711 [ 11711 ]
            aditya.vishwakarma Aditya Vishwakarma (Inactive) made changes -
            Worklog Id 11537 [ 11537 ]
            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
            aditya.vishwakarma Aditya Vishwakarma (Inactive) made changes -
            Time Spent 12.5h [ 45000 ] 13h [ 46800 ]
            Worklog Id 11714 [ 11714 ]
            aditya.vishwakarma Aditya Vishwakarma (Inactive) made changes -
            Worklog Id 11714 [ 11714 ]
            aditya.vishwakarma Aditya Vishwakarma (Inactive) made changes -
            Time Spent 13h [ 46800 ] 13.5h [ 48600 ]
            Worklog Id 11714 [ 11714 ]
            aditya.vishwakarma Aditya Vishwakarma (Inactive) made changes -
            Time Spent 13.5h [ 48600 ] 13.75h [ 49500 ]
            Worklog Id 11714 [ 11714 ]
            Permalink
            aditya.vishwakarma Aditya Vishwakarma (Inactive) logged work - 07/Dec/16 04:34 AM
            • Time Spent:
              2.5h
               

              Exported discrepancy report are shown in two different tab - Fixed
              Code check in for LB environment.

            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 )
            aditya.vishwakarma Aditya Vishwakarma (Inactive) made changes -
            Time Spent 13.75h [ 49500 ] 16.25h [ 58500 ]
            Worklog Id 11806 [ 11806 ]
            khandu.kshirsagar Khandu Kshirsagar (Inactive) made changes -
            Item State Parent values: Stage QA(10202)Level 1 values: Stage Deployed(11602) Parent values: LB QA(10201)Level 1 values: LB Deployed(11600)
            rakeshr Rakesh Roy (Inactive) made changes -
            Status Reopen in Local [ 10018 ] In Development [ 10007 ]
            rakeshr Rakesh Roy (Inactive) made changes -
            Status In Development [ 10007 ] Local Testing [ 10200 ]
            rakeshr Rakesh Roy (Inactive) made changes -
            Assignee Aditya Vishwakarma [ aditya.vishwakarma ] Kunal Kedari [ kunal.kedari ]
            Permalink
            kunal.kedari Kunal Kedari (Inactive) logged work - 12/Dec/16 02:37 PM
            • Time Spent:
              0.5h
               

              Testing of fix on Local environment.

            kunal.kedari Kunal Kedari (Inactive) made changes -
            Time Spent 16.25h [ 58500 ] 16.75h [ 60300 ]
            Worklog Id 12584 [ 12584 ]
            kunal.kedari Kunal Kedari (Inactive) made changes -
            Item State Parent values: LB QA(10201)Level 1 values: LB Deployed(11600) Parent values: LB QA(10201)Level 1 values: In Testing(10210)
            rashmita.dudhe Rashmita Dudhe (Inactive) made changes -
            Original Estimate 2h [ 7200 ] 16.75h [ 60300 ]
            alankar.chavan Alankar Chavan (Inactive) made changes -
            Assignee Kunal Kedari [ kunal.kedari ] Venkatesh Pujari [ venkatesh.pujari ]
            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
            alankar.chavan Alankar Chavan (Inactive) made changes -
            Status Local Testing [ 10200 ] Stage Testing [ 10201 ]
            alankar.chavan Alankar Chavan (Inactive) made changes -
            Status Stage Testing [ 10201 ] Production Testing [ 10202 ]
            alankar.chavan Alankar Chavan (Inactive) made changes -
            Resolution Fixed [ 1 ]
            Status Production Testing [ 10202 ] Production Complete [ 10028 ]
            alankar.chavan Alankar Chavan (Inactive) made changes -
            Status Production Complete [ 10028 ] Closed [ 6 ]
            alankar.chavan Alankar Chavan (Inactive) made changes -
            Item State Parent values: LB QA(10201)Level 1 values: In Testing(10210) Parent values: Production Complete(10222)Level 1 values: Closed(10223)
            Permalink
            alankar.chavan Alankar Chavan (Inactive) logged work - 19/Dec/16 01:11 PM
            • Time Spent:
              0.5h
               

              Prod Testing

            alankar.chavan Alankar Chavan (Inactive) made changes -
            Time Spent 16.75h [ 60300 ] 17.25h [ 62100 ]
            Worklog Id 14277 [ 14277 ]
            satyap Satya made changes -
            Environment_New LB [ 18444 ]
            Transition Time In Source Status Execution Times
            Prasanna Karlekar (Inactive) made transition -
            Open In Development
            		14d 22h 47m 1
            Kunal Kedari (Inactive) made transition -
            In LB Testing Reopen in Local
            		3s 1
            Rakesh Roy (Inactive) made transition -
            Reopen in Local In Development
            		11d 19h 34m 1
            Rakesh Roy (Inactive) made transition -
            In Development In LB Testing
            		57m 13s 2
            Alankar Chavan (Inactive) made transition -
            In LB Testing Stage Testing
            		6d 22h 9m 1
            Alankar Chavan (Inactive) made transition -
            Stage Testing In Production Testing
            		2s 1
            Alankar Chavan (Inactive) made transition -
            In Production Testing Production Complete
            		4s 1
            Alankar Chavan (Inactive) made transition -
            Production Complete Closed
            		2s 1

              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