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

Format paycheck value are not updated when import same record.

    Details

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

      Description

      Steps to reproduce:

      1]Import paycheck information.
      2]View paycheck its showing proper value against Paycheck line item.
      3]But when we import same file gain with same records -> Records are not updated. Instead of it it is adding duplicate records as many times as we import file again and again.

        Attachments

          Activity

          rashmita.dudhe Rashmita Dudhe (Inactive) created issue -
          Show
          rashmita.dudhe Rashmita Dudhe (Inactive) added a comment - Swapnil Pandhare , Jaideep Vinchurkar Hrishikesh Deshpande , Rakesh Roy
          rashmita.dudhe Rashmita Dudhe (Inactive) made changes -
          Field Original Value New Value
          Assignee Vijay Siddha [ vijays ] Satya [ ID10004 ]
          rashmita.dudhe Rashmita Dudhe (Inactive) made changes -
          Attachment Update_View_paycheck.png [ 34699 ]
          rashmita.dudhe Rashmita Dudhe (Inactive) made changes -
          Assignee Satya [ ID10004 ] Swapnil Pandhare [ swapnil.pandhare ]
          swapnil.pandhare Swapnil Pandhare (Inactive) made changes -
          Assignee Swapnil Pandhare [ swapnil.pandhare ] Sheetal Bodhale [ sheetal.bodhale ]
          Hide
          sheetal.bodhale Sheetal Bodhale (Inactive) added a comment -
          Show
          sheetal.bodhale Sheetal Bodhale (Inactive) added a comment - as discussed with Satya , assigning to import team. CC: Jaideep Vinchurkar Suraj Sokasane Rashmita Dudhe Hrishikesh Deshpande Rakesh Roy
          sheetal.bodhale Sheetal Bodhale (Inactive) made changes -
          Assignee Sheetal Bodhale [ sheetal.bodhale ] Suraj Sokasane [ suraj.sokasane ]
          suraj.sokasane Suraj Sokasane (Inactive) made changes -
          Description Steps to reproduced:

          1]Import paycheck information.
          2]View paycheck it showing proper value again Paycheck line item.
          3]But when we import same file gain with same records -> Records are not updated instead of it it is adding duplicate records at that much how much time we import file again and again.


          Steps to reproduce:

          1]Import paycheck information.
          2]View paycheck it showing proper value again Paycheck line item.
          3]But when we import same file gain with same records -> Records are not updated instead of it it is adding duplicate records at that much how much time we import file again and again.


          suraj.sokasane Suraj Sokasane (Inactive) made changes -
          Description Steps to reproduce:

          1]Import paycheck information.
          2]View paycheck it showing proper value again Paycheck line item.
          3]But when we import same file gain with same records -> Records are not updated instead of it it is adding duplicate records at that much how much time we import file again and again.


          Steps to reproduce:

          1]Import paycheck information.
          2]View paycheck its showing proper value against Paycheck line item.
          3]But when we import same file gain with same records -> Records are not updated. Instead of it it is adding duplicate records as many times as we import file again and again.


          suraj.sokasane Suraj Sokasane (Inactive) logged work - 06/Jan/17 07:38 PM
          • Time Spent:
            3h
             
            <No comment>
          suraj.sokasane Suraj Sokasane (Inactive) logged work - 09/Jan/17 06:15 PM - edited
          • Time Spent:
            3h
             

            Analysis - Why duplicate entries inserted and what could be the possible solution.

          suraj.sokasane Suraj Sokasane (Inactive) logged work - 10/Jan/17 06:55 PM
          • Time Spent:
            1.5h
             
            <No comment>
          jaideep.vinchurkar Jaideep Vinchurkar (Inactive) logged work - 11/Jan/17 01:55 PM
          • Time Spent:
            0.5h
             
            <No comment>
          jaideep.vinchurkar Jaideep Vinchurkar (Inactive) made changes -
          Remaining Estimate 16h [ 57600 ]
          Original Estimate 16h [ 57600 ]
          jaideep.vinchurkar Jaideep Vinchurkar (Inactive) made changes -
          Remaining Estimate 16h [ 57600 ] 15.5h [ 55800 ]
          Time Spent 0.5h [ 1800 ]
          Worklog Id 18503 [ 18503 ]
          ashwin.wankhede Ashwin Wankhede (Inactive) made changes -
          Item State Parent values: LB QA(10201)Level 1 values: LB Deployed(11600)
          suraj.sokasane Suraj Sokasane (Inactive) made changes -
          Assignee Suraj Sokasane [ suraj.sokasane ] Rashmita Dudhe [ rashmita.dudhe ]
          suraj.sokasane Suraj Sokasane (Inactive) logged work - 13/Jan/17 12:13 AM
          • Time Spent:
            4h
             

            Coding for validation and formatting the error message.

          suraj.sokasane Suraj Sokasane (Inactive) made changes -
          Remaining Estimate 15.5h [ 55800 ] 11.5h [ 41400 ]
          Time Spent 0.5h [ 1800 ] 4.5h [ 16200 ]
          Worklog Id 18900 [ 18900 ]
          suraj.sokasane Suraj Sokasane (Inactive) made changes -
          Remaining Estimate 11.5h [ 41400 ] 6.5h [ 23400 ]
          Time Spent 4.5h [ 16200 ] 9.5h [ 34200 ]
          Worklog Id 18903 [ 18903 ]
          Hide
          suraj.sokasane Suraj Sokasane (Inactive) added a comment -

          Hi Rashmita Dudhe,

          If we set Effective date as isUniique, the entry with same effective date for same lineitm is updated, no new entry is inserted.
          We have set validation for the same. If Employee Paycheck Effective Date is not unique in sub template, Import is not processed.

          Show
          suraj.sokasane Suraj Sokasane (Inactive) added a comment - Hi Rashmita Dudhe , If we set Effective date as isUniique, the entry with same effective date for same lineitm is updated, no new entry is inserted. We have set validation for the same. If Employee Paycheck Effective Date is not unique in sub template, Import is not processed.
          suraj.sokasane Suraj Sokasane (Inactive) made changes -
          Worklog Id 18903 [ 18903 ]
          suraj.sokasane Suraj Sokasane (Inactive) made changes -
          Worklog Id 18903 [ 18903 ]
          suraj.sokasane Suraj Sokasane (Inactive) made changes -
          Remaining Estimate 6.5h [ 23400 ] 8.5h [ 30600 ]
          Time Spent 9.5h [ 34200 ] 7.5h [ 27000 ]
          Worklog Id 18903 [ 18903 ]
          suraj.sokasane Suraj Sokasane (Inactive) made changes -
          Remaining Estimate 8.5h [ 30600 ] 7h [ 25200 ]
          Time Spent 7.5h [ 27000 ] 9h [ 32400 ]
          Worklog Id 18919 [ 18919 ]
          rashmita.dudhe Rashmita Dudhe (Inactive) logged work - 13/Jan/17 04:40 PM
          • Time Spent:
            1h
             
            <No comment>
          rashmita.dudhe Rashmita Dudhe (Inactive) made changes -
          Item State Parent values: LB QA(10201)Level 1 values: LB Deployed(11600) Parent values: LB QA(10201)Level 1 values: In Testing(10210)
          rashmita.dudhe Rashmita Dudhe (Inactive) made changes -
          Remaining Estimate 7h [ 25200 ] 6h [ 21600 ]
          Time Spent 9h [ 32400 ] 10h [ 36000 ]
          Worklog Id 19211 [ 19211 ]
          Hide
          rashmita.dudhe Rashmita Dudhe (Inactive) added a comment -

          Verified on LB environment Consider below scenarios.
          1]If Effective date is not Selected as unique Then when importing File it is showing proper validation message.
          2]If Effective date Is selected as unique and Import File the then Records imported successfully against Effective date given in file.
          3]Verified for same effective date with Updated Paycheck Information
          4]Verified for Different Effective date with Update Paycheck information.

          all above scenarios are working fine.

          Show
          rashmita.dudhe Rashmita Dudhe (Inactive) added a comment - Verified on LB environment Consider below scenarios. 1]If Effective date is not Selected as unique Then when importing File it is showing proper validation message. 2]If Effective date Is selected as unique and Import File the then Records imported successfully against Effective date given in file. 3]Verified for same effective date with Updated Paycheck Information 4]Verified for Different Effective date with Update Paycheck information. all above scenarios are working fine.
          rashmita.dudhe Rashmita Dudhe (Inactive) made changes -
          Item State Parent values: LB QA(10201)Level 1 values: In Testing(10210) Parent values: LB QA(10201)Level 1 values: Ready for Stage(10213)
          rashmita.dudhe Rashmita Dudhe (Inactive) made changes -
          Remaining Estimate 6h [ 21600 ] 5h [ 18000 ]
          Time Spent 10h [ 36000 ] 11h [ 39600 ]
          Worklog Id 19223 [ 19223 ]
          rashmita.dudhe Rashmita Dudhe (Inactive) logged work - 16/Jan/17 05:24 PM
          • Time Spent:
            1h
             
            <No comment>
          rakeshr Rakesh Roy (Inactive) made changes -
          Status Open [ 1 ] In Development [ 10007 ]
          rakeshr Rakesh Roy (Inactive) made changes -
          Status In Development [ 10007 ] Local Testing [ 10200 ]
          rakeshr Rakesh Roy (Inactive) made changes -
          Developer Suraj Sokasane [ suraj.sokasane ]
          suraj.sokasane Suraj Sokasane (Inactive) made changes -
          Code Reviewed By Jaideep Vinchurkar [ 11908 ]
          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)
          rashmita.dudhe Rashmita Dudhe (Inactive) made changes -
          Status Local Testing [ 10200 ] Stage Testing [ 10201 ]
          Hide
          rashmita.dudhe Rashmita Dudhe (Inactive) added a comment -

          Verified on Stage environment Consider below scenarios.
          1]If Effective date is not Selected as unique Then when importing File it is showing proper validation message.
          2]If Effective date Is selected as unique and Import File the then Records imported successfully against Effective date given in file.
          3]Verified for same effective date with Updated Paycheck Information
          4]Verified for Different Effective date with Update Paycheck information.
          all above scenarios are working fine.

          Show
          rashmita.dudhe Rashmita Dudhe (Inactive) added a comment - Verified on Stage environment Consider below scenarios. 1]If Effective date is not Selected as unique Then when importing File it is showing proper validation message. 2]If Effective date Is selected as unique and Import File the then Records imported successfully against Effective date given in file. 3]Verified for same effective date with Updated Paycheck Information 4]Verified for Different Effective date with Update Paycheck information. all above scenarios are working fine.
          rashmita.dudhe Rashmita Dudhe (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)
          rashmita.dudhe Rashmita Dudhe (Inactive) made changes -
          Item State Parent values: Stage QA(10202)Level 1 values: In Testing(10214) Parent values: Stage QA(10202)Level 1 values: Ready for Production(10217)
          suraj.sokasane Suraj Sokasane (Inactive) made changes -
          Remaining Estimate 5h [ 18000 ] 2h [ 7200 ]
          Time Spent 11h [ 39600 ] 14h [ 50400 ]
          Worklog Id 20516 [ 20516 ]
          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)
          rashmita.dudhe Rashmita Dudhe (Inactive) logged work - 24/Jan/17 11:46 AM
          • Time Spent:
            2h
             
            <No comment>
          rashmita.dudhe Rashmita Dudhe (Inactive) made changes -
          Item State Parent values: Production QA(10203)Level 1 values: Production Deployed(10221) Parent values: Production QA(10203)Level 1 values: In Testing(10218)
          Hide
          rashmita.dudhe Rashmita Dudhe (Inactive) added a comment -

          Verified on Production environment Consider below scenarios.
          1]If Effective date is not Selected as unique Then when importing File it is showing proper validation message.
          2]If Effective date Is selected as unique and Import File the then Records imported successfully against Effective date given in file.
          3]Verified for same effective date with Updated Paycheck Information
          4]Verified for Different Effective date with Update Paycheck information.
          all above scenarios are working fine.

          Show
          rashmita.dudhe Rashmita Dudhe (Inactive) added a comment - Verified on Production environment Consider below scenarios. 1]If Effective date is not Selected as unique Then when importing File it is showing proper validation message. 2]If Effective date Is selected as unique and Import File the then Records imported successfully against Effective date given in file. 3]Verified for same effective date with Updated Paycheck Information 4]Verified for Different Effective date with Update Paycheck information. all above scenarios are working fine.
          rashmita.dudhe Rashmita Dudhe (Inactive) made changes -
          Remaining Estimate 2h [ 7200 ] 0h [ 0 ]
          Time Spent 14h [ 50400 ] 16h [ 57600 ]
          Worklog Id 20743 [ 20743 ]
          rashmita.dudhe Rashmita Dudhe (Inactive) made changes -
          Status Stage Testing [ 10201 ] Production Testing [ 10202 ]
          rashmita.dudhe Rashmita Dudhe (Inactive) made changes -
          Item State Parent values: Production QA(10203)Level 1 values: In Testing(10218) Parent values: Production Complete(10222)Level 1 values: Closed(10223)
          rashmita.dudhe Rashmita Dudhe (Inactive) made changes -
          Resolution Fixed [ 1 ]
          Status Production Testing [ 10202 ] Production Complete [ 10028 ]
          rashmita.dudhe Rashmita Dudhe (Inactive) made changes -
          Status Production Complete [ 10028 ] Closed [ 6 ]
          suraj.sokasane Suraj Sokasane (Inactive) made changes -
          Worklog Id 18903 [ 18903 ]
          satyap Satya made changes -
          Environment_New Stage [ 18443 ]
          Transition Time In Source Status Execution Times
          Rakesh Roy (Inactive) made transition -
          Open In Development
          40d 15h 59m 1
          Rakesh Roy (Inactive) made transition -
          In Development In LB Testing
          4s 1
          Rashmita Dudhe (Inactive) made transition -
          In LB Testing Stage Testing
          8h 32m 1
          Rashmita Dudhe (Inactive) made transition -
          Stage Testing In Production Testing
          5d 23h 47m 1
          Rashmita Dudhe (Inactive) made transition -
          In Production Testing Production Complete
          19s 1
          Rashmita Dudhe (Inactive) made transition -
          Production Complete Closed
          2s 1

            People

            Assignee:
            rashmita.dudhe Rashmita Dudhe (Inactive)
            Reporter:
            rashmita.dudhe Rashmita Dudhe (Inactive)
            Developer:
            Suraj Sokasane (Inactive)
            Votes:
            0 Vote for this issue
            Watchers:
            3 Start watching this issue

              Dates

              Created:
              Updated:
              Resolved:

                Time Tracking

                Estimated:
                Original Estimate - 16h
                16h
                Remaining:
                Remaining Estimate - 0h
                0h
                Logged:
                Time Spent - 16h
                16h