This page (revision-13) was last changed on 26-Nov-2021 10:22 by mmcfarland

This page was created on 26-Nov-2021 10:22 by jmyers

Only authorized users are allowed to rename pages.

Only authorized users are allowed to delete pages.

Page revision history

Version Date Modified Size Author Changes ... Change note
13 26-Nov-2021 10:22 11 KB mmcfarland to previous
12 26-Nov-2021 10:22 11 KB mmcfarland to previous | to last
11 26-Nov-2021 10:22 11 KB mmcfarland to previous | to last
10 26-Nov-2021 10:22 11 KB mmcfarland to previous | to last
9 26-Nov-2021 10:22 11 KB mmcfarland to previous | to last
8 26-Nov-2021 10:22 11 KB mmcfarland to previous | to last
7 26-Nov-2021 10:22 11 KB mmcfarland to previous | to last
6 26-Nov-2021 10:22 10 KB kparrott to previous | to last
5 26-Nov-2021 10:22 10 KB kparrott to previous | to last
4 26-Nov-2021 10:22 10 KB kparrott to previous | to last
3 26-Nov-2021 10:22 10 KB kparrott to previous | to last
2 26-Nov-2021 10:22 10 KB rforbes to previous | to last
1 26-Nov-2021 10:22 10 KB jmyers to last

Page References

Incoming links Outgoing links
W 2_PROCESS_US_YEAR_END_SUMMARY_REPORT...nobody
W2_PROCESS_US_YEAR_END_SUMMARY_REPORT

Version management

Difference between version and

