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

        1. Wrong Order.xlsx
          4.93 MB
          Alankar Chavan
        2. In Order LB Passed.ods
          1.16 MB
          Alankar Chavan

          Issue Links

            Activity

            Hide
            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
            Hide
            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
            Hide
            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
            Hide
            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

              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