Details

    • Type: Support Activity
    • Status: Closed
    • Priority: Medium
    • Resolution: Done
    • Labels:
      None
    • Support Task Type:
      ACA IRS Report
    • Environment:
      Production
    • Company:
      City of Denton
    • Categories:
      ACA
    • Reported by:
      Client

      Description

      NA

        Attachments

          Issue Links

            Activity

            smita.pawar Smita Pawar (Inactive) created issue -
            smita.pawar Smita Pawar (Inactive) made changes -
            Field Original Value New Value
            Link This issue clones WT-12484 [ WT-12484 ]
            smita.pawar Smita Pawar (Inactive) made changes -
            Description All companies are linked to this Jira which will get processed for IRS submission in year 2018
            smita.pawar Smita Pawar (Inactive) made changes -
            Company All Clients/Multiple Clients [ 18434 ] City of Denton [ 10433 ]
            smita.pawar Smita Pawar (Inactive) made changes -
            Account Executive Deborah Larue [ deborah.larue ]
            Hide
            jennifer.leugers Jennifer Leugers added a comment -

            2017 ACA 1095 C is ready to run. Thanks!

            Show
            jennifer.leugers Jennifer Leugers added a comment - 2017 ACA 1095 C is ready to run. Thanks!
            jennifer.leugers Jennifer Leugers made changes -
            Assignee Jennifer Leugers [ jennifer.leugers ] Smita Pawar [ smita.pawar ]
            sachin.hingole Sachin Hingole (Inactive) made changes -
            sachin.hingole Sachin Hingole (Inactive) made changes -
            Assignee Smita Pawar [ smita.pawar ] Sachin Hingole [ sachin.hingole ]
            Status Open [ 1 ] In Progress [ 3 ]
            Hide
            sachin.hingole Sachin Hingole (Inactive) added a comment -

            We have run "2017 ACA 1095 C" 1095C report, find attached check list IRS 1095-C_CityOfDenton_Checklist.xls for more details.
            Please refer latest run of "2017 ACA 1095 C" report for verification.

            Show
            sachin.hingole Sachin Hingole (Inactive) added a comment - We have run "2017 ACA 1095 C" 1095C report, find attached check list IRS 1095-C_CityOfDenton_Checklist.xls for more details. Please refer latest run of "2017 ACA 1095 C" report for verification.
            sachin.hingole Sachin Hingole (Inactive) made changes -
            Assignee Sachin Hingole [ sachin.hingole ] Jennifer Leugers [ jennifer.leugers ]
            sachin.hingole Sachin Hingole (Inactive) made changes -
            Status In Progress [ 3 ] Waiting for Customer Input [ 10500 ]
            sachin.hingole Sachin Hingole (Inactive) logged work - 26/Dec/17 12:55 PM
            • Time Spent:
              0.75h
               
              <No comment>
            sachin.hingole Sachin Hingole (Inactive) made changes -
            Remaining Estimate 16h [ 57600 ]
            Original Estimate 16h [ 57600 ]
            sachin.hingole Sachin Hingole (Inactive) made changes -
            Remaining Estimate 16h [ 57600 ] 15.25h [ 54900 ]
            Time Spent 0.75h [ 2700 ]
            Worklog Id 97869 [ 97869 ]
            Hide
            jennifer.leugers Jennifer Leugers added a comment -

            Hi all - I don't see the "regular" correction templates loaded for this group. As such, could you please load the attached? I do see some 1G listed for a couple months only so know there will be a bad file but the whole file errs out when I try to use the one on the site and when I look at the template, it is not the same that we've been using. PW is standard.

            Show
            jennifer.leugers Jennifer Leugers added a comment - Hi all - I don't see the "regular" correction templates loaded for this group. As such, could you please load the attached? I do see some 1G listed for a couple months only so know there will be a bad file but the whole file errs out when I try to use the one on the site and when I look at the template, it is not the same that we've been using. PW is standard.
            jennifer.leugers Jennifer Leugers made changes -
            Attachment Denton.zip [ 72724 ]
            ramya.tantry Ramya Tantry (Inactive) made changes -
            Assignee Jennifer Leugers [ jennifer.leugers ] Ramya Tantry [ ramya.tantry ]
            Hide
            ramya.tantry Ramya Tantry (Inactive) added a comment -

            Hi Jennifer Leugers,

            We have cloned the correct templates from other company to this company.

            We have imported the files.There is bad file for Part II.One of the employees is not present.Please find attached bad file.Password is the standard convention. Bad_ACA 1095C Correction Import File Part II02_02_2018 02_07_04 AM.xls

            For Part III,one of the digits of spouse's SSN was was different than one present in DB.
            Employee name : Felix Vargas
            Spouse name: Yuriana Elizabethan Rico
            We have corrected it and imported the files.There is no bad file for Part III.

            The report has been run after correction import.
            Please refer latest run dated : 2/2/2018 2:30:58 AM for verification.

            We have verified following employees
            1. Caleb Kile
            2. Joel Wood
            3. Felix Vargas

            Note: If 1G is given for some months,then it would apply for all 12 months.
            From IRS Site:
            Code 1G applies for the entire year or not at all. Therefore, if code 1G applies, an ALE Member must enter code 1G on line 14 in the “All 12 Months” column or in each separate monthly box (for all 12 months)

            Show
            ramya.tantry Ramya Tantry (Inactive) added a comment - Hi Jennifer Leugers , We have cloned the correct templates from other company to this company. We have imported the files.There is bad file for Part II.One of the employees is not present.Please find attached bad file.Password is the standard convention. Bad_ACA 1095C Correction Import File Part II02_02_2018 02_07_04 AM.xls For Part III,one of the digits of spouse's SSN was was different than one present in DB. Employee name : Felix Vargas Spouse name: Yuriana Elizabethan Rico We have corrected it and imported the files.There is no bad file for Part III. The report has been run after correction import. Please refer latest run dated : 2/2/2018 2:30:58 AM for verification. We have verified following employees 1. Caleb Kile 2. Joel Wood 3. Felix Vargas Note : If 1G is given for some months,then it would apply for all 12 months. From IRS Site: Code 1G applies for the entire year or not at all. Therefore, if code 1G applies, an ALE Member must enter code 1G on line 14 in the “All 12 Months” column or in each separate monthly box (for all 12 months)
            ramya.tantry Ramya Tantry (Inactive) logged work - 02/Feb/18 11:22 AM
            • Time Spent:
              3h
               

              Analysis
              Import files
              Report run
              sample PDF Verification
              Analysis report verification
              draft reply

            ramya.tantry Ramya Tantry (Inactive) made changes -
            Remaining Estimate 15.25h [ 54900 ] 12.25h [ 44100 ]
            Time Spent 0.75h [ 2700 ] 3.75h [ 13500 ]
            Worklog Id 103225 [ 103225 ]
            ramya.tantry Ramya Tantry (Inactive) made changes -
            Assignee Ramya Tantry [ ramya.tantry ] Jennifer Leugers [ jennifer.leugers ]
            Prashant.samal Prashant Samal (Inactive) made changes -
            Categories Parent values: ACA(18524)
            Component/s ACA [ 10004 ]
            Description NA
            Key WT-12532 WB-155
            Project WORKTERRA [ 10000 ] Workterra BenAdmin [ 11501 ]
            Workflow WT_Support [ 59208 ] WB - Workterra BenAdmin Support workflow [ 64949 ]
            Prashant.samal Prashant Samal (Inactive) made changes -
            Categories Parent values: ACA(18524)
            Key WB-155 WT-13635
            Project Workterra BenAdmin [ 11501 ] WORKTERRA [ 10000 ]
            Workflow WB - Workterra BenAdmin Support workflow [ 64949 ] WT_Support [ 65387 ]
            Prashant.samal Prashant Samal (Inactive) made changes -
            Status Waiting for Customer Input [ 10500 ] Open [ 1 ]
            Prashant.samal Prashant Samal (Inactive) made changes -
            Categories Parent values: ACA(18524)
            Key WT-13635 WB-468
            Project WORKTERRA [ 10000 ] Workterra BenAdmin [ 11501 ]
            Workflow WT_Support [ 65387 ] WB - Workterra BenAdmin Support workflow [ 65511 ]
            Prashant.samal Prashant Samal (Inactive) made changes -
            Status Open [ 1 ] In Development [ 10007 ]
            Prashant.samal Prashant Samal (Inactive) made changes -
            Status In Development [ 10007 ] Waiting for Input [ 11502 ]
            Prashant.samal Prashant Samal (Inactive) made changes -
            Workflow WB - Workterra BenAdmin Support workflow [ 65511 ] 0803 Copy of WB - Workterra BenAdmin Support workflow [ 66021 ]
            Hide
            jennifer.leugers Jennifer Leugers added a comment -

            Hi all - client came back with additional changes that need to be made but believe there is an import issue with the new UI. I tried it in both IE and Chrome and when I go to Bulk Correction under the ACA Settings tab, there is nothing to select under the Templates. Please load the attached files (Part II and Part III) and run the forms (I added AA to the standard password convention as the new number is too short). Please also have someone on the new UI team research to see if this is an issue with the UI across all clients. Thanks!

            Show
            jennifer.leugers Jennifer Leugers added a comment - Hi all - client came back with additional changes that need to be made but believe there is an import issue with the new UI. I tried it in both IE and Chrome and when I go to Bulk Correction under the ACA Settings tab, there is nothing to select under the Templates. Please load the attached files (Part II and Part III) and run the forms (I added AA to the standard password convention as the new number is too short). Please also have someone on the new UI team research to see if this is an issue with the UI across all clients. Thanks!
            jennifer.leugers Jennifer Leugers made changes -
            Attachment Denton2.zip [ 75100 ]
            jennifer.leugers Jennifer Leugers made changes -
            Assignee Jennifer Leugers [ jennifer.leugers ] Ramya Tantry [ ramya.tantry ]
            Hide
            ramya.tantry Ramya Tantry (Inactive) added a comment -

            Hi Smita Pawar,

            Please look into this and advise.

            CC: Sachin Hingole

            Show
            ramya.tantry Ramya Tantry (Inactive) added a comment - Hi Smita Pawar , Please look into this and advise. CC: Sachin Hingole
            ramya.tantry Ramya Tantry (Inactive) made changes -
            Assignee Ramya Tantry [ ramya.tantry ] Smita Pawar [ smita.pawar ]
            ramya.tantry Ramya Tantry (Inactive) logged work - 23/Mar/18 01:22 PM
            • Time Spent:
              1h
               

              Discussion with Smita and verify import part 3 details

            ramya.tantry Ramya Tantry (Inactive) made changes -
            Remaining Estimate 12.25h [ 44100 ] 11.25h [ 40500 ]
            Time Spent 3.75h [ 13500 ] 4.75h [ 17100 ]
            Worklog Id 109540 [ 109540 ]
            Hide
            smita.pawar Smita Pawar (Inactive) added a comment -

            Hi Jennifer Leugers,

            We have imported code correction.
            Its seems that 'Freezing of Bulk import screen' is newly introduced bug.
            We added same in our 2018 learning ticket. We will work on same if it got approved.

            We have rerun reports after code correction.
            Please refer latest run '3/23/2018 7:08:21 AM' to download report.

            Sample employee verified are as follows.
            1. Conduff Michael
            2. Romine Shawn T
            3. Patricia Blalock
            4. May Toby
            5. Gary Craig

            In case of Part II import, 2 employees got in bad file due to 'Invalid Record: Member doesn't exist.' and in case of Part III import
            3 employees got bad in file due to 'Invalid Record: Member doesn't exist.'

            You can refer bad files on below mentioned path

            Home >> Company Home >> Company Settings >> View Bad file

            Bad files names are for Part II "Bad_ACA 1095C Correction Import File JL Part II03_23_2018 01_20_03 AM.csv"
            Part III "Bad_ACA 1095C Correction Import File JL Part III03_23_2018 01_24_05 AM.csv"

            We have checked issue on 2 Hspl companies, we observed same problem there.
            We are analyzing same in detail and will update you on same and provide fix if necessary in future sprint.

            Thanks,
            Smita

            Show
            smita.pawar Smita Pawar (Inactive) added a comment - Hi Jennifer Leugers , We have imported code correction. Its seems that 'Freezing of Bulk import screen' is newly introduced bug. We added same in our 2018 learning ticket. We will work on same if it got approved. We have rerun reports after code correction. Please refer latest run '3/23/2018 7:08:21 AM' to download report. Sample employee verified are as follows. 1. Conduff Michael 2. Romine Shawn T 3. Patricia Blalock 4. May Toby 5. Gary Craig In case of Part II import, 2 employees got in bad file due to 'Invalid Record: Member doesn't exist.' and in case of Part III import 3 employees got bad in file due to 'Invalid Record: Member doesn't exist.' You can refer bad files on below mentioned path Home >> Company Home >> Company Settings >> View Bad file Bad files names are for Part II "Bad_ACA 1095C Correction Import File JL Part II03_23_2018 01_20_03 AM.csv" Part III "Bad_ACA 1095C Correction Import File JL Part III03_23_2018 01_24_05 AM.csv" We have checked issue on 2 Hspl companies, we observed same problem there. We are analyzing same in detail and will update you on same and provide fix if necessary in future sprint. Thanks, Smita
            smita.pawar Smita Pawar (Inactive) made changes -
            Assignee Smita Pawar [ smita.pawar ] Jennifer Leugers [ jennifer.leugers ]
            smita.pawar Smita Pawar (Inactive) logged work - 23/Mar/18 02:51 PM
            • Time Spent:
              4h
               

              Analysis
              Discussion with Ramya, Sachin and nandkumar
              draft
              reply
              Manual correction
              Verification

            smita.pawar Smita Pawar (Inactive) made changes -
            Remaining Estimate 11.25h [ 40500 ] 7.25h [ 26100 ]
            Time Spent 4.75h [ 17100 ] 8.75h [ 31500 ]
            Worklog Id 109577 [ 109577 ]
            ramya.tantry Ramya Tantry (Inactive) made changes -
            Link This issue relates to WB-728 [ WB-728 ]
            Hide
            Prashant.samal Prashant Samal (Inactive) added a comment -

            Closing this ticket

            Show
            Prashant.samal Prashant Samal (Inactive) added a comment - Closing this ticket
            Prashant.samal Prashant Samal (Inactive) made changes -
            Resolution Done [ 10000 ]
            Status Waiting for Input [ 11502 ] Closed [ 6 ]
            Transition Time In Source Status Execution Times
            Sachin Hingole (Inactive) made transition -
            Open In Progress
            25d 1h 5m 1
            Sachin Hingole (Inactive) made transition -
            In Progress Waiting for Customer Input
            1m 48s 1
            Prashant Samal (Inactive) made transition -
            Waiting for Customer Input Open
            69d 19h 8m 1
            Prashant Samal (Inactive) made transition -
            Open In Development
            2m 27s 1
            Prashant Samal (Inactive) made transition -
            In Development Waiting for Input
            1m 59s 1
            Prashant Samal (Inactive) made transition -
            Waiting for Input Closed
            48d 22h 13m 1

              People

              Assignee:
              jennifer.leugers Jennifer Leugers
              Reporter:
              smita.pawar Smita Pawar (Inactive)
              Account Executive:
              Deborah Larue (Inactive)
              Votes:
              0 Vote for this issue
              Watchers:
              8 Start watching this issue

                Dates

                Created:
                Updated:
                Resolved:

                  Time Tracking

                  Estimated:
                  Original Estimate - 16h
                  16h
                  Remaining:
                  Time Spent - 8.75h Remaining Estimate - 7.25h
                  7.25h
                  Logged:
                  Time Spent - 8.75h Remaining Estimate - 7.25h
                  8.75h