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 4 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 removed 2 lines
Additional information for the [NJ WR-30] format
At line 10 removed one line
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"
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.
__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 start date of the reporting period.
|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.
|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 reuqired 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
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.
__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 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 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 Reigst 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