WORKTERRAProject Type: software

WORKTERRA

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

WT -> BCC Invoice Enhancement -> Input / Output Error on downloading invoice in excel

    Details

    • Type: Bug
    • Status: Production Complete
    • Priority: High
    • 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

      • ASML
      • created an template and generated invoice for month of November 2016 [please find attached screens shot for detail customization]
      • tried downloading the invoice in excel

      Excel file got downloaded - when tried to open - got an error

      CC - Deepali Tidke Hrishikesh Deshpande Venkatesh Pujari Rakesh Roy

        Attachments

          Issue Links

          blocks

          Bug - A problem which impairs or prevents the functions of the product. WT-6014 WT -> BCC Invoice Enhancement -> Downloaded Invoice Excel did not show negative costs

          • High - Serious problem that could block progress.
          • Closed
          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
            Hide
            Permalink
            prasanna Prasanna Karlekar (Inactive) added a comment -

            Issue analysis

            Show
            prasanna Prasanna Karlekar (Inactive) added a comment - Issue analysis
            Hide
            Permalink
            aditya.vishwakarma Aditya Vishwakarma (Inactive) added a comment - - edited

            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.

            Show
            aditya.vishwakarma Aditya Vishwakarma (Inactive) added a comment - - edited 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.
            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.
            Not getting any error

            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. Not getting any error
            Hide
            Permalink
            rashmita.dudhe Rashmita Dudhe (Inactive) added a comment -

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

            Show
            rashmita.dudhe Rashmita Dudhe (Inactive) added a comment - But one issue is fount to download excel mention in jira: WT-6335
            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

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

            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.

            Show
            rashmita.dudhe Rashmita Dudhe (Inactive) added a comment - 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.
            Hide
            Permalink
            alankar.chavan Alankar Chavan (Inactive) added a comment -

            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

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

            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

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

              People

              Assignee:
              aditya.vishwakarma Aditya Vishwakarma (Inactive)
              Reporter:
              alankar.chavan Alankar Chavan (Inactive)
              Developer:
              Aditya Vishwakarma (Inactive)
              Votes:
              0 Vote for this issue
              Watchers:
              3 Start watching this issue

                Dates

                Created:
                Updated:
                Resolved:

                  Time Tracking

                  Estimated:
                  Original Estimate - 45.75h Original Estimate - 45.75h
                  45.75h
                  Remaining:
                  Remaining Estimate - 0h
                  0h
                  Logged:
                  Time Spent - 46.75h
                  46.75h