WORKTERRAProject Type: software

WORKTERRA

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

WT -> BCC Invoice Enhancement -> Adjustment Records are shown in wrong order month when exported in Excel

    Details

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

      Description

      TIBCO for HSPL

      • created a template for all employees - all plans
      • fetched out December 2016 invoice as the first invoice

      In the system - UI : adjustment records were shown in right month order ie, Nov 2016 to Feb 2016
      When I exported in Excel - the adjustment month order shown was wrong - random ie, Feb 2016, Oct 2016, April 2016 etc

      CC - Rakesh Roy Deepali Tidke Hrishikesh Deshpande shyam sharma

        Attachments

          Issue Links

          relates to

          Enhancement - An improvement or enhancement to an existing feature or task. WT-6331 BCC Invoice Management - Adjustments in future Invoice

          • Medium - Has the potential to affect progress.
          • Closed

            Activity

            Ascending order - Click to sort in descending order
            alankar.chavan Alankar Chavan (Inactive) created issue -
            prasanna Prasanna Karlekar (Inactive) made changes -
            Field Original Value New Value
            Assignee Prasanna Karlekar [ prasanna ] Surender Kumar [ surender.kumar ]
            alankar.chavan Alankar Chavan (Inactive) made changes -
            Link This issue relates to WT-6331 [ WT-6331 ]
            khandu.kshirsagar Khandu Kshirsagar (Inactive) made changes -
            Item State Parent values: LB QA(10201)Level 1 values: LB Deployed(11600)
            surender.kumar surender kumar (Inactive) made changes -
            Assignee Surender Kumar [ surender.kumar ] Alankar Chavan [ alankar.chavan ]
            Hide
            Permalink
            surender.kumar surender kumar (Inactive) added a comment -

            3C:

            Concern:
            Adjustment Records are shown in wrong order month when exported in Excel.

            Cause:
            Records were processing in random sequence with respect to Date

            Correction:
            Correction in script.Records will process in descending order with respect to Date

            Show
            surender.kumar surender kumar (Inactive) added a comment - 3C: Concern: Adjustment Records are shown in wrong order month when exported in Excel. Cause: Records were processing in random sequence with respect to Date Correction: Correction in script.Records will process in descending order with respect to Date
            surender.kumar surender kumar (Inactive) made changes -
            Remaining Estimate 6h [ 21600 ] 3.5h [ 12600 ]
            Time Spent 2.5h [ 9000 ]
            Worklog Id 13439 [ 13439 ]
            surender.kumar surender kumar (Inactive) made changes -
            Worklog Id 13439 [ 13439 ]
            Hide
            Permalink
            alankar.chavan Alankar Chavan (Inactive) added a comment -

            Tested on WT Stage - TIBCO - 15th Dec 2016

            Working Well

            In System as well as in Exported Invoice in Excel - Adjustment Details are shown in proper order months.
            PFA

            CC - Deepali Tidke Venkatesh Pujari Hrishikesh Deshpande Rakesh Roy Prasanna Karlekar

            Ready for Stage

            Show
            alankar.chavan Alankar Chavan (Inactive) added a comment - Tested on WT Stage - TIBCO - 15th Dec 2016 Working Well In System as well as in Exported Invoice in Excel - Adjustment Details are shown in proper order months. PFA CC - Deepali Tidke Venkatesh Pujari Hrishikesh Deshpande Rakesh Roy Prasanna Karlekar Ready for Stage
            alankar.chavan Alankar Chavan (Inactive) made changes -
            Status Open [ 1 ] In Development [ 10007 ]
            alankar.chavan Alankar Chavan (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)
            alankar.chavan Alankar Chavan (Inactive) made changes -
            Status In Development [ 10007 ] Local Testing [ 10200 ]
            Permalink
            alankar.chavan Alankar Chavan (Inactive) logged work - 15/Dec/16 12:49 PM
            • Time Spent:
              1h
               
              <No comment>
            alankar.chavan Alankar Chavan (Inactive) made changes -
            Remaining Estimate 3.5h [ 12600 ] 2.5h [ 9000 ]
            Time Spent 2.5h [ 9000 ] 3.5h [ 12600 ]
            Worklog Id 13481 [ 13481 ]
            alankar.chavan Alankar Chavan (Inactive) made changes -
            Attachment In Order LB Passed.ods [ 35226 ]
            Permalink
            surender.kumar surender kumar (Inactive) logged work - 15/Dec/16 07:00 PM - edited
            • Time Spent:
              2.5h
               
              • Analysis
              • Coding
              • Code reviewed , check in
              • Testing
            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)
            Hide
            Permalink
            alankar.chavan Alankar Chavan (Inactive) added a comment -

            Tested on Stage - TIBCO - 16th Dec 2016

            Working Well

            In System as well as in Exported Invoice in Excel - Adjustment Details are shown in proper order months.

            CC - Deepali Tidke Rakesh Roy Hrishikesh Deshpande Venkatesh Pujari

            Ready for Production

            Show
            alankar.chavan Alankar Chavan (Inactive) added a comment - Tested on Stage - TIBCO - 16th Dec 2016 Working Well In System as well as in Exported Invoice in Excel - Adjustment Details are shown in proper order months. CC - Deepali Tidke Rakesh Roy Hrishikesh Deshpande Venkatesh Pujari Ready for Production
            alankar.chavan Alankar Chavan (Inactive) made changes -
            Item State Parent values: Stage QA(10202)Level 1 values: Stage Deployed(11602) Parent values: Stage QA(10202)Level 1 values: Ready for Production(10217)
            Permalink
            alankar.chavan Alankar Chavan (Inactive) logged work - 16/Dec/16 12:46 PM
            • Time Spent:
              0.5h
               
              <No comment>
            alankar.chavan Alankar Chavan (Inactive) made changes -
            Remaining Estimate 2.5h [ 9000 ] 2h [ 7200 ]
            Time Spent 3.5h [ 12600 ] 4h [ 14400 ]
            Worklog Id 13995 [ 13995 ]
            prasanna Prasanna Karlekar (Inactive) made changes -
            Developer Surender Kumar [ surender.kumar ]
            ashwin.wankhede Ashwin Wankhede (Inactive) made changes -
            Item State Parent values: Stage QA(10202)Level 1 values: Ready for Production(10217) Parent values: Production QA(10203)Level 1 values: Production Deployed(10221)
            Hide
            Permalink
            alankar.chavan Alankar Chavan (Inactive) added a comment -

            Tested on Production - 19th Dec 2016
            Working Well
            In System as well as in Exported Invoice in Excel - Adjustment Details are shown in proper order months.

            CC - Deepali Tidke Rakesh Roy Venkatesh Pujari Hrishikesh Deshpande

            Show
            alankar.chavan Alankar Chavan (Inactive) added a comment - Tested on Production - 19th Dec 2016 Working Well In System as well as in Exported Invoice in Excel - Adjustment Details are shown in proper order months. 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 -
            Item State Parent values: Production QA(10203)Level 1 values: Production Deployed(10221) 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 ]
            Permalink
            alankar.chavan Alankar Chavan (Inactive) logged work - 19/Dec/16 01:10 PM
            • Time Spent:
              0.5h
               

              LB Testing

            alankar.chavan Alankar Chavan (Inactive) made changes -
            Remaining Estimate 2h [ 7200 ] 1.5h [ 5400 ]
            Time Spent 4h [ 14400 ] 4.5h [ 16200 ]
            Worklog Id 14272 [ 14272 ]
            Permalink
            alankar.chavan Alankar Chavan (Inactive) logged work - 19/Dec/16 01:12 PM
            • Time Spent:
              0.5h
               

              Prod Testing

            alankar.chavan Alankar Chavan (Inactive) made changes -
            Remaining Estimate 1.5h [ 5400 ] 1h [ 3600 ]
            Time Spent 4.5h [ 16200 ] 5h [ 18000 ]
            Worklog Id 14280 [ 14280 ]
            satyap Satya made changes -
            Environment_New Production [ 18442 ]
            Transition Time In Source Status Execution Times
            Alankar Chavan (Inactive) made transition -
            Open In Development
            		7d 1m 1
            Alankar Chavan (Inactive) made transition -
            In Development In LB Testing
            		13s 1
            Alankar Chavan (Inactive) made transition -
            In LB Testing Stage Testing
            		3d 18h 41m 1
            Alankar Chavan (Inactive) made transition -
            Stage Testing In Production Testing
            		15s 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:
              alankar.chavan Alankar Chavan (Inactive)
              Reporter:
              alankar.chavan Alankar Chavan (Inactive)
              Developer:
              surender kumar (Inactive)
              Votes:
              0 Vote for this issue
              Watchers:
              2 Start watching this issue

                Dates

                Created:
                Updated:
                Resolved:

                  Time Tracking

                  Estimated:
                  Original Estimate - 6h
                  6h
                  Remaining:
                  Time Spent - 5h Remaining Estimate - 1h
                  1h
                  Logged:
                  Time Spent - 5h Remaining Estimate - 1h
                  5h