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

ACA 2017 eSubmission - ASML

    Details

    • Type: Support Activity
    • Status: Closed
    • Priority: Medium
    • Resolution: Done
    • Affects Version/s: None
    • Fix Version/s: None
    • Component/s: ACA
    • Labels:
      None
    • Support Task Type:
      ACA IRS Submission
    • Reported by:
      Support
    • Company:
      ASML
    • Module:
      ACA - 2017

      Attachments

      1. Discrepancy in finalized 1095 C Report.xls
        10 kB
      2. screenshot-1.png
        screenshot-1.png
        16 kB
      3. screenshot-2.png
        screenshot-2.png
        25 kB
      4. screenshot-3.png
        screenshot-3.png
        6 kB

        Activity

        kumar.chhajed Kumar Chhajed (Inactive) created issue -
        nandkumar Nandkumar Prabhakar Karlekar (Inactive) made changes -
        Field Original Value New Value
        Assignee Jennifer Leugers [ jennifer.leugers ] Revansiddha Gaur [ revansiddha.gaur ]
        Developer Revansiddha G [ 10331 ]
        QA Mahendra Mungase [ mahendra.mungase ]
        nandkumar Nandkumar Prabhakar Karlekar (Inactive) made changes -
        Assignee Revansiddha Gaur [ revansiddha.gaur ] Jennifer Leugers [ jennifer.leugers ]
        jennifer.leugers Jennifer Leugers made changes -
        Attachment screenshot-1.png [ 39626 ]
        jennifer.leugers Jennifer Leugers made changes -
        Attachment screenshot-2.png [ 39627 ]
        Hide
        jennifer.leugers Jennifer Leugers added a comment -

        Received approval for ASML today so attempted to run the IRS XML but it shows the files are invalid. When I click on the Error Report, it says there are no errors found. Also – when I tried to run the file, it took quite a long time and then looked like it hadn’t started. So I went back in and it shows two reports.


        Show
        jennifer.leugers Jennifer Leugers added a comment - Received approval for ASML today so attempted to run the IRS XML but it shows the files are invalid. When I click on the Error Report, it says there are no errors found. Also – when I tried to run the file, it took quite a long time and then looked like it hadn’t started. So I went back in and it shows two reports.
        jennifer.leugers Jennifer Leugers made changes -
        Assignee Jennifer Leugers [ jennifer.leugers ] Nandkumar [ satyap ]
        jennifer.leugers Jennifer Leugers made changes -
        Attachment screenshot-3.png [ 39628 ]
        Hide
        jennifer.leugers Jennifer Leugers added a comment -

        Also - is there a way to allow for #s in the naming convention? I would like to keep the tax years separate.

        Show
        jennifer.leugers Jennifer Leugers added a comment - Also - is there a way to allow for #s in the naming convention? I would like to keep the tax years separate.
        revansiddha.gaur Revansiddha Gaur (Inactive) made changes -
        Assignee Nandkumar [ satyap ] Revansiddha Gaur [ revansiddha.gaur ]
        revansiddha.gaur Revansiddha Gaur (Inactive) made changes -
        Status Open [ 1 ] In Progress [ 3 ]
        revansiddha.gaur Revansiddha Gaur (Inactive) made changes -
        Hide
        revansiddha.gaur Revansiddha Gaur (Inactive) added a comment -

        Hi Jennifer Leugers,

        Concern :
        Generated Xml Files Invalid & Not able to view discrepancy details.
        Cause :
        Discrepancy Report patch is in Q.A. testing & will be available on Production on or before 17th Feb 2017.
        Correction :
        Until the feature available on production , we generated the discrepancy report manually &
        tried to generate the xml files on HSPL by correcting discrepancy & its generated valid xml files.

        Please do the correction as per listed the discrepancy in the attachment & finalize the 1095 c report again
        & after generation of xml file will be found as valid.

        Attachment :
        Discrepancy in finalized 1095 C Report.xls
        Password will be mailed.
        ------------------------------------------------------------------------------------------------------------------------------------------------------
        Concern :
        Also - is there a way to allow for #s in the naming convention? I would like to keep the tax years separate.

        Cause :
        Due to set validation constraint that should not be accepted numeric values as names.

        Correction :
        You can use in word as naming convention to keep tax years separated like One Six or any other as per your convenience other than number.
        This change will be implemented for next year submission.

        Regards,
        Revan

        Mahendra Mungase Smita Pawar Sachin Hingole Kumar Chhajed Nandkumar Prabhakar Karlekar

        Show
        revansiddha.gaur Revansiddha Gaur (Inactive) added a comment - Hi Jennifer Leugers , Concern : Generated Xml Files Invalid & Not able to view discrepancy details. Cause : Discrepancy Report patch is in Q.A. testing & will be available on Production on or before 17th Feb 2017. Correction : Until the feature available on production , we generated the discrepancy report manually & tried to generate the xml files on HSPL by correcting discrepancy & its generated valid xml files. Please do the correction as per listed the discrepancy in the attachment & finalize the 1095 c report again & after generation of xml file will be found as valid. Attachment : Discrepancy in finalized 1095 C Report.xls Password will be mailed. ------------------------------------------------------------------------------------------------------------------------------------------------------ Concern : Also - is there a way to allow for #s in the naming convention? I would like to keep the tax years separate. Cause : Due to set validation constraint that should not be accepted numeric values as names. Correction : You can use in word as naming convention to keep tax years separated like One Six or any other as per your convenience other than number. This change will be implemented for next year submission. Regards, Revan Mahendra Mungase Smita Pawar Sachin Hingole Kumar Chhajed Nandkumar Prabhakar Karlekar
        revansiddha.gaur Revansiddha Gaur (Inactive) made changes -
        Assignee Revansiddha Gaur [ revansiddha.gaur ] Jennifer Leugers [ jennifer.leugers ]
        kumar.chhajed Kumar Chhajed (Inactive) logged work - 14/Feb/17 01:03 PM
        • Time Spent:
          0.5h
           

          Internal discussion with Revan

        kumar.chhajed Kumar Chhajed (Inactive) made changes -
        Remaining Estimate 8h [ 28800 ]
        Original Estimate 8h [ 28800 ]
        kumar.chhajed Kumar Chhajed (Inactive) made changes -
        Remaining Estimate 8h [ 28800 ] 7.5h [ 27000 ]
        Time Spent 0.5h [ 1800 ]
        Worklog Id 24979 [ 24979 ]
        revansiddha.gaur Revansiddha Gaur (Inactive) made changes -
        Status In Progress [ 3 ] Waiting for Customer Input [ 10500 ]
        Hide
        jennifer.leugers Jennifer Leugers added a comment -

        All - if this is truly their legal names, how do we shorten them to adhere to the IRS limit of 20 characters? If we shorten it, odds are they will err out with the IRS for a mismatch.

        Show
        jennifer.leugers Jennifer Leugers added a comment - All - if this is truly their legal names, how do we shorten them to adhere to the IRS limit of 20 characters? If we shorten it, odds are they will err out with the IRS for a mismatch.
        jennifer.leugers Jennifer Leugers made changes -
        Assignee Jennifer Leugers [ jennifer.leugers ] Revansiddha Gaur [ revansiddha.gaur ]
        revansiddha.gaur Revansiddha Gaur (Inactive) logged work - 14/Feb/17 10:00 PM
        • Time Spent:
          3h
           

          Analysis by creating hspl and reply.

        revansiddha.gaur Revansiddha Gaur (Inactive) made changes -
        Status Waiting for Customer Input [ 10500 ] In Progress [ 3 ]
        Hide
        revansiddha.gaur Revansiddha Gaur (Inactive) added a comment -

        Hi,

        Concern :
        how do we shorten them to adhere to the IRS limit of 20 characters? If we shorten it, odds are they will err out with the IRS for a mismatch.

        Cause :
        Yes you are right but as per irs schema rules its invalidate.

        Correction :
        Still you can submit the files & irs will acknowledge it by tin validation error.

        Regards,
        Revan
        Mahendra Mungase Smita Pawar Sachin Hingole Nandkumar Prabhakar Karlekar

        Show
        revansiddha.gaur Revansiddha Gaur (Inactive) added a comment - Hi, Concern : how do we shorten them to adhere to the IRS limit of 20 characters? If we shorten it, odds are they will err out with the IRS for a mismatch. Cause : Yes you are right but as per irs schema rules its invalidate. Correction : Still you can submit the files & irs will acknowledge it by tin validation error. Regards, Revan Mahendra Mungase Smita Pawar Sachin Hingole Nandkumar Prabhakar Karlekar
        revansiddha.gaur Revansiddha Gaur (Inactive) made changes -
        Assignee Revansiddha Gaur [ revansiddha.gaur ] Jennifer Leugers [ jennifer.leugers ]
        revansiddha.gaur Revansiddha Gaur (Inactive) made changes -
        Status In Progress [ 3 ] Waiting for Customer Input [ 10500 ]
        revansiddha.gaur Revansiddha Gaur (Inactive) made changes -
        Remaining Estimate 7.5h [ 27000 ] 4.5h [ 16200 ]
        Time Spent 0.5h [ 1800 ] 3.5h [ 12600 ]
        Worklog Id 25131 [ 25131 ]
        revansiddha.gaur Revansiddha Gaur (Inactive) logged work - 15/Feb/17 10:00 PM
        • Time Spent:
          0.5h
           

          Discussion & reply.

        revansiddha.gaur Revansiddha Gaur (Inactive) made changes -
        Remaining Estimate 4.5h [ 16200 ] 4h [ 14400 ]
        Time Spent 3.5h [ 12600 ] 4h [ 14400 ]
        Worklog Id 25346 [ 25346 ]
        Hide
        jennifer.leugers Jennifer Leugers added a comment - - edited

        Hi all - the IRS rejected the file; so we need to reduce the names to the appropriate # of characters and then let the file err out so that it can be accepted with errors rather than rejected? Are we able to do that from the back-end rather than having to change it in WORKTERRA as you can imagine the issues that would come with changing the name in the system.

        lisa davison FYI

        Show
        jennifer.leugers Jennifer Leugers added a comment - - edited Hi all - the IRS rejected the file; so we need to reduce the names to the appropriate # of characters and then let the file err out so that it can be accepted with errors rather than rejected? Are we able to do that from the back-end rather than having to change it in WORKTERRA as you can imagine the issues that would come with changing the name in the system. lisa davison FYI
        jennifer.leugers Jennifer Leugers made changes -
        Assignee Jennifer Leugers [ jennifer.leugers ] Revansiddha Gaur [ revansiddha.gaur ]
        Hide
        revansiddha.gaur Revansiddha Gaur (Inactive) added a comment -

        Please look into this.

        Show
        revansiddha.gaur Revansiddha Gaur (Inactive) added a comment - Please look into this.
        revansiddha.gaur Revansiddha Gaur (Inactive) made changes -
        Assignee Revansiddha Gaur [ revansiddha.gaur ] Kumar Chhajed [ kumar.chhajed ]
        Hide
        kumar.chhajed Kumar Chhajed (Inactive) added a comment - - edited

        Hi Jennifer Leugers,

        We have updated the Last name of employee Gesner Vasconcelos de Carvalho as
        Last Name earlier - Vasconcelos de Carvalho
        Last Name for current run - Vasconcelos de Carvalh
        to reduce the # of characters to 20 from back-end only for that particular run.
        We have processed verify submission data and now valid file is generated. Please download the latest file and upload it to IRS and let us know the transmission status after submitting this file.

        CC Nandkumar Prabhakar Karlekar Revansiddha Gaur Smita Pawar

        Show
        kumar.chhajed Kumar Chhajed (Inactive) added a comment - - edited Hi Jennifer Leugers , We have updated the Last name of employee Gesner Vasconcelos de Carvalho as Last Name earlier - Vasconcelos de Carvalho Last Name for current run - Vasconcelos de Carvalh to reduce the # of characters to 20 from back-end only for that particular run . We have processed verify submission data and now valid file is generated. Please download the latest file and upload it to IRS and let us know the transmission status after submitting this file. CC Nandkumar Prabhakar Karlekar Revansiddha Gaur Smita Pawar
        kumar.chhajed Kumar Chhajed (Inactive) made changes -
        Assignee Kumar Chhajed [ kumar.chhajed ] Jennifer Leugers [ jennifer.leugers ]
        kumar.chhajed Kumar Chhajed (Inactive) logged work - 10/Mar/17 12:50 PM
        • Time Spent:
          3h
           

          Analysis
          Data Correction
          Run IRS Submission
          Verify file valid
          Internal discussion with Revan and Nandu
          Draft Reply

        kumar.chhajed Kumar Chhajed (Inactive) made changes -
        Remaining Estimate 4h [ 14400 ] 1h [ 3600 ]
        Time Spent 4h [ 14400 ] 7h [ 25200 ]
        Worklog Id 30279 [ 30279 ]
        revansiddha.gaur Revansiddha Gaur (Inactive) made changes -
        Remaining Estimate 1h [ 3600 ] 0.5h [ 1800 ]
        Time Spent 7h [ 25200 ] 7.5h [ 27000 ]
        Worklog Id 30309 [ 30309 ]
        Hide
        jennifer.leugers Jennifer Leugers added a comment -

        So is this what we need to do before submitting for all names that are longer than the allowed characters?

        Show
        jennifer.leugers Jennifer Leugers added a comment - So is this what we need to do before submitting for all names that are longer than the allowed characters?
        revansiddha.gaur Revansiddha Gaur (Inactive) logged work - 10/Mar/17 10:00 PM
        • Time Spent:
          0.5h
           

          Internal discussion

        Hide
        kumar.chhajed Kumar Chhajed (Inactive) added a comment -

        Hi Jennifer Leugers,

        Yes, we need remove all the discrepancies from the finalized run so that valid files are generated.

        CC Nandkumar Prabhakar Karlekar Revansiddha Gaur Smita Pawar

        Show
        kumar.chhajed Kumar Chhajed (Inactive) added a comment - Hi Jennifer Leugers , Yes, we need remove all the discrepancies from the finalized run so that valid files are generated. CC Nandkumar Prabhakar Karlekar Revansiddha Gaur Smita Pawar
        Hide
        jennifer.leugers Jennifer Leugers added a comment -

        Hi all - tried to run the refile for ASML and the XML is giving me an error file but it is blank. Please look into this and advise. Thanks.
        lisa davison FYI

        Show
        jennifer.leugers Jennifer Leugers added a comment - Hi all - tried to run the refile for ASML and the XML is giving me an error file but it is blank. Please look into this and advise. Thanks. lisa davison FYI
        jennifer.leugers Jennifer Leugers made changes -
        Assignee Jennifer Leugers [ jennifer.leugers ] Kumar Chhajed [ kumar.chhajed ]
        kumar.chhajed Kumar Chhajed (Inactive) made changes -
        Status Waiting for Customer Input [ 10500 ] In Progress [ 3 ]
        Hide
        kumar.chhajed Kumar Chhajed (Inactive) added a comment -

        Hi Jennifer Leugers,

        An employee having SSN XXXXX8477 was being added earlier into employee table and its correction record was also present into the ACA table. After that the employee was being deleted from the system but its correction records were still into table. Due to this that employee was showing up into the run which caused the file to be invalid.

        We have deleted the correction records against that employee and re-run 1095C & 1094C reports. The total employee count is now 109. Also valid correction XML files are generated on IRS Submission. Please refer latest run on IRS Submission.

        Let us know if you need any additional information

        CC - Nandkumar Prabhakar Karlekar Revansiddha Gaur Smita Pawar

        Show
        kumar.chhajed Kumar Chhajed (Inactive) added a comment - Hi Jennifer Leugers , An employee having SSN XXXXX8477 was being added earlier into employee table and its correction record was also present into the ACA table. After that the employee was being deleted from the system but its correction records were still into table. Due to this that employee was showing up into the run which caused the file to be invalid. We have deleted the correction records against that employee and re-run 1095C & 1094C reports. The total employee count is now 109. Also valid correction XML files are generated on IRS Submission. Please refer latest run on IRS Submission. Let us know if you need any additional information CC - Nandkumar Prabhakar Karlekar Revansiddha Gaur Smita Pawar
        kumar.chhajed Kumar Chhajed (Inactive) made changes -
        Assignee Kumar Chhajed [ kumar.chhajed ] Jennifer Leugers [ jennifer.leugers ]
        kumar.chhajed Kumar Chhajed (Inactive) made changes -
        Status In Progress [ 3 ] Waiting for Customer Input [ 10500 ]
        kumar.chhajed Kumar Chhajed (Inactive) logged work - 17/Mar/17 12:47 PM
        • Time Spent:
          4h
           

          Analysis
          Data correction
          Internal discussion with Revan and Nandu
          Draft reply

        kumar.chhajed Kumar Chhajed (Inactive) made changes -
        Remaining Estimate 0.5h [ 1800 ] 0h [ 0 ]
        Time Spent 7.5h [ 27000 ] 11.5h [ 41400 ]
        Worklog Id 32094 [ 32094 ]
        nandkumar Nandkumar Prabhakar Karlekar (Inactive) made changes -
        Item State Parent values: Production Complete(10222)Level 1 values: Closed(10223)
        nandkumar Nandkumar Prabhakar Karlekar (Inactive) made changes -
        Status Waiting for Customer Input [ 10500 ] In Progress [ 3 ]
        Hide
        nandkumar Nandkumar Prabhakar Karlekar (Inactive) added a comment -

        Hello,
        Feel free to reopen in case any further action required on this. Thank you.

        Show
        nandkumar Nandkumar Prabhakar Karlekar (Inactive) added a comment - Hello, Feel free to reopen in case any further action required on this. Thank you.
        nandkumar Nandkumar Prabhakar Karlekar (Inactive) made changes -
        Resolution Done [ 10000 ]
        Status In Progress [ 3 ] Closed [ 6 ]
        Transition Time In Source Status Execution Times
        Revansiddha Gaur (Inactive) made transition -
        Open In Progress
        11d 22h 7m 1
        Kumar Chhajed (Inactive) made transition -
        In Progress Waiting for Customer Input
        6h 57m 3
        Nandkumar Prabhakar Karlekar (Inactive) made transition -
        Waiting for Customer Input In Progress
        224d 15h 34m 3
        Nandkumar Prabhakar Karlekar (Inactive) made transition -
        In Progress Closed
        3m 51s 1

          People

          Assignee:
          jennifer.leugers Jennifer Leugers
          Reporter:
          kumar.chhajed Kumar Chhajed (Inactive)
          Account Executive:
          Jennifer Leugers
          QA:
          Mahendra Mungase (Inactive)
          Votes:
          0 Vote for this issue
          Watchers:
          5 Start watching this issue

            Dates

            Created:
            Updated:
            Resolved:

              Time Tracking

              Estimated:
              Original Estimate - 8h Original Estimate - 8h
              8h
              Remaining:
              Remaining Estimate - 0h
              0h
              Logged:
              Time Spent - 11.5h
              11.5h