At line 1 changed 19 lines
!RPYEU – US Year End Summary Report
The US Year End Summary Report (RPYEU) is used to verify that the totals are balanced with the Year to Date information before printing the W2 forms. \\
Produce the US Year End Summary Report.
*This report is used to balance to the Year-To-Date Register and the Quarter-To-Date (RPREGT) report
*Check the exception messages from this Summary Report and correct any exceptions
* Generate the W2 File in the federal format (EFW2 Format is supported for year 2018 reporting)
* Generate the State Information in the federal file format for the States that accept the federal file format
*Produce the W2 State File for States with the specific State file format requirements
*Users must run the RPYEU process, one State at a time, to generate the State specific file
*Since each State has its own requirements, users must check with High Line to verify if the State is supported, prior to running the RPYEU for a specific State file
*Generate an XML file to populate the RPW2 program to print the W2 Forms for all processed employees \\
__RPYEU Report Criteria__
||Field||Description
|Annual Form Code|Mandatory\\Form Code that is defined on [IDFDV]\\NOTE: always use the most current year Form Code because [RPYEU] is programmed with Identifiers from the most current year's information. __DO NOT __ use prior year Form Codes because prior year’s Identifiers may be obsolete. \\The current year Form Code contains the 'STORE OPTION' field to store the Employer Addresses, Employee Addresses and Amounts in the Government Remittance Tables, which can be viewed on [IPGR] or [IPGH] forms.
!RPYEU – Selection Criteria – Annual Reporting
__Report Criteria Tab__
||Report Parameters||Description
|Annual Form Code|Mandatory\\HL$US-W2-2016\\NOTE: always use the most current year form code ‘HL$US-W2-2016’\\Enter the most current year’s Form Code because [RPYEU] is programmed with identifiers from the most current year information. Prior year’s Form Code should not be used because prior year’s identifiers may be obsolete.\\For 2013-2014 reporting, Form Code from current year ‘HL$US-W2-2016’ contains the STORE OPTION field to store the Employer Addresses, Employee Addresses and Amounts in the Government Remittance Tables to be viewed on [IPGR]/[IPGH]
At line 22 changed one line
|Period Type|Enter the Year for Annual reporting
|Period Type|Enter ‘Year’ for Annual reporting
At line 24 changed 3 lines
|As of Date|The start date of the reporting period
|Combine Employment Type|Should the employees on the reort be sorted by their Employment Type? \\Set this toggle to ON to combine ‘Regular’, ‘Other Types’ of employment, such as Agriculture//
|Combine Fed Regist|Should all the selected 'Federal Regist' for State/Local reporting be combined? Set this toggle to ON to combine all selected ‘Federal Regist’ for State/Local reporting. \\__Do not set this toggle to ON when generating the Federal File__\\When this toggle is set to ON, [RPYEU] will not store the Federal Level amounts on [IPGH] because the Federal Registration Numbers are combined and will not be linked to a specific Federal Registration Number.
|As of Date|This date is used to retrieve employee information such as name, address, etc.
|Combine Employment Type|Check this toggle to combine ‘Regular’, ‘Agriculture’ employment, etc.
|Combine Fed Regist|Check this toggle to combine all selected ‘Federal Regist’ for State/Local reporting.\\Do not check this toggle when generating the Federal File\\When this toggle is checked, [RPYEU] will not store the Federal Level amounts on [IPGH] because the Federal Registration Number are combined and will not be linked to a specific Federal Registration Number.
At line 28 changed 7 lines
|Directory Name|Enter the directory name where the government magnetic media file will be stored
|Media File Name|Enter the file name for the government magnetic media file
|Create Data Dump|Should a data dump file with a .csv extension by generated? \\When this toggle is set to ON, [RPYEU] will generate data dump files with a .csv extension for Federal, State, Local and School information. Users can open the data dump file in an Excel spreadsheet for debugging and balancing purposes.
|Trace Level|Users should always run RPYEU with the Trace Level set to 'Exceptions Only', unless more information is required for tracing.
|Regist/Set Up Audit|Option to print exceptions that may exist from set up. \\Options are: \\ *00-Do not print, run \\*01-Print, Do not run \\*02-Print and run \\*03-Excp and run \\
|User Comment|Enter a comment to print on the RPYEU report
|Print Report On|Options are:\\*Report only (default)\\*Report and Output file\\*Output file only\\*Do not print
|Directory Name|Enter a valid directory name
|Media File Name|Enter a file name for govt magnetic media file
|Create Data Dump|Optional toggle\\If checked, [RPYEU] will generate data dump files with .csv extension for Federal, State, Local, School information. The data dump file can be opened with Excel spreadsheet for debugging and balancing purposes.
|Trace Level|Should always run with Exception only unless for tracing
|Regist/Set Up Audit|Can select to audit Govt Registration set up and continue processing, etc.\\[Print and Run|X_PRINT_AND_RUN] lexicon available.
|User Comment|Enter any comment to be printed on RPYEU report
At line 36 changed 16 lines
!RPYEU Report Filters
||Field||Description
|Entity|To define and report on a specific Entity. Optional
|Federal Regist Set|To define and report on a specific ‘Federal Regist Set’ from [IDGV]. Do not define this field if the run is for all employees. Optional
|Federal Regist Number|To define and report on a specific Federal Registration Number from [IDGV]. Optional
|People List|This field limits the process to the people in the defined list. Optional
|Person|Person Code of the employee you are testing with. Optional
|Select State|Do not enter a State when generating the Federal File or W2 forms.\\If a State is defined, [RPYEU] will report by the defined State only. Optional
|State Regist Set|To define and report on a specific State Registration Set on [IDGV]. Not required for Annual reporting. Optional
|State Regist Number|Used for Quarterly State Reporting. \\If a State is not defined, the Federal Registr Number [IDGV]is used. Optional
|Local Regist Set|To define and report on a specific Local Registration Set. Optional
|Local Regist Number|To define and report on a specific Local Registration Numbers\\Enter Local Regist Set and Local Regist Number only when running for one Local. Optional
|Select County|To define and report on a specific Counties. Optional
|Select City|To define and report on a specific City. Optional
|Select School|To define and report on a specific School District. Optional
\\
||Report Filters||Description
|Entity|Optional\\Enter one or more Entities
|Federal Regist Set|Optional\\Enter only if you want to select by different ‘Federal Regist Set’. Otherwise, do not select Federal Regist Set if run for all employees.
|Federal Regist Number|Optional\\Enter one or more Federal Registration Number
|People List|Optional\\Specify if a 'People List' is to be used
|Person|Optional\\Enter one or more Person Codes
|Select State|Optional\\Do not enter any state when generating the Federal File for W2.\\If a state is entered, [RPYEU] automatically switches to report by state.
|State Regist Set|Optional\\Enter one or more State Registration Sets
|State Regist Number|Optional\\Enter one or more State Registration Numbers\\Enter State Regist Set and State Regist Number only when running for one state.
|Local Regist Set|Optional\\Enter one or more Local Registration Sets
|Local Regist Number|Optional\\Enter one or more Local Registration Numbers\\Enter Local Regist Set and Local Regist Number only when running for one Local
|Select County|Optional\\Enter one or more Counties\\If a County is entered, [RPYEU] may switch to report by this County
|Select City|Optional\\Enter one or more Cities\\If a City is entered, [RPYEU] may switch to report by this City
|Select School|Optional\\Enter one or more Schools\\If School list are entered, [RPYEU] reports for these schools only
At line 53 changed one line
__RPYEU Report Run Options Tab__\\
__Report Run Options Tab__\\
At line 56 changed 9 lines
|Sort Level by|How should the employees be group for sorting?
|Sort by Active/Inactive|Should the employees on the report be sorted by their status?
|Sort People by|How should the employees be sorted?
|Provide Sort Level Totals|Optional. Should totals be printed for each 'Sort Level' selected?
|Federal Level Print|Should the amount details be printed for Federal Level?
|State Level Print|Should the amount details be printed for State Level?
|SUI Level Print|Should the amount details be printed for SUI Level?
|Local Level Print|Should the amount details be printed for Local Level? (County and City level)
|School Level Print|Should the amount details be printed for School Level?
|Sort by Level|Enter ‘Sort by Level’ if necessary
|Sort by Active/Inactive|This prompt is used to separate Active and Inactive employees for distribution purpose
|Sort People by|Enter ‘Sort People by’ if necessary
|Provide Sort Level Totals|Optional, if the toggle is ON, the total is generated for ‘Sort by Level’
|Federal Level Print|Enter‘Federal Level Print’ to show the amount detail for Federal level
|State Level Print|Enter ‘State Level Print’ to show the amount detail for State level
|SUI Level Print|Enter ‘SUI Level Print’ to show the amount detail for SUI level
|Local Level Print|Enter ‘Local Level Print’ to show the amount detail for County and City level
|School Level Print|Enter ‘School Level Print’ to show the amount detail for School level
At line 66 changed 5 lines
!RPYEU Selection Criteria – Quarterly Reporting
||Field||Description
|Annual Form Code|Mandatory\\Use the most current year Form Code (defined on [IDFDV])
|Quarterly Form Code|If not defined, it defaults to the Annual Form Code with EFW2 format.\\If the State is using a format such as the [ICESA], TIB-4 and special format for quarterly reporting, enter 'HL$US-QTR-2014.\\‘HL$US-QTR-2014’ will not be updated after 2014 because this format code is only used for prior year [ICESA] and TIB-4 formats. Most states are now converted to EFW2. Optional
|Govt Interface Format|Some states require specific government XML file format that is defined on [IDIF]. Example: Florida State format is HL$US-QTR-FL2008\\Please refer to the State document that indicates if this parameter should be used. Optional
!RPYEU – Selection Criteria – Quarterly Reporting
||Report Parameters||Description
|Annual Form Code|Mandatory\\HL$US-W2-2016, use most current year Form Code
|Quarterly Form Code|Optional\\If not specified, it defaults to the Annual Form Code with EFW2 format.\\If the State is using the format such as the [ICESA], TIB-4 and special format for quarterly reporting, enter ‘HL$US-QTR-2014.\\‘HL$US-QTR-2014’ may not be updated after 2014 because this format code is only used for prior year format [ICESA] and TIB-4, most states are converted to EFW2
|Govt Interface Format|Optional\\Some states require specific government XML file format that is defined on [IDIF], e.g. Florida State format HL$US-QTR-FL2008\\Please refer to the State document that indicates if this parameter should be used
At line 73 changed 4 lines
|As of Date|The start date of the reporting period
|Combine Employment Type|Should the employees on the reort be sorted by their Employment Type? \\Set this toggle to ON to combine ‘Regular’, ‘Other Types’ of employment, such as Agriculture//
|Combine Fed Regist|Should all the selected 'Federal Regist' for State/Local reporting be combined? Set this toggle to ON to combine all selected ‘Federal Regist’ for State/Local reporting.\\
|Media Format|Enter ‘State File Format’ or ‘SUI File Format’ for State reporting\\For the ‘SUI File Format’, the ‘SUI Registration Number' from [IDGV] is used.
|As of Date|This date is used to retrieve employee information such as Name and address etc
|Combine Employment Type|Check this toggle to combine ‘Regular’, ‘Agriculture’ employment etc
|Combine Fed Regist|Check this toggle to combine all selected ‘Federal Regist’ for State/Local reporting
|Media Format|Enter ‘State File Format’ or ‘SUI File Format’ for State reporting\\For ‘SUI File Format’, the [IDGV] ‘SUI Registration’ number is used.
At line 78 changed 7 lines
__RPYEU Report Filters__
||Field||Description
|Federal Regist Set|To define and report on a specific ‘Federal Regist Set’ from [IDGV]. Do not define this field if the run is for all employees. Optional
|Federal Regist Number|To define and report on a specific Federal Registration Number from [IDGV]. Optional
|Select State|Mandatory for Quarterly State Filing. If a State is not entered, the process is run for Federal reporting.
|State Regist Set|Enter the State Registration Set. Enter the ‘State Regist Set’ and 'State Registration Number' fields __only__ when running for one State. Optional
|State Regist Number|Enter the State Registration Number. Enter the ‘State Regist Set’ and 'State Registration Number' fields __only__ when running for one State. Optional
||Report Filters||Description
|Federal Regist Set|Optional\\Enter only if you want to select by different ‘Federal Regist Set’
|Federal Regist Number|Optional\\Enter only if you want to select by different Federal Registration Number
|Select State|Mandatory for Quarterly State Filing, if State is not entered, then it’s a Federal run
|State Regist Set|Optional\\Enter only if you want to select by different ‘State Regist Set’
|State Regist Number|Optional\\Enter one or more State Registration Numbers\\Enter State Regist Set and State Regist Number only when running for one state
At line 89 changed one line
*For quarterly filing, users must set up the current year Annual Form Code [IDFDV] for all Federal and State Identifiers, including SUI/SDI, respecting the Work and Home State pay components. Users may also need to set up the ‘HL$US-QTR-2014’ Form Codes, depending on each state.
*For quarterly filing, [IDFDV] Annual Form Code ‘HL$US-W2-2013’ must be set up for all Federal and State identifiers, including SUI/SDI, respecting the Work and Home State pay components. Form Code ‘HL$US-QTR-2014’ may also need to be set up, depending on each state.
At line 72 added 8 lines
*The difference for Federal and State Filing is the file format for each state, e.g. EFW2, ICESA, TIB4 or specific State Format
*Prior to Jan 1, 2004, if the state is using ICESA, TIB4 or specific State Format, the RPQTR program was used to report the quarterly file with Form Code ‘HL$US-QTR-2014’
*Effective Jan 1, 2004, [RPYEU] supports the filing of multiple Government Registrations at Federal/State/Local level. [RPYEU] and the RPQTR program are now merged together, therefore RPQTR is no longer used after Jan 1, 2004
*The quarterly Form Code ‘HL$US-QTR-2014’ is being used and may not be changed because it contains all necessary identifiers to support the ICESA, TIB-4 and State specific format. However, all main processing is derived from Annual Form Code ‘HL$US-W2-2016’.
*When [RPYEU] is run for quarterly reporting, the Annual Form Code MUST be entered. It is optional to enter the Quarterly Form Code to use ‘HL$US-QTR-2012’ or to default to EFW2 ‘HL$US-W2-2014’ format.
*All identifiers from ‘HL$US-QTR-2012’ fields 3100, 3110, etc. will be calculated by [RPYEU] by retrieving values from HL$US-W2-2014 sequence #'s 7010, 7020 etc. Any value may be entered on ‘HL$US-QTR-2012’ sequence 3100, 3110, etc. and it will not be used.
*HL uses ‘HL$US-QTR-2012’ identifiers to obtain values that are applicable for ICESA, TIB4 formats.
*After [IDFDV] HL$US-W2-2014 State and SUI info are set up, the employees must also be paid in [UPCALC] with the State/SUI info for that state in order to be reported for the quarterly filing.
At line 92 removed 11 lines
The current year Form Code (HL$US-W2-2018) is used to report the Federal File and W2 Form Information for the 2017 year end. This form code information is also used to report the quarterly information for the States for 2018.
*The difference between Federal and State Filing is the file format for each state, such as EFW2, ICESA, or another specific State Format.
*When [RPYEU] is run for quarterly reporting, users MUST enter Annual Form Code. Users can optionally enter the Quarterly Form Code to use ‘HL$US-QTR-2014’ or to default to EFW2 current year format.
*All ‘HL$US-QTR-2014’ Identifiers from fields 3100, 3110, etc. will be calculated by [RPYEU] by retrieving values from the current year From Code sequence #'s 7010, 7020 etc. Users can enter any values on ‘HL$US-QTR-2018’, sequence 3100, 3110, etc. and it will not be used.
High Line uses the Quarterly Identifiers to obtain values that are applicable for ICESA or other specific formats.
*After the current year Form Code, State and SUI information is set up on IDFDV, the employees must also be paid in [UPCALC] with the State/SUI information for that State, in order to be reported for the quarterly filing.
At line 104 changed 2 lines
*[RPYEU] produces a Summary Total Report by Government Registrations. Users must balance this report to the [RPREGT] report.
*Each [RPYEU] run generates one Government Run Number (GVT Run Number).
*[RPYEU] produces Summary Total Report by Government Registrations, this report must be verified with the [RPREGT] report for balancing purpose.
*Each [RPYEU] run generates one GVT Run (Government Run Number).
At line 107 changed 11 lines
*At the end of [RPYEU], the Government Reporting Statistics are printed with the generated GVT Run Number.
*After [RPYEU] is run, users can go into [IPGR] (Government Run) to view details by GVT Run number.
*On [IPGR] the employee’s detail government reporting information on [IPGH] (Government Header) can be viewed. Users can also go directly to IPGH by employee to view this information.
*Users can process many [RPYEU] runs for different sets of employees. This generates multiple GVT Run Numbers, however users must run RPW2 to print W2 forms from the .xml files that are generated by RPYEU.
*Employee’s Government Header (IPGH) information are re-generated by subsequent RPYEU runs. The same IPGH information is removed automatically when a new IPGH is re-generated.
*At the end of each run, [RPYEU] removes any GVT Run Number that do not have any GVT Header associated with it.
*Users can run [RPYEU] concurrently for different sets of employees.
*At the beginning of the [RPYEU] run, the Execution Run Log is stamped with the Execution Start Date. At the end of RPYEU, the Execution End Date is stamped.
*For a concurrent [RPYEU] run that have not been finished with the Execution End Date, the other concurrent [RPYEU] runs will not remove the GVT Run Number, even if there are no GVT Headers.
*At the end of [RPYEU], the Government Reporting Statistics are printed with the GVT Run Number generated.
*After [RPYEU] is run, [IPGR] (Government Run) can be used for online inquiry by GVT Run number.
*From [IPGR] the employee’s detail government reporting information on [IPGH](Government Header) can be accessed.
*Many [RPYEU] runs may be run for different sets of employees for testing or auditing purposes
*All employees must be run together in one [RPYEU] by Federal Registration in order to generate the Government Media file. Thus this [RPYEU] GVT Run number or xml file should be used to run RPW2 in order to print W2 for the same set of employees that have been reported on the Government Media file.
*In a subsequent [RPYEU] run, the employee’s Government Header (PGH) information are re-generated, the same PGH information will be removed automatically when the new PGH is re-generated.
*At the end of each run, [RPYEU] removes any GVT Run Number that does not have any GVT Header associates with it.
*[RPYEU] may be run concurrently for different sets of employees.
*At the beginning of the [RPYEU] run, the Execution Run Log is stamped with the Execution Start Date, then at the end of RPYEU, the Execution End Date is stamped
*For a concurrent [RPYEU] run that has not been finished with the Execution End Date, the other concurrent [RPYEU] run will not remove the GVT Run Number even if there are no GVT Headers.
This page (revision-13) was last changed on 26-Nov-2021 10:22 by mmcfarlandTop