This page (revision-29) was last changed on 01-Feb-2024 11:56 by Lilia Urtan

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

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
29 01-Feb-2024 11:56 6 KB Lilia Urtan to previous
28 01-Feb-2024 11:55 6 KB Lilia Urtan to previous | to last
27 04-Jan-2024 12:54 6 KB Kevin Higgs to previous | to last
26 04-Jan-2024 12:43 5 KB Kevin Higgs to previous | to last
25 04-Jan-2024 12:43 5 KB Kevin Higgs to previous | to last
24 04-Jan-2024 12:36 5 KB Kevin Higgs to previous | to last
23 15-Feb-2023 15:18 4 KB Karen Parrott to previous | to last
22 15-Feb-2023 15:11 4 KB Karen Parrott to previous | to last
21 26-Nov-2021 10:22 4 KB Karen Parrott to previous | to last

Page References

Incoming links Outgoing links

Version management

Difference between version and

At line 1 removed 2 lines
[{TableOfContents }]
At line 2 added one line
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. The RPYEU process generates a summary of US payroll year end data.
At line 5 changed one line
The RPYEU form allows you to print out a summary of United States payroll year end.
Please click on this link for additional information for the [NJ WR-30] format.
At line 7 changed one line
Additional information for the [NJ WR-30] format
!!RPYEU Report Parameters & Filters
At line 9 changed 2 lines
!!!Processing Information
The parameter 'Combine Fed Regist' is mostly used for State filing so the employee is reporting only once for a State even if they have been paid by multiple Fed Reg. Therefore, when Combine Fed Reg = YES, RPYEU cannot put the Federal amounts under any Fed Regist and cannot insert an IPGH Amounts and Govt Totals record. There will will be a message for this situation "*** WARNING: (Combine Fed Regist) = Yes, IPGR Federal Amounts and Employee Remittance Header are not added by Federal Registration Number"
__Report Parameters__
||Parameter||Description
|Annual Form Code|Mandatory. \\Form Code that is defined on the IDFDV form. \\NOTE: Always use the current year form code. __DO NOT__ use a prior year form code as the Identifiers may be obsolete.
|Quarterly Form Code|Blank for Annual Reporting. Defines the quarterly form code for the report. Optional
|Govt Interface Format|Blank for Annual Reporting. Defines the government interface format for the report. Optional
|Period Type|Mandatory. Defines the period type. Enter "Year" for Annual reporting and "Quarter for quarterly reporting.
|Period End Date|Mandatory. Defines the end date of the reporting period.
|As of Date|Mandatory. Defines the date to start gathering demographic information.
|Combine Employment Type|Defines if the employees on the report should be sorted by their Employment Type Set this field to YES to combine Regular and Other Types of Employment, such as Agriculture. Optional. \\ \\This parameter is used mostly for State filing so an employee is reported only once for a State, even if they have been paid by multiple Federal Registrations. Therefore, when this field is set to YES, RPYEU will not store the Federal Level amounts on the IPGH form because the Federal Registration Numbers are combined and will not be linked to a specific Federal Registration Number. \\ \\A warning message is issued when this field is set to YES: *** WARNING: Combine Fed Regist = Yes, IPGR Federal Amounts and Employee Remittance Header are not added by Federal Registration Number.\\ \\When reporting W2 Employment Types of Regular and Medicare Qualified, it is recommended that this parameter be set to 'No'
|Combine Fed Regist|Defines if all of the selected 'Federal Regist' for State/Local Reporting should be combined. Set this field to YES to combine all 'Federal Regist' for State/Local reporting. Optional
|Media Format|Defines the Federal file format for SSA reporting. Optional
|Directory Name| Mandatory. Defines the name of the government Magnetic Media file.
|Media File Name|Mandatory. Defines the media file name of the data being uploaded.
|Create Data Dump| Defines if a data dump file with the extension of .csv should be generated. Optional
|Trace Level|Defines the tracing level (report messages) for the report. Optional. Users should always run RPYEU with the Trace Level set to 'Exceptions Only' for all employees, unless required for tracing.
|Regist/Set Up Audit|Option to print exceptions that may exist from set up. Optional. Options are: \\00-Do not print, run \\01-Print, do not run \\02-Print and run \\03-Excp and run
|User Comments|Enter a comment to print on the header of the report. Optional
|Govt Form Option|Determines Government Run Stage, Government Print Stage and Government File Stage of created Government Run and Government Headers. Mandatory. See Lexicon [X_GVT_FORM_OPTION] for more details. Options support by RPYEU are: \\01-New forms only \\02-All normal forms \\04-Amended forms \\05-Rejected forms
|Retain Amend/Reject File|Determines if existing Gvt Run and Headers will be deleted or marked as archived. \\No - Existing Government Run will be replaced \\Yes - New Government Run will be created. Should only be used in combination with Gvt Form Option 04-Amended Forms and 05-Rejected Forms.
|Print Report On| Defines to print a report, output or both. Options are: \\* Report only (default) \\* Report and Output File \\* Output File Only \\* Do Not Print
At line 29 added 18 lines
__RPYEU Report Filters__
||Filter||Description
|Entity|To define and report on a specific Entity. Optional
|Federal Regist Set|To define and report on a specific Federal Registration Set, on [IDGV]. Optional
|Federal Regist Type|To define and report on a specific Federal Registration type, defined on IDGV. Optional
|Federal Regist Number|Defines the Employer Identification Number, on [IDGV]. Optional
|People List|This field limits the process to the people in the defined list. Optional
|Person|Enter the Person Code of the employee you are tesating with. Optional
|Select State|Defines a State to report on. Optional. Do not enter a State when generating the Federal File or W2 forms. If a State is selected, the process will report on the defined State only.
|State Regist Set|To define and report on a specific State Registration set, on [IDGV]. Optional. This field is not required for Annual reporting.
|State Regist Type|To define and report on a specific State Registration type, defined on IDGV. Optional
|State Regist Number|Used only for Quarterly State filing. Is a State is not entered, then the Federal Regist Number on [IDGV] is used. Optional
|Local Regist Set|To define and report on a specific Local Registration set. Optional
|Local Regist Type|To define and report on a specific Local Registration type, defined on IDGV. Optional
|Local Regist Number|To define and report on a specific Local Registration set. Optional
|Select County|To define and report on a specific County. Optional
|Select City|To define and report on a specific City. Optional
|Select School|To define and report on a specific School District. Optional
At line 13 changed one line
!!Report Parameters & Filters
!!Processing Ammendments
At line 15 changed 16 lines
||Report Parameters||
|Annual Form Code|Mandatory, LOV available\\This field allows you select the annual form for the report.
|Quarterly Form Code|Optional, LOV available\\This field allows you select the quarterly form for the report.
|Govt Interface Format|Optional, LOV available\\This field allows you select the government interface format for the report.
|Period Type|Mandatory, [Period Type|X_IDFD_PERIOD_TYPE] lexicon available\\This field the period type for the report.
|Period End Date|Mandatory, Date, LOV available\\This field indicates the end date of the period being reported.
|As of Date|Mandatory, Date, LOV available\\This field indicates the date the information for the report is being reported as of.
|Combine Employment Type|Optional,[Yes/No|X_YES_NO] lexicon available\\If <YES> the employment type will be combined.
|Combine Fed Regist|Optional,[Yes/No|X_YES_NO] lexicon available\\If <YES> the federal register will be combined.
|Media Format|Optional,[Media Format|X_W2_MEDIA_FORMAT] lexicon available\\This field allows you to indicate the media format of the report.
|Directory Name| Mandatory, Text\\This field displays the name of the source directory.
|Media File Name|Mandatory, Text\\This field displays the media file name of the data being uploaded.
|Create Data Dump|Optional, [Yes/No|X_YES_NO] lexicon available
|Trace Level|Optional, [Trace Level|X_TRACE_LEVEL] lexicon available. This field defines the exception level (report messages) required.
|Regist/Set Up Audit|Optional,[Print and Run|X_PRINT_AND_RUN] lexicon available
|User Comment|Optional, Text\\This field holds the user-supplied comment which will appear in the header of all pages of the report.
Complete the initial run using Government Form Option 02-All normal forms until satisfied with the results. For the inital submission, the preference will be to only have 1 government run referenced.
At line 32 changed 14 lines
||Report Filters||
|Entity|Optional, LOV available\\This field limits the process to the entity specified.
|Federal Regist Set|Optional, LOV available\\This field limits the process to the federal registration sets specified.
|Federal Regist Number|Optional, LOV available\\This field limits the process to the federal registration numbers specified.
|People List|Optional, LOV available\\This field limits the process to the people list specified.
|Person|Optional, LOV available\\This field limits the process to the persons specified.
|Select State|Optional, LOV available\\This field limits the process to the state specified.
|State Regist Set|Optional, LOV available\\This field limits the process to the state registration sets specified.
|State Regist Number|Optional, LOV available\\This field limits the process to the state registration numbers specified.
|Local Regist Set|Optional, LOV available\\This field limits the process to the local registration sets specified.
|Local Reigst Number|Optional, LOV available\\This field limits the process to the local registration numbers specified.
|Select County|Optional, LOV available\\This field limits the process to the county specified.
|Select City|Optional, LOV available\\This field limits the process to the city specified.
|Select School|Optional, LOV available\\This field limits the process to the school specified.
\\Once satisfied with the results of RPYEU, Run the W2 print with trial run "No". This will change the following: \\
|GVT_PRINT_STAGE|IPGH = From Printed
|GVT_RUN_STAGE|IPGR = Form Printed
By doing this the data is locked and you are ready for handling amended forms when needed.
At line 57 added 4 lines
\\ If you need to amend an employees form you will have to do into IPGH and mark the Print stage as Amendment requested. Then when you run RPYEU with 04-Amended forms it will pick up these records and create the necessary file for W2C upload.