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

Test data for Invoice and Billing Testing company

    Details

    • Type: Support Activity
    • Status: Resolved
    • Priority: Critical
    • Resolution: Unresolved
    • Affects Version/s: None
    • Fix Version/s: None
    • Component/s: BenAdmin
    • Labels:
      None
    • Support Task Type:
      Demo Company setup
    • Environment:
      Stage
    • Reported by:
      Harbinger
    • Module:
      BenAdmin - Report

      Attachments

      1. BCC.xls
        72 kB
      2. Billing Plan Scenarios.xls
        17 kB
      3. EmpImport_Billing.txt
        0.4 kB
      4. Employee Test Data.xls
        31 kB
      5. Family Rates Scenarios.xlsx
        14 kB
      6. Invoice_Scenarios_TestData.xlsx
        100 kB
      7. Termination and Updation Query.sql
        4 kB

        Issue Links

          Activity

          venkatesh.pujari Venkatesh Pujari (Inactive) created issue -
          venkatesh.pujari Venkatesh Pujari (Inactive) made changes -
          Field Original Value New Value
          Remaining Estimate 10h [ 36000 ] 8h [ 28800 ]
          Time Spent 2h [ 7200 ]
          Worklog Id 17823 [ 17823 ]
          venkatesh.pujari Venkatesh Pujari (Inactive) made changes -
          Remaining Estimate 8h [ 28800 ] 7h [ 25200 ]
          Time Spent 2h [ 7200 ] 3h [ 10800 ]
          Worklog Id 17851 [ 17851 ]
          prasanna Prasanna Karlekar (Inactive) made changes -
          Remaining Estimate 7h [ 25200 ] 6h [ 21600 ]
          Time Spent 3h [ 10800 ] 4h [ 14400 ]
          Worklog Id 17959 [ 17959 ]
          prasanna Prasanna Karlekar (Inactive) made changes -
          Remaining Estimate 6h [ 21600 ] 5.25h [ 18900 ]
          Time Spent 4h [ 14400 ] 4.75h [ 17100 ]
          Worklog Id 17960 [ 17960 ]
          prasanna Prasanna Karlekar (Inactive) made changes -
          Remaining Estimate 5.25h [ 18900 ] 4.75h [ 17100 ]
          Time Spent 4.75h [ 17100 ] 5.25h [ 18900 ]
          Worklog Id 18343 [ 18343 ]
          prasanna Prasanna Karlekar (Inactive) made changes -
          Summary Test data for Invoice Testing company on Stage Test data for Invoice and Billing Testing company on Stage
          prasanna Prasanna Karlekar (Inactive) made changes -
          Priority Medium [ 3 ] Highest [ 1 ]
          prasanna Prasanna Karlekar (Inactive) made changes -
          Component/s Exchange [ 10003 ]
          prasanna Prasanna Karlekar (Inactive) made changes -
          Assignee Venkatesh Pujari [ venkatesh.pujari ] Prasanna Karlekar [ prasanna ]
          Status Open [ 1 ] In Progress [ 3 ]
          meghana.joshi Meghana Joshi (Inactive) made changes -
          Remaining Estimate 4.75h [ 17100 ] 2.25h [ 8100 ]
          Time Spent 5.25h [ 18900 ] 7.75h [ 27900 ]
          Worklog Id 18431 [ 18431 ]
          meghana.joshi Meghana Joshi (Inactive) made changes -
          Remaining Estimate 2.25h [ 8100 ] 0h [ 0 ]
          Time Spent 7.75h [ 27900 ] 13.75h [ 49500 ]
          Worklog Id 18713 [ 18713 ]
          meghana.joshi Meghana Joshi (Inactive) made changes -
          Attachment Employee Test Data.xls [ 37218 ]
          meghana.joshi Meghana Joshi (Inactive) made changes -
          Attachment EmpImport.txt [ 37219 ]
          venkatesh.pujari Venkatesh Pujari (Inactive) made changes -
          Time Spent 13.75h [ 49500 ] 15.25h [ 54900 ]
          Worklog Id 19025 [ 19025 ]
          meghana.joshi Meghana Joshi (Inactive) made changes -
          Time Spent 15.25h [ 54900 ] 21.25h [ 76500 ]
          Worklog Id 19050 [ 19050 ]
          meghana.joshi Meghana Joshi (Inactive) made changes -
          Attachment Employee Test Data.xls [ 37218 ]
          meghana.joshi Meghana Joshi (Inactive) made changes -
          Attachment EmpImport.txt [ 37219 ]
          meghana.joshi Meghana Joshi (Inactive) made changes -
          Attachment Employee Test Data.xls [ 37319 ]
          meghana.joshi Meghana Joshi (Inactive) made changes -
          Attachment EmpImport_Billing.txt [ 37320 ]
          jyoti.agrawal Jyoti Agrawal (Inactive) made changes -
          Time Spent 21.25h [ 76500 ] 22.75h [ 81900 ]
          Worklog Id 19723 [ 19723 ]
          prasanna Prasanna Karlekar (Inactive) made changes -
          Time Spent 22.75h [ 81900 ] 24.25h [ 87300 ]
          Worklog Id 22304 [ 22304 ]
          venkatesh.pujari Venkatesh Pujari (Inactive) made changes -
          Time Spent 24.25h [ 87300 ] 25.25h [ 90900 ]
          Worklog Id 23273 [ 23273 ]
          venkatesh.pujari Venkatesh Pujari (Inactive) made changes -
          Time Spent 25.25h [ 90900 ] 27.25h [ 98100 ]
          Worklog Id 23480 [ 23480 ]
          venkatesh.pujari Venkatesh Pujari (Inactive) made changes -
          Remaining Estimate 0h [ 0 ] 1h [ 3600 ]
          Time Spent 27.25h [ 98100 ] 26.25h [ 94500 ]
          Worklog Id 23480 [ 23480 ]
          venkatesh.pujari Venkatesh Pujari (Inactive) made changes -
          Remaining Estimate 1h [ 3600 ] 0h [ 0 ]
          Time Spent 26.25h [ 94500 ] 27.75h [ 99900 ]
          Worklog Id 23642 [ 23642 ]
          venkatesh.pujari Venkatesh Pujari (Inactive) made changes -
          Time Spent 27.75h [ 99900 ] 28.75h [ 103500 ]
          Worklog Id 23737 [ 23737 ]
          alankar.chavan Alankar Chavan (Inactive) made changes -
          Time Spent 28.75h [ 103500 ] 30.75h [ 110700 ]
          Worklog Id 23782 [ 23782 ]
          prasanna Prasanna Karlekar (Inactive) made changes -
          Assignee Prasanna Karlekar [ prasanna ] Venkatesh Pujari [ venkatesh.pujari ]
          prasanna Prasanna Karlekar (Inactive) made changes -
          Time Spent 30.75h [ 110700 ] 32.75h [ 117900 ]
          Worklog Id 23805 [ 23805 ]
          venkatesh.pujari Venkatesh Pujari (Inactive) made changes -
          Time Spent 32.75h [ 117900 ] 34.75h [ 125100 ]
          Worklog Id 24066 [ 24066 ]
          alankar.chavan Alankar Chavan (Inactive) made changes -
          Time Spent 34.75h [ 125100 ] 36.25h [ 130500 ]
          Worklog Id 24113 [ 24113 ]
          alankar.chavan Alankar Chavan (Inactive) made changes -
          Time Spent 36.25h [ 130500 ] 36.75h [ 132300 ]
          Worklog Id 24113 [ 24113 ]
          venkatesh.pujari Venkatesh Pujari (Inactive) made changes -
          Time Spent 36.75h [ 132300 ] 40.75h [ 146700 ]
          Worklog Id 24353 [ 24353 ]
          prasanna Prasanna Karlekar (Inactive) made changes -
          Time Spent 40.75h [ 146700 ] 41h [ 147600 ]
          Worklog Id 18343 [ 18343 ]
          venkatesh.pujari Venkatesh Pujari (Inactive) made changes -
          Time Spent 41h [ 147600 ] 45h [ 162000 ]
          Worklog Id 24611 [ 24611 ]
          prasanna Prasanna Karlekar (Inactive) made changes -
          Time Spent 45h [ 162000 ] 45.5h [ 163800 ]
          Worklog Id 24744 [ 24744 ]
          venkatesh.pujari Venkatesh Pujari (Inactive) made changes -
          Time Spent 45.5h [ 163800 ] 50.5h [ 181800 ]
          Worklog Id 24970 [ 24970 ]
          venkatesh.pujari Venkatesh Pujari (Inactive) made changes -
          Time Spent 50.5h [ 181800 ] 55.5h [ 199800 ]
          Worklog Id 25576 [ 25576 ]
          venkatesh.pujari Venkatesh Pujari (Inactive) made changes -
          Time Spent 55.5h [ 199800 ] 59.5h [ 214200 ]
          Worklog Id 25858 [ 25858 ]
          prasanna Prasanna Karlekar (Inactive) made changes -
          Time Spent 59.5h [ 214200 ] 60.5h [ 217800 ]
          Worklog Id 25967 [ 25967 ]
          prasanna Prasanna Karlekar (Inactive) made changes -
          Time Spent 60.5h [ 217800 ] 61h [ 219600 ]
          Worklog Id 25968 [ 25968 ]
          venkatesh.pujari Venkatesh Pujari (Inactive) made changes -
          Attachment BCC.xls [ 41213 ]
          prasanna Prasanna Karlekar (Inactive) made changes -
          Time Spent 61h [ 219600 ] 61.5h [ 221400 ]
          Worklog Id 28651 [ 28651 ]
          venkatesh.pujari Venkatesh Pujari (Inactive) made changes -
          Time Spent 61.5h [ 221400 ] 65.5h [ 235800 ]
          Worklog Id 28826 [ 28826 ]
          venkatesh.pujari Venkatesh Pujari (Inactive) made changes -
          Remaining Estimate 0h [ 0 ] 1h [ 3600 ]
          Time Spent 65.5h [ 235800 ] 64.5h [ 232200 ]
          Worklog Id 28826 [ 28826 ]
          venkatesh.pujari Venkatesh Pujari (Inactive) made changes -
          Link This issue relates to WT-8740 [ WT-8740 ]
          venkatesh.pujari Venkatesh Pujari (Inactive) made changes -
          Remaining Estimate 1h [ 3600 ] 0h [ 0 ]
          Time Spent 64.5h [ 232200 ] 70.5h [ 253800 ]
          Worklog Id 29261 [ 29261 ]
          prasanna Prasanna Karlekar (Inactive) made changes -
          Time Spent 70.5h [ 253800 ] 71h [ 255600 ]
          Worklog Id 29286 [ 29286 ]
          venkatesh.pujari Venkatesh Pujari (Inactive) made changes -
          Time Spent 71h [ 255600 ] 75h [ 270000 ]
          Worklog Id 29458 [ 29458 ]
          venkatesh.pujari Venkatesh Pujari (Inactive) made changes -
          Attachment BCC.xls [ 41213 ]
          venkatesh.pujari Venkatesh Pujari (Inactive) made changes -
          Attachment BCC.xls [ 41621 ]
          venkatesh.pujari Venkatesh Pujari (Inactive) made changes -
          Attachment Termination and Updation Query.sql [ 41622 ]
          venkatesh.pujari Venkatesh Pujari (Inactive) made changes -
          Assignee Venkatesh Pujari [ venkatesh.pujari ] Prasanna Karlekar [ prasanna ]
          prasanna Prasanna Karlekar (Inactive) made changes -
          Time Spent 75h [ 270000 ] 75.5h [ 271800 ]
          Worklog Id 31147 [ 31147 ]
          prasanna Prasanna Karlekar (Inactive) made changes -
          Assignee Prasanna Karlekar [ prasanna ] Venkatesh Pujari [ venkatesh.pujari ]
          prasanna Prasanna Karlekar (Inactive) made changes -
          Time Spent 75.5h [ 271800 ] 75.75h [ 272700 ]
          Worklog Id 32498 [ 32498 ]
          venkatesh.pujari Venkatesh Pujari (Inactive) made changes -
          Attachment BCC.xls [ 41621 ]
          venkatesh.pujari Venkatesh Pujari (Inactive) made changes -
          Attachment Termination and Updation Query.sql [ 41622 ]
          venkatesh.pujari Venkatesh Pujari (Inactive) made changes -
          Attachment BCC.xls [ 43003 ]
          venkatesh.pujari Venkatesh Pujari (Inactive) made changes -
          Attachment Termination and Updation Query.sql [ 43004 ]
          venkatesh.pujari Venkatesh Pujari (Inactive) made changes -
          Assignee Venkatesh Pujari [ venkatesh.pujari ] Prasanna Karlekar [ prasanna ]
          venkatesh.pujari Venkatesh Pujari (Inactive) made changes -
          Time Spent 75.75h [ 272700 ] 76.75h [ 276300 ]
          Worklog Id 33244 [ 33244 ]
          prasanna Prasanna Karlekar (Inactive) made changes -
          Time Spent 76.75h [ 276300 ] 78.25h [ 281700 ]
          Worklog Id 34278 [ 34278 ]
          prasanna Prasanna Karlekar (Inactive) made changes -
          Attachment Family Rates Scenarios.xlsx [ 57653 ]
          harshada.borole Harshada Borole (Inactive) made changes -
          Time Spent 78.25h [ 281700 ] 78.75h [ 283500 ]
          Worklog Id 71011 [ 71011 ]
          jyoti.agrawal Jyoti Agrawal (Inactive) made changes -
          Time Spent 78.75h [ 283500 ] 79.25h [ 285300 ]
          Worklog Id 71202 [ 71202 ]
          parmeshwar.jumbad Parmeshwar Jumbad (Inactive) made changes -
          Time Spent 79.25h [ 285300 ] 79.75h [ 287100 ]
          Worklog Id 71336 [ 71336 ]
          parmeshwar.jumbad Parmeshwar Jumbad (Inactive) made changes -
          Time Spent 79.75h [ 287100 ] 80.25h [ 288900 ]
          Worklog Id 71337 [ 71337 ]
          harshada.borole Harshada Borole (Inactive) made changes -
          Time Spent 80.25h [ 288900 ] 86.25h [ 310500 ]
          Worklog Id 71619 [ 71619 ]
          harshada.borole Harshada Borole (Inactive) made changes -
          Remaining Estimate 0h [ 0 ] 6h [ 21600 ]
          Time Spent 86.25h [ 310500 ] 80.25h [ 288900 ]
          Worklog Id 71619 [ 71619 ]
          Worklog Time Spent 6h [ 21600 ]
          harshada.borole Harshada Borole (Inactive) made changes -
          Remaining Estimate 6h [ 21600 ] 0h [ 0 ]
          Time Spent 80.25h [ 288900 ] 87.25h [ 314100 ]
          Worklog Id 71620 [ 71620 ]
          harshada.borole Harshada Borole (Inactive) made changes -
          Remaining Estimate 0h [ 0 ] 1h [ 3600 ]
          Time Spent 87.25h [ 314100 ] 86.25h [ 310500 ]
          Worklog Id 71620 [ 71620 ]
          harshada.borole Harshada Borole (Inactive) made changes -
          Attachment Billing Plan Scenarios.xls [ 58710 ]
          prasanna Prasanna Karlekar (Inactive) made changes -
          Remaining Estimate 1h [ 3600 ] 0h [ 0 ]
          Time Spent 86.25h [ 310500 ] 87.25h [ 314100 ]
          Worklog Id 72583 [ 72583 ]
          prasanna Prasanna Karlekar (Inactive) made changes -
          Time Spent 87.25h [ 314100 ] 87.5h [ 315000 ]
          Worklog Id 72815 [ 72815 ]
          prasanna Prasanna Karlekar (Inactive) made changes -
          Time Spent 87.5h [ 315000 ] 88h [ 316800 ]
          Worklog Id 88269 [ 88269 ]
          satyap Satya made changes -
          Environment_New Stage [ 18443 ]
          prasanna Prasanna Karlekar (Inactive) made changes -
          Summary Test data for Invoice and Billing Testing company on Stage Test data for Invoice and Billing Testing company
          venkatesh.pujari Venkatesh Pujari (Inactive) made changes -
          Link This issue relates to WT-12838 [ WT-12838 ]
          venkatesh.pujari Venkatesh Pujari (Inactive) made changes -
          Time Spent 88h [ 316800 ] 89h [ 320400 ]
          Worklog Id 97169 [ 97169 ]
          prasanna Prasanna Karlekar (Inactive) made changes -
          Resolution Unresolved [ 10200 ]
          Status In Progress [ 3 ] Resolved [ 5 ]
          prasanna Prasanna Karlekar (Inactive) made changes -
          Status Resolved [ 5 ] Closed [ 6 ]
          prasanna Prasanna Karlekar (Inactive) made changes -
          Resolution Unresolved [ 10200 ]
          Status Closed [ 6 ] Reopen [ 4 ]
          prasanna Prasanna Karlekar (Inactive) made changes -
          Attachment Invoice_Scenarios_TestData.xlsx [ 72781 ]
          prasanna Prasanna Karlekar (Inactive) made changes -
          Assignee Prasanna Karlekar [ prasanna ] Amruta Lohiya [ amruta.baheti ]
          abhay.patil Abhay Patil (Inactive) made changes -
          Resolution Unresolved [ 10200 ]
          Status Reopen [ 4 ] Resolved [ 5 ]

            People

            Assignee:
            amruta.lohiya Amruta Lohiya
            Reporter:
            venkatesh.pujari Venkatesh Pujari (Inactive)
            Votes:
            0 Vote for this issue
            Watchers:
            5 Start watching this issue

              Dates

              Created:
              Updated:
              Resolved:

                Time Tracking

                Estimated:
                Original Estimate - 10h Original Estimate - 10h
                10h
                Remaining:
                Remaining Estimate - 0h
                0h
                Logged:
                Time Spent - 89h
                89h