This page (revision-21) was last changed on 26-Nov-2021 10:22 by Karen Parrott

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

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
21 26-Nov-2021 10:22 56 KB Karen Parrott to previous 1099R_PROCESSING ==> 1099R PROCESSING

Page References

Incoming links Outgoing links
1099 R PROCESSING...nobody
1099R PROCESSING

Version management

Difference between version and

At line 1 changed 2 lines
!!!1099R Processing
There is required set up of 1099RWs before the forms, reports and media files can be produced. Users must confirm the setup of groups, states, counties, school districts and tax jurisdictions as they apply to your organization. \\ \\
[{TableOfContents }]
\\
!!!1099R Form Processing
At line 5 added 2 lines
There is required set up for 1099Rs before the forms and reports can be produced. Users must confirm the setup of groups, states, counties, school districts and tax jurisdictions as they apply to your organization. \\ \\
At line 6 changed one line
After the 1099RWs set up is complete, the Summary Report is run for comparison to the Year-To-Date Register. When everything is balanced, the 1099RWs can be printed and the summary report can be re-run to produce the required media file.
After the 1099R set up is complete, the Summary Report is run for comparison to the Year-To-Date Register. When everything is balanced, the 1099Rs can be printed.
At line 8 changed 2 lines
!!!Year End Changes
__New for 2018__
!!!2018-2019 Year End Changes
__New for 2018__ \\
At line 22 removed 2 lines
!!!IDFD Form Definition
At line 26 changed 2 lines
https://www.irs.gov/pub/irs-pdf/i1099RW.pdf \\
https://www.irs.gov/pub/irs-pdf/f1099RW.pdf \\ \\
https://www.irs.gov/pub/irs-pdf/i1099R.pdf \\
https://www.irs.gov/pub/irs-pdf/f1099R.pdf \\ \\
At line 29 changed one line
__Form Code HL$US-1099RW-2019__ \\ \\
!!!1099R SET UP
At line 31 changed one line
High Line provides seed data scripts to our clients with the Year End Software release to load the IDFD Form Code definition SEED_IDFD_HL$US_1099RW_YYYY.sql. \\ \\
!Date of Payment
For the new 'Date of Payment' field, Seq#2815, R99-DATE-OF-PAYMENT, a combination of User Defined Fields (UDF) in IMUF and User Fields (UF) in IMCD are used. \\ \\
At line 33 changed one line
It is not necessary to maintain this form, unless instructed to do so by High Line. \\ \\
The seed data (SEED_RP1099RWWW_20181220.sql) provided will create new user fields as follows:
* On IMUF, Table Alias EID – new User Field called Date_of_Payment in IMUF
* On IMCD, Table Alias EID - new Column Date_of_Payment
* On the IMFD/IMFDV, Sequence 2815, Identifier “R99-DATE-OF-PAYMENT” for the new field will also be created.
At line 35 changed one line
Users can copy the IDFDV Variable definition from last year to the current year. Please refer to the US 2018 1099RW Process document, Copy Last Year’s definition to Current Year section. \\ \\
__After loading the seed data, confirm these 2 fields are created.__ \\ \\
At line 37 changed one line
This seed data script is re-runnable. It will not erase the IDFDV set up of the same Form Code. \\ \\
On IDFDV, for the new “R99-DATE-OF-PAYMENT’ Identifier, the field variable column must be set to “EID.DATE_OF_PAYMENT”. \\ \\
At line 39 changed one line
!!!IDFDV Form Variables
On the Maintain Identity Information (IEID) form, in the ‘Date of Death Benefit Paid’ User Field, the date must be entered for the defined employees.
At line 41 removed 2 lines
IDFD Form: HL$US-1099RW-YYYY – system provided \\
IDFD Form Type: US 1099RW Definition \\ \\
At line 44 changed one line
__Form Code HL$US-1099RW-2019 Identifiers__
!!1099R Form Definitions IDFD
__Form Code HL$US-1099R-2019__\\
High Line provides seed data scripts to our clients with the Year End Software release to load the IDFD Form Code definition SEED_IDFD_HL$US_1099R_YYYY.sql. \\It is not necessary to maintain this form, unless instructed to do so by High Line. \\ \\
At line 46 changed one line
__NOTE: Fields marked with an asterisk (*) are mandatory.__\\ \\
Users can copy the IDFDV Variable definition from last year to the current year. Please refer to the Copy Last Year’s definition to Current Year section, below. \\ \\This seed data script is re-runnable. It will not erase the IDFDV set up of the same Form Code.
At line 48 changed one line
;R99 Form Code Definitions
!IDFD Store Option
The IDFD Form Code HL$US-1099R-2019 provides the Store Option starting from Seq# 2000 in order for the RPYEU process to store the Employer Name/Addresses, the Employee Name/ Addresses and the Amounts of the Seq# in the Government Remittance Tables. \\
__IMPORTANT:__ Users must run the RPYEU process with the new IDFD HL$US-1099R-2019 Form Code, or users can run a copy of this Form Code that has the Store Option set up to store the Addresses and the Amounts in the Government Remittance Tables. \\
Any prior year’s Form Codes do not supply this Option and therefore will not turn on the Store feature for the RPYEU process. \\ \\
!IDFDV – Copy Last Year’s Definition to Current Year
After the HL$US-1099R-2019 information has been loaded, users can copy the IDFDV Variable definition from the last year to the current year using the COPY button on the IDFDV form as follows: \\ \\
1) On the IDFDV form, select last year’s Form Code: HL$US-1099R-2018 \\
2) Press the Copy Form Definition button \\
3) The Copying dialog box is displayed. Enter the current year New Form Code: HL$US-1099R-2019 \\
4) Set the Copy Definition with Variables toggle to ON. This will copy the variables set up from HL$US-1099R-2018 to HL$US-1099R-2019 for the same Field Identifier name. \\
!IDFDV Form Descriptions
Use the IDFDV form to enter the variable data needed to correctly complete the 1099R’s, for the printed 1099R’s.
Users should only work with the Source and Field Variable columns. The Derivation Expression field can be used by __advanced__ users or under the guidance of a High Line consultant.
On this form, users define where, in their particular set up, each required field of data is to be retrieved from.
!IDFDV Field Descriptions
||Field||Desciption
|Seq #|Defines the sequential order of the variable.
|[Identifier|FIELD_IDENTIFIER]|The fields within this form are defined here.
|[Description|DESCRIPTION]|Enter a short description of the variable.
|[Level|FIELD_LEVEL]| Defines the field level, such as employee, employer, federal, etc.
|[O/R Prompt|OVERRIDE_PROMPT]|The override name of the field that will be displayed on the form is defined here.
|[Source|FIELD_SOURCE]|Defines the type of source of the field, such as database column, element, pay component, etc.
|[Field Variable|FIELD_VARIABLE]|The variable for the field is defined here.
|[Copy Form Definition|]|Press this button to copy the form definition.
|[Field Usage|FIELD_USAGE]|Defines the field usage, such as file only, form only, internal, etc.
|[Text|REFERENCE_TEXT]|Users can add additional notes in this field
|[Derivation Expression|DERIVATION_EXPRESSION]|Users can add programming code for additional computation of the data within the record.
!!!IDFDV Form Defintion Variables
After IDFD is loaded, users must set up their organization’s information for this Form Definition on the IDFDV form. \\ \\
__IDFDV HL$US-1099R-2019 Form Code Identifiers__\\ \\
IDFD Form: HL$US-1099R-YYYY – system provided \\
IDFD Form Type: US 1099R Definition \\
NOTE: Fields marked with an asterisk (*) are MANDATORY \\
At line 54 removed one line
|SUB-VENDOR|Software Vendor Code|Constant|Enter your company data
At line 57 changed one line
|SUB-COMP-LOCN|Company Location Address|Constant|Enter company’s location address\\ \\such as Attention, Suite, Room # etc
|SUB-COMP-LOCN|Company Location Address|Constant|Enter company’s location address\\ \\such as Attention, Suite, Room #
At line 88 changed one line
|ER-TERM=BUS|Terminating business indicator|Constant|Enter appropriate code from SSA
|ER-TERM-BUS|Terminating business indicator|Constant|Enter appropriate code from SSA
At line 105 changed one line
|R99-ER-ACCT-NO|Account Number|Constant, Data Base Column or IDGV variable|For IDGV variable, users can look up the IDGV Field Variable and enter the Account NUmber on IDGV
|R99-ER-ACCT-NO|Account Number|Constant, Data Base Column \\ or IDGV variable|For IDGV variable, users can look up the IDGV Field Variable and enter the Account Number on IDGV
At line 123 changed one line
|R99-DATE-OF-PAYMENT|Date of Death Benefit Paid|Data Base Column|EID.DATE_OF_PAYMENT. See note below for setup
|R99-DATE-OF-PAYMENT|Date of Death Benefit Paid|Data Base Column|EID.DATE_OF_PAYMENT.
At line 187 added one line
|R99-ALLOC-TO-IRR|Amount allocable to IRR within 5 years|Pay Component|F1099R-BOX-10
At line 140 changed one line
|R99-FATCA|FATCA Requirement|Element|F1099R-BOX-10-FATCA
\\
At line 156 changed one line
|R99-CODE-E|Excess 425 or 403(b)|Pay Component|Enter your company data
|R99-CODE-E|Excess 415 or 403(b)|Pay Component|Enter your company data
At line 158 changed one line
|R99-CODE-G|Rollever contribution|Pay Component|Enter your company data
|R99-CODE-G|Rollover contribution|Pay Component|Enter your company data
At line 167 changed one line
|R99-CODE-U|ESOP under section 404(k)|Pay Component|Enter your company data
|R99-CODE-W|Payments for LT Care Insurance|Pay Component|Enter your company data
\\
At line 174 changed one line
\\
At line 184 changed 2 lines
|R99-CN-DIST-HOME|County Distributions (Home County)|Element|R99-CNTY-DIST-H|State
|R99-CN-DIST-WORK|County Distributions (Work cOUNTY)|Element|R99-CNTY-DIST-W|State
|R99-CN-DIST-HOME|County Distributions (Home County)|Element|R99-CNTY-DIST-H
|R99-CN-DIST-WORK|County Distributions (Work cOUNTY)|Element|R99-CNTY-DIST-W
At line 194 removed one line
!!!DATE OF PAYMENT Field Setup
At line 196 removed 20 lines
For the new field Date of Payment, Seq#2815, R99-DATE-OF-PAYMENT, a combination of User Defined Fields (UDF) in IMUF and User Fields (UF) in IMCD will be used.
The seed data (SEED_RP1099RWWW_20181220.sql) provided will create new user fields as follows: \\
*On IMUF, Table Alias EID – new User Field called Date_of_Payment in IMUF
*On IMCD, Table Alias EID - new Column Date_of_Payment
*On the IMFD/IMFDV, Sequence 2815, Identifier “R99-DATE-OF-PAYMENT” for the new field will also be created. \\
After loading the seed data, confirm these 2 fields are created. \\ \\
In IDFDV, for the new Seq#2815 Identifier “R99-DATE-OF-PAYMENT’ the field variable column must be set to “EID.DATE_OF_PAYMENT”. \\ \\
On the Maintain Identity Information (IEID) form, in the User Field ‘Date of Death Benefit Paid’, the date must be entered for the selected employees.
!!!US Year End Summary Report = RPYEU
Enter the most current year's IDFDV Form Code for 1099R reporting.
!!!1099RW Form Print Selection Criteria
INSERT RP1099RW PAGE
At line 227 changed one line
Users should verify the RP1099RW numeric box totals balance to the RPYEU numeric box totals. \\
Users should verify the RP1099RW numeric box totals balance to the RPYEU numeric box totals. \\ \\
At line 237 removed 31 lines
!!!1099R MAGNETIC MEDIA FILING
If an employee has worked and/or lived in multiple tax jurisdictions during one taxation year, the reporting of 1099RW for this employee is as follows: \\ \\
!Taxation Level Processing
If an employee has worked in and/or lived in multiple tax jurisdictions during one taxation year, the reporting of 1099R for this employee is as follows:
__Federal Level__
*Federal information is totaled for all states for all employments for the reporting year by Federal Government Registration
*This includes Box 1 to 14
*The reporting of 1099R Form and Magnetic Media filing is sorted and grouped by Federal Government Registration.
*After all federal information is summarized, the Federal information will be printed on the first 1099R form for the employee (Box 1 to 11, Box 12's first 4 entries and Box 14's first 2 entries).
*Additional Box 12 and 14 information is printed on subsequent 1099R forms for each employee. These forms will __not__ repeat the federal information (Box 1 to 11).
__State Level__
*State information is summarized by each individual State regardless of whether the State Tax is generated from Work State Tax or Residence State Tax.
*If an employee has multiple tax jurisdictions within one State, the State tax information will be summarized by State.
*This includes Box 15 to 17 and SUI quarterly information.
*After all State information is summarized, each State is printed on the 1099R form and overflows onto subsequent 1099R forms, until all states are printed.
__Local Level__
*Local information is reported for County Tax Information and City Tax Information.
*If County tax has been withheld for a GEO code, the County tax information is summarized by the GEO code, regardless of whether the tax is generated as Work County or Residence County tax
*If City tax has been withheld for a GEO code, the City tax and wages are summarized by the GEO code regardless if the tax is generated as Work City or Residence City tax.
*This includes Box 18 to 20.
*After all Local (County/City) information is summarized, each Local is printed on the 1099R form and overflows onto subsequent 1099R forms, until all Locals are printed.
__School Level__
*School District tax information is reported in Box 14 with School Wage Base and School Tax
*On each 1099R form, Box 14 - "Other Information" allows up to four lines to be reported. Each Box 14 information requires 2 lines to be printed; the first line to print the description and second line to print the amount. School information requires 4 lines, therefore subsequent 1099R forms will be generated if more Box 14 entries (4 lines) are required.
*On each 1099R form, Box 12 code allows up to four entries to be reported. Subsequent 1099R forms will be generated if more entries are required.
At line 286 removed 6 lines
!Government Media File Name
*When [RPYEU] is run, users can select to generate a magnetic media file
*Users must define a valid directory name and a magnetic media file name, such as 1099R_2017.txt)
*Users can also attach the [RPYEU] Execution ID to the file name by defining the word ‘Mex’ in the file name, such as 1099R_2017_mex.txt. This will generate a magnetic media file 1099R_2017_67109.txt for Execution ID 67109
Example: 1099R_mex_ohio.txt will generate a magnetic media file 1099R_67109_ohio.txt for Execution ID 67109
At line 311 removed one line
**rpyeu_1099R_750234.txt - Magnetic media file to be sent to the government
At line 320 removed one line
**rpyeu_1099R_150277.txt - Magnetic media file to be sent to the government
At line 323 removed 4 lines
!Government Media File – Code RW, RS when Select by State
*When [RPYEU] is run with no specific State selected, the Federal magnetic media file and Code RW records will be generated.
*When [RPYEU] is run with one State selected, only the specific State records is processed, therefore Code RW records will __not__ be generated.
Code RS records will be generated according the State government requirements and the 1099R State Media Filing’ defined on [IDGV Variables|IDGV#VariablesTab] tab.
At line 372 changed one line
!!!RPYEU
At line 405 removed one line
The following exception messages are always printed for an employee:
At line 539 removed one line
At line 564 removed 13 lines
Form Code: Use current year's form code \\
Identifier: 1099R-CONTROL-PRINT \\
Level: Federal \\
O/R: CONTROL NUM PRT \\
Source: Constant \\
Field Variable Options: \\
*Null, 0 – Do not print Control Number on 1099R Form
*1 - Print Control Number as defined in 1099R-CONTROL-NUM Identifier
*2 - Print Control Number as defined from RPYEU ‘Sort Level By’ field
*3 - Print 1099R-CONTROL-NUM Identifier and Person Code
*4 - Print ‘Sort Level By’ field and Person Code
*5 - Print ‘Sort Level By’ field and 1099R-CONTROL-NUM Identifier
*6 - Print ‘Sort Level By’ field, the 1099R-CONTROL-NUM Identifier and Person Code \\
At line 551 added 8 lines
||Field||Description
|Form Code|Use current year's form code
|Identifier|1099R-CONTROL-PRINT
|Level|Federal
|O/R|CONTROL NUM PRT
|Source|Constant
|Field Variable|Options are: \\ *Null, 0 – Do not print Control Number on 1099R Form \\ *1 - Print Control Number as defined in 1099R-CONTROL-NUM Identifier \\ *2 - Print Control Number as defined from RPYEU ‘Sort Level By’ field \\ *3 - Print 1099R-CONTROL-NUM Identifier and Person Code \\ *4 - Print ‘Sort Level By’ field and Person Code \\ *5 - Print ‘Sort Level By’ field and 1099R-CONTROL-NUM Identifier \\ *6 - Print ‘Sort Level By’ field, the 1099R-CONTROL-NUM Identifier and Person Code \\
At line 581 removed 6 lines
Form Code: Use current year's form code \\
Identifier: 1099R-CONTROL-NUM \\
Level: Federal \\
O/R: CONTROL NUMBER \\
Source: Data Base Column \\
Field Vaiable Option: Enter your company data, such as 'EID.PERSON_CODE’, or ‘DLN.LOCALITY’, or ‘PPA.PAYROLL_CODE’ etc. \\
At line 588 changed 2 lines
If Seq # 2810 1099R-CONTROL-NUM defines a data base column, such as PPA.PAYROLL_CODE, and:
* within the reporting year the employee has been paid by more than one entry of this database column (employee is paid under 2 Payroll Codes), and
||Field||Description
|Form Code|Use current year's form code
|Identifier|1099R-CONTROL-NUM
|Level|Federal
|O/R|CONTROL NUMBER
|Source|Data Base Column
|Field Variable|Enter your company data, such as 'EID.PERSON_CODE’, or ‘DLN.LOCALITY’, or ‘PPA.PAYROLL_CODE’ etc. \\
__NOTE:__ If Seq # 2810 1099R-CONTROL-NUM defines a data base column, such as PPA.PAYROLL_CODE, and:
* within the reporting year, an employee has been paid by more than one entry of this database column (employee is paid under 2 Payroll Codes), and
At line 591 changed one line
the YTD values will be accumulated together, and 1099R Form Box D Control Number will be printed with one [PAYROLL_CODE] only, usually the [PAYROLL_CODE] with the name that is sorted last. \\ \\
the YTD values will be accumulated together, and 1099R Form Box D Control Number will be printed with one [PAYROLL_CODE] only, usually the [PAYROLL_CODE] with the name that is sorted last. \\
At line 597 changed one line
Then ‘US WEST BW’ code will be printed.
Then ‘US WEST BW’ code will be printed. \\
At line 602 changed one line
Users can run RPREGT for a group, unit, department, etc., or for a list of employees using the People List Code parameter. \\ \\
* Users can run RPREGT for a group, unit, department, etc., or for a list of employees using the People List Code parameter. \\ \\
* Create an element on the IPPE form with only the pay components that will be reported on the 1099RW form. This will greatly reduce the size of the Year-to-Date Register. \\ \\
* If an employee worked in two different jurisdictions, there will be one register for each jurisdiction. Consequently, the employee will receive a separate 1099RW form for each jurisdiction. \\ \\
* For auditing purposes, (comparing RPREGT TO RPYEU) users should define the Provide Totals By field as Fed Regist Number when RPREGT is run. \\ \\
At line 604 removed 6 lines
Create an element on the IPPE form with only the pay components that will be reported on the 1099RW form. This will greatly reduce the size of the Year-to-Date Register. \\ \\
If an employee worked in two different jurisdictions, there will be one register for each jurisdiction. Consequently, the employee will receive a separate 1099RW form for each jurisdiction. \\ \\
For auditing purposes, (comparing RPREGT TO RPYEU) users should define the Provide Totals By field as Fed Regist Number when RPREGT is run. \\ \\
At line 642 changed one line
\\
At line 627 added one line
|Federal Regist Type|To define and report on a specific Federal Registration type, defined on IDGV. Optional
At line 649 changed one line
|Person|Enter the Person Code of the employee you are tesating with. Optional
|Person|Enter the Person Code of the employee you are testing with. Optional
At line 652 changed one line
|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
|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. If a State is not entered, then the Federal Regist Number on [IDGV] is used. Optional
At line 654 changed one line
|Local Reigst Number|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
At line 659 removed 12 lines
!!RPYEU Selection Criteria - Quarterly Reporting
__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|Optional. If not defined, it defaults to the Annual Form Code with the EF1099R format. \\ \\If the State is using a format such as ICESA, TIB-4 and other special formats 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 EF1099R.
|Govt Interface Format|Optional. Some States require a specific government XML file format that is defined on the IDIF form. \\Example: The Florida State format is HL$US-QTR-FL2019. Please refer to the State document that indiciates if this parameter should be used.
|Period Type|Mandatory. Defines the period type. Enter "Quarter" for quarterly reporting.
|Period End Date|Mandatory. Defines the end date of the quarterly reporting period.
|As of Date|Mandatory. Defines the start date of the quarterly reporting period.
|Combine Employment Type|Defines if the employees on the report should be sorted by their Employment Type. Set this toggle to YES to combine Regular and Other Types of Employment.
|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. __DO NOT SET THIS TOGGLE TO YES WHEN GENERATING THE FEDERAL FILE.__\\ \\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.
|Media Format|Enter the State file format or SUI file format for State Reporting. For the SUI file format, use the SUI Registration Number from IDGV.
At line 672 removed 25 lines
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
__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
At line 698 changed one line
Users should read the following form descriptions and refer to the IRS 2018 instructions for Forms 1099R and 5498 prior to setting up the IDFDV form. \\https://www.irs.gov/pub/irs-pdf/i1099RW.pdf
Users should read the following form descriptions and refer to the IRS 2018 instructions for Forms 1099R and 5498 prior to setting up the IDFDV form. \\https://www.irs.gov/pub/irs-pdf/i1099R.pdf
At line 700 changed one line
2018 1099R format for reporting in 2019
!2018 1099R format for reporting in 2019
At line 668 added 2 lines
!!!RP1099RW Form Print Program
The US 1099R Forms (RP1099RW) report will print a list of 1099R forms. The RP1099RW program currently supports the 2 on-a-page format.
At line 671 added 7 lines
||Report Parameters||Description
|EE/ER Copy|Optional. Defines if the Employee ot Employer copy of 1099 will be printed. Options are: \\*01 - Employer Copy \\*02 - Employee Copy
|Corrected Toggle|Optional. When this toggle is set to ON, an “X” will be printed in the Corrected box (top of form).
|Reissued/Corrected|Optional. Defines if the 1099RW is being reissued for an employee. \\If an employee has lost their 1099RW form and have requested a replacement copy, users should run the RP1099RW process and define the Person Code for the specific employee. \\*Enter the word REISSUED in this field for re-issued 1099RW forms. \\*Enter the word CORRECTED in this field for corrected 1099RW forms. Users can enter a date in this field to indicate the Date of the Corrected copy (if an employee has more than one corrected copy). \\The exact wording in this field will be printed on the top of the 1099RW form.
|Exception Level|Optional. Defines the level of detail on the exception report. Users should always run with the Exception Level set to Exception Only for all employees, unless it is being used for debugging.
|Trial Print Only|Defines if the Print Stage field on the IPGH form will be updated when the 1099s are printed. \\When set to YES, the field will not be updated. \\When set to NO, the Print Stage will be updated to Forms Printed
|User Comment|Optional, Text\\This field holds the user-supplied comment which will appear in the header of all pages of the report.
At line 679 added 6 lines
||Report Filters||Description
|GVT Run|Mandatory. This field defines the GVT Run number to be used to read, extract the data from and produce the 1099R forms.
|State|Optional. If used, only one State can be entered. \\This field should not be defined when users are printing the Employee Copy. Employees MUST have all of the States printed on their 1099 forms. \\ \\When printing the Employer copy, users can define to print by State to file the 1099RW paper copy to the State.
|Person|Optional. Users can enter one or more person codes to report on.
This page (revision-21) was last changed on 26-Nov-2021 10:22 by Karen ParrottTop