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

WT -> BCC Invoice Enhancement -> For some billing details, adjustments are not getting exported to excel.

    Details

    • Type: Bug
    • Status: Closed
    • 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

      Verified for ASML company on Local by partner login.

      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

      Actual Result:
      We have exported 4-5 reports to excel, but for few reports adjustment details are not getting exported to excel (e.g. "Health" Invoice- September-2016 report, Invoice_By_Admin - November-2016)

        Attachments

          Issue Links

            Activity

            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 -
            Assignee Prasanna Karlekar [ prasanna ] Jyoti Agrawal [ jyoti.agrawal ]
            khandu.kshirsagar Khandu Kshirsagar (Inactive) made changes -
            Item State Parent values: LB QA(10201)Level 1 values: LB Deployed(11600)
            jyoti.agrawal Jyoti Agrawal (Inactive) made changes -
            Assignee Jyoti Agrawal [ jyoti.agrawal ] Kunal Kedari [ kunal.kedari ]
            prasanna Prasanna Karlekar (Inactive) made changes -
            Status Open [ 1 ] In Development [ 10007 ]
            prasanna Prasanna Karlekar (Inactive) made changes -
            Status In Development [ 10007 ] Local Testing [ 10200 ]
            Hide
            kunal.kedari Kunal Kedari (Inactive) added a comment -

            We have verified the fix on Local environment (wt-stage) for "ASML" company, working as expected. Exported 4-5 reports for all reports billing details are get exported properly. Marking it as ready for test.

            Show
            kunal.kedari Kunal Kedari (Inactive) added a comment - We have verified the fix on Local environment (wt-stage) for "ASML" company, working as expected. Exported 4-5 reports for all reports billing details are get exported properly. Marking it as ready for test.
            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: Ready for Stage(10213)
            prasanna Prasanna Karlekar (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)
            kunal.kedari Kunal Kedari (Inactive) made changes -
            Remaining Estimate 1h [ 3600 ]
            Original Estimate 1h [ 3600 ]
            kunal.kedari Kunal Kedari (Inactive) made changes -
            Item State Parent values: Stage QA(10202)Level 1 values: Stage Deployed(11602) Parent values: Stage QA(10202)Level 1 values: In Testing(10214)
            kunal.kedari Kunal Kedari (Inactive) logged work - 23/Nov/16 01:15 PM
            • Time Spent:
              0.5h
               

              Verified different scenarios after fix is deployed on Stage.

            kunal.kedari Kunal Kedari (Inactive) made changes -
            Remaining Estimate 1h [ 3600 ] 0.5h [ 1800 ]
            Time Spent 0.5h [ 1800 ]
            Worklog Id 10319 [ 10319 ]
            kunal.kedari Kunal Kedari (Inactive) logged work - 30/Nov/16 01:16 PM
            • Time Spent:
              0.5h
               

              Verified fix on Stage.

            kunal.kedari Kunal Kedari (Inactive) made changes -
            Remaining Estimate 0.5h [ 1800 ] 0h [ 0 ]
            Time Spent 0.5h [ 1800 ] 1h [ 3600 ]
            Worklog Id 10969 [ 10969 ]
            kunal.kedari Kunal Kedari (Inactive) logged work - 05/Dec/16 12:58 PM
            • Time Spent:
              1h
               
              <No comment>
            Hide
            kunal.kedari Kunal Kedari (Inactive) added a comment -

            Verified the fix on Stage environment (Company Name - TIBCO For HSPL). Now all adjustment details are get exported to excel. Keeping this on HOLD as we will move these items on Production with main enhancement.

            Show
            kunal.kedari Kunal Kedari (Inactive) added a comment - Verified the fix on Stage environment (Company Name - TIBCO For HSPL). Now all adjustment details are get exported to excel. Keeping this on HOLD as we will move these items on Production with main enhancement.
            kunal.kedari Kunal Kedari (Inactive) made changes -
            Item State Parent values: Stage QA(10202)Level 1 values: In Testing(10214) Parent values: Stage QA(10202)Level 1 values: On Hold(10215)
            kunal.kedari Kunal Kedari (Inactive) made changes -
            Time Spent 1h [ 3600 ] 2h [ 7200 ]
            Worklog Id 11576 [ 11576 ]
            kunal.kedari Kunal Kedari (Inactive) made changes -
            Status Local Testing [ 10200 ] Stage Testing [ 10201 ]
            Hide
            alankar.chavan Alankar Chavan (Inactive) added a comment -

            Tested on Production - 19th Dec 2016

            Working Well

            All the adjustments shown in the system invoice - are getting fetched correctly in the exported invoice

            CC - Deepali Tidke Rakesh Roy Venkatesh PujariHrishikesh Deshpande

            Show
            alankar.chavan Alankar Chavan (Inactive) added a comment - Tested on Production - 19th Dec 2016 Working Well All the adjustments shown in the system invoice - are getting fetched correctly in the exported invoice CC - Deepali Tidke Rakesh Roy Venkatesh Pujari Hrishikesh Deshpande
            alankar.chavan Alankar Chavan (Inactive) made changes -
            Item State Parent values: Stage QA(10202)Level 1 values: On Hold(10215) Parent values: Production Complete(10222)Level 1 values: Closed(10223)
            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) logged work - 19/Dec/16 01:11 PM
            • Time Spent:
              0.5h
               

              Prod Testing

            alankar.chavan Alankar Chavan (Inactive) made changes -
            Time Spent 2h [ 7200 ] 2.5h [ 9000 ]
            Worklog Id 14278 [ 14278 ]
            satyap Satya made changes -
            Environment_New LB [ 18444 ]
            Transition Time In Source Status Execution Times
            Prasanna Karlekar (Inactive) made transition -
            Open In Development
            2d 19h 33m 1
            Prasanna Karlekar (Inactive) made transition -
            In Development In LB Testing
            4s 1
            Kunal Kedari (Inactive) made transition -
            In LB Testing Stage Testing
            18d 3h 45m 1
            Alankar Chavan (Inactive) made transition -
            Stage Testing In Production Testing
            12d 18h 13m 1
            Alankar Chavan (Inactive) made transition -
            In Production Testing Production Complete
            6s 1
            Alankar Chavan (Inactive) made transition -
            Production Complete Closed
            3s 1

              People

              Assignee:
              kunal.kedari Kunal Kedari (Inactive)
              Reporter:
              kunal.kedari Kunal Kedari (Inactive)
              Votes:
              0 Vote for this issue
              Watchers:
              2 Start watching this issue

                Dates

                Created:
                Updated:
                Resolved:

                  Time Tracking

                  Estimated:
                  Original Estimate - 1h Original Estimate - 1h
                  1h
                  Remaining:
                  Remaining Estimate - 0h
                  0h
                  Logged:
                  Time Spent - 2.5h
                  2.5h