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

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

            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