Details

    • Type: Support Activity
    • Status: Resolved
    • Priority: Medium
    • Resolution: Done
    • Affects Version/s: None
    • Fix Version/s: None
    • Component/s: None
    • Labels:
      None
    • Support Task Type:
      Data Correction
    • Environment:
      Production
    • Reported by:
      Client
    • Company:
      Quincy
    • Module:
      BenAdmin
    • Severity:
      Simple

      Description

      Hi,

      Please refer to WT-10809.

      Per an email from the client:
      Per the below old email trail the billing adjustments for Quincy prior to 8/1/17 were suppressed. I ran the December Invoice today and there are adjustments going back to 1/1/2017, which is incorrect.

      Can you please check to see why any adjustment prior to 8/1/17 is no longer being suppressed? Can you also correct and suppress the adjustments prior to 8/1/17 that are appearing on the December invoice? Please let me know if you need me to delete the December invoice that I generated today.

      Thank you,
      Kira Hamilton
      Debbie Kulling

        Attachments

          Activity

          Kira.Hamilton Kira Hamilton (Inactive) created issue -
          samir Samir made changes -
          Field Original Value New Value
          Assignee Satya [ ID10004 ] Prasanna Karlekar [ prasanna ]
          prasanna Prasanna Karlekar (Inactive) made changes -
          Assignee Prasanna Karlekar [ prasanna ] Jyoti Agrawal [ jyoti.agrawal ]
          Hide
          jyoti.agrawal Jyoti Agrawal (Inactive) added a comment -

          Hi Kira Hamilton,

          We have made changes to suppress the adjustments prior to 8/1/17. To see the changes please regenerate December invoice.
          Adding to this, we found Novemember and October invoices impacted too with incorrect month adjustments. November invoice is showing June and July adjustments and October invoice is showing July adjustments. Please let us know if any correction related to adjustment needs to be done for November and October invoices.

          We would like to remind as mentioned in previous ticket that everytime we give patch on production ,the scripts gets overwritten. The supressing month vary company to company and it is difficult for us to remember company wise supressing month.
          Permanent solution for this was taken under JIRA WT-10391, which is development complete and ready for stage testing. Due to OE no enhancement is getting moved to stage and production so this is pending. Until and unless this is not moved to production we will be facing similar issue.

          Thank You,
          Jyoti Agrawal

          cc:Prasanna Karlekar,Gaurav Sodani,Satya,Debbie Kulling

          Show
          jyoti.agrawal Jyoti Agrawal (Inactive) added a comment - Hi Kira Hamilton , We have made changes to suppress the adjustments prior to 8/1/17. To see the changes please regenerate December invoice. Adding to this, we found Novemember and October invoices impacted too with incorrect month adjustments. November invoice is showing June and July adjustments and October invoice is showing July adjustments. Please let us know if any correction related to adjustment needs to be done for November and October invoices. We would like to remind as mentioned in previous ticket that everytime we give patch on production ,the scripts gets overwritten. The supressing month vary company to company and it is difficult for us to remember company wise supressing month. Permanent solution for this was taken under JIRA WT-10391, which is development complete and ready for stage testing. Due to OE no enhancement is getting moved to stage and production so this is pending . Until and unless this is not moved to production we will be facing similar issue. Thank You, Jyoti Agrawal cc: Prasanna Karlekar , Gaurav Sodani , Satya , Debbie Kulling
          jyoti.agrawal Jyoti Agrawal (Inactive) made changes -
          Remaining Estimate 0h [ 0 ]
          Time Spent 2h [ 7200 ]
          Worklog Id 91288 [ 91288 ]
          jyoti.agrawal Jyoti Agrawal (Inactive) made changes -
          Assignee Jyoti Agrawal [ jyoti.agrawal ] Kira Hamilton [ kira.hamilton ]
          jyoti.agrawal Jyoti Agrawal (Inactive) made changes -
          Assignee Kira Hamilton [ kira.hamilton ] Jyoti Agrawal [ jyoti.agrawal ]
          Status Open [ 1 ] In Progress [ 3 ]
          jyoti.agrawal Jyoti Agrawal (Inactive) made changes -
          Assignee Jyoti Agrawal [ jyoti.agrawal ] Kira Hamilton [ kira.hamilton ]
          gaurav.sodani Gaurav Sodani (Inactive) made changes -
          Resolution Done [ 10000 ]
          Status In Progress [ 3 ] Resolved [ 5 ]
          jyoti.agrawal Jyoti Agrawal (Inactive) made changes -
          Worklog Id 91288 [ 91288 ]
          prasanna Prasanna Karlekar (Inactive) made changes -
          Time Spent 2h [ 7200 ] 2.25h [ 8100 ]
          Worklog Id 91476 [ 91476 ]
          jyoti.agrawal Jyoti Agrawal (Inactive) logged work - 17/Nov/17 06:59 PM - edited
          • Time Spent:
            2h
             

            Correction, verification, discussion with Prasanna, JIRA update

          prasanna Prasanna Karlekar (Inactive) logged work - 17/Nov/17 10:30 PM
          • Time Spent:
            0.25h
             

            Discussion
            Review of reply to be done

          Hide
          Kira.Hamilton Kira Hamilton (Inactive) added a comment -

          Hello,

          Per the client:

          After reviewing the October and November invoices, the June and July adjustments should not have appeared on those invoices. Can you correct them on your end? Please advise.

          I am going to proceed with posting the December invoice today. These adjustment corrections will appear on the January invoice as I need to get the December bill to the client.

          Thank you,
          Kira Hamilton
          Debbie Kulling

          Show
          Kira.Hamilton Kira Hamilton (Inactive) added a comment - Hello, Per the client: After reviewing the October and November invoices, the June and July adjustments should not have appeared on those invoices. Can you correct them on your end? Please advise. I am going to proceed with posting the December invoice today. These adjustment corrections will appear on the January invoice as I need to get the December bill to the client. Thank you, Kira Hamilton Debbie Kulling
          Kira.Hamilton Kira Hamilton (Inactive) made changes -
          Resolution Done [ 10000 ]
          Status Resolved [ 5 ] Reopen [ 4 ]
          Kira.Hamilton Kira Hamilton (Inactive) made changes -
          Assignee Kira Hamilton [ kira.hamilton ] Prasanna Karlekar [ prasanna ]
          Kira.Hamilton Kira Hamilton (Inactive) made changes -
          Developer Prasanna Karlekar [ prasanna ]
          Original Estimate 0h [ 0 ]
          jyoti.agrawal Jyoti Agrawal (Inactive) made changes -
          Assignee Prasanna Karlekar [ prasanna ] Jyoti Agrawal [ jyoti.agrawal ]
          Hide
          jyoti.agrawal Jyoti Agrawal (Inactive) added a comment -

          Hi Kira Hamilton,

          The correct way to do this would be to delete Oct, Nov and Dec invoices and then regenerate them. Please note that, on regenerating, the invoices will pull data as of current date-time. Hence it is highly likely that the data in newly generated invoices looks different from old invoices.

          There are other ways of achieving this(correction that we suggested earlier), however, we strongly recommend not to use them as they involve some form of back end intrusion (inserting false records). Such intrusion is going to leave data in a bad shape making it difficult to maintain and understand in long term.

          Please let us know your views on same.

          Thank You!
          Jyoti Agrawal

          cc:Lalit Kumar,Prasanna Karlekar

          Show
          jyoti.agrawal Jyoti Agrawal (Inactive) added a comment - Hi Kira Hamilton , The correct way to do this would be to delete Oct, Nov and Dec invoices and then regenerate them. Please note that, on regenerating, the invoices will pull data as of current date-time. Hence it is highly likely that the data in newly generated invoices looks different from old invoices. There are other ways of achieving this(correction that we suggested earlier), however, we strongly recommend not to use them as they involve some form of back end intrusion (inserting false records). Such intrusion is going to leave data in a bad shape making it difficult to maintain and understand in long term. Please let us know your views on same. Thank You! Jyoti Agrawal cc: Lalit Kumar , Prasanna Karlekar
          jyoti.agrawal Jyoti Agrawal (Inactive) made changes -
          Status Reopen [ 4 ] In Progress [ 3 ]
          jyoti.agrawal Jyoti Agrawal (Inactive) made changes -
          Status In Progress [ 3 ] Waiting for Customer Input [ 10500 ]
          jyoti.agrawal Jyoti Agrawal (Inactive) made changes -
          Assignee Jyoti Agrawal [ jyoti.agrawal ] Kira Hamilton [ kira.hamilton ]
          prasanna Prasanna Karlekar (Inactive) made changes -
          Time Spent 2.25h [ 8100 ] 3.75h [ 13500 ]
          Worklog Id 91847 [ 91847 ]
          jyoti.agrawal Jyoti Agrawal (Inactive) logged work - 21/Nov/17 01:02 PM - edited
          • Time Spent:
            4h
             

            JIRA go through
            Analysis
            Discussion with Prasanna and Lalit
            JIRA update

          jyoti.agrawal Jyoti Agrawal (Inactive) made changes -
          Time Spent 3.75h [ 13500 ] 6.75h [ 24300 ]
          Worklog Id 91910 [ 91910 ]
          jyoti.agrawal Jyoti Agrawal (Inactive) made changes -
          Time Spent 6.75h [ 24300 ] 7.75h [ 27900 ]
          Worklog Id 91910 [ 91910 ]
          Hide
          Kira.Hamilton Kira Hamilton (Inactive) added a comment -

          Hi Jyoti Agrawal,

          Per the client: The client will handle the correction of these adjustments manually . Please do not delete any invoices.

          Thank you,
          Kira Hamilton
          Debbie Kulling

          Show
          Kira.Hamilton Kira Hamilton (Inactive) added a comment - Hi Jyoti Agrawal , Per the client: The client will handle the correction of these adjustments manually . Please do not delete any invoices. Thank you, Kira Hamilton Debbie Kulling
          prasanna Prasanna Karlekar (Inactive) logged work - 21/Nov/17 07:30 PM
          • Time Spent:
            1.5h
             

            JIRA go through
            Discussion
            Review and discussion on reply to be done

          Hide
          sumeet.kolge Sumeet.Kolge (Inactive) added a comment -

          Hi Kira Hamilton,

          Is there any further action needed from Dev's end or it is fine to close the ticket?

          ----------------------------------------------------
          CC: Mandar Kulkarni, Satya, Prasad Patil

          Show
          sumeet.kolge Sumeet.Kolge (Inactive) added a comment - Hi Kira Hamilton , Is there any further action needed from Dev's end or it is fine to close the ticket? ---------------------------------------------------- CC: Mandar Kulkarni , Satya , Prasad Patil
          Hide
          Kira.Hamilton Kira Hamilton (Inactive) added a comment -

          Hi Sumeet.Kolge,

          At this time no further action is needed.

          Thank you,
          Kira Hamilton
          Debbie Kulling

          Show
          Kira.Hamilton Kira Hamilton (Inactive) added a comment - Hi Sumeet.Kolge , At this time no further action is needed. Thank you, Kira Hamilton Debbie Kulling
          sumeet.kolge Sumeet.Kolge (Inactive) made changes -
          Status Waiting for Customer Input [ 10500 ] In Progress [ 3 ]
          Hide
          sumeet.kolge Sumeet.Kolge (Inactive) added a comment -

          Hi Kira Hamilton,

          Marking this ticket as resolved, feel free to reopen in case any further action is needed. Thanks!

          ----------------------------------
          CC: Mandar Kulkarni, Satya

          Show
          sumeet.kolge Sumeet.Kolge (Inactive) added a comment - Hi Kira Hamilton , Marking this ticket as resolved, feel free to reopen in case any further action is needed. Thanks! ---------------------------------- CC: Mandar Kulkarni , Satya
          sumeet.kolge Sumeet.Kolge (Inactive) made changes -
          Resolution Fixed [ 1 ]
          Status In Progress [ 3 ] Resolved [ 5 ]
          Transition Time In Source Status Execution Times
          Jyoti Agrawal (Inactive) made transition -
          Open In Progress
          10h 7m 1
          Kira Hamilton (Inactive) made transition -
          Resolved Reopen
          3d 7h 44m 1
          Jyoti Agrawal (Inactive) made transition -
          Reopen In Progress
          13h 38m 1
          Jyoti Agrawal (Inactive) made transition -
          In Progress Waiting for Customer Input
          16s 1
          Sumeet.Kolge (Inactive) made transition -
          Waiting for Customer Input In Progress
          21d 23h 17m 1
          Sumeet.Kolge (Inactive) made transition -
          In Progress Resolved
          5h 40m 2

            People

            Assignee:
            Kira.Hamilton Kira Hamilton (Inactive)
            Reporter:
            Kira.Hamilton Kira Hamilton (Inactive)
            Account Executive:
            Debbie Kulling
            Developer:
            Prasanna Karlekar (Inactive)
            Votes:
            0 Vote for this issue
            Watchers:
            3 Start watching this issue

              Dates

              Created:
              Updated:
              Resolved:

                Time Tracking

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