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 3 changed one line
!!!1099R Form Processing
There is required set up of 1099Rs 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. \\ \\
At line 5 removed 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 9 changed one line
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.
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 and the summary report can be re-run to produce the required media file.
At line 32 changed 2 lines
!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. \\ \\
!!Date of Payment
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 are used. \\ \\
At line 44 changed one line
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.
On the Maintain Identity Information (IEID) form, in the ‘Date of Death Benefit Paid’ User Field, the date must be entered for the selected employees.
At line 54 changed one line
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. \\
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. \\ \\
At line 56 changed one line
__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. \\
__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. \\ \\
At line 69 changed one line
Use the IDFDV form to enter the variable data needed to correctly complete the 1099R’s, for the printed 1099R’s.
Use the IDFDV form to enter the variable data needed to correctly complete the 1099R’s, for both the printed 1099R’s and the Magnetic Media files.
At line 90 changed one line
After IDFD is loaded, users must set up their organization’s information for this Form Definition on the IDFDV form. \\ \\
__IDFDV Form Code HL$US-1099R-2018__
After IDFD is loaded, users must set up your organization’s information for this Form Definition on the IDFDV form. \\ \\
At line 92 changed one line
__IDFDV HL$US-1099R-2019 Form Code Identifiers__\\ \\
__IDFDV HL$US-1099R-2019 Form Code Identifiers__\\
At line 96 changed one line
NOTE: Fields marked with an asterisk (*) are MANDATORY \\
NOTE: Fields marked with an asterisk (*) are MANDATORY
At line 97 added one line
;IDFDV 1099R Form Defintion Variables
At line 105 changed one line
|SUB-COMP-LOCN|Company Location Address|Constant|Enter company’s location address\\ \\such as Attention, Suite, Room #
|SUB-COMP-LOCN|Company Location Address|Constant|Enter company’s location address\\ \\such as Attention, Suite, Room # etc
At line 153 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 189 changed 2 lines
|R99-FATCA|FATCA Requirement|Element|F1099R-BOX-10-FATCA
\\
At line 208 changed one line
|R99-CODE-G|Rollover contribution|Pay Component|Enter your company data
|R99-CODE-G|Rollever contribution|Pay Component|Enter your company data
At line 219 changed one line
\\
At line 226 changed one line
\\
At line 248 changed one line
The RP1099RW form print program prints all information retrieved from the RPYEU xml file, according to the selection criteria. \\ \\
The RP1099RW form print program prints all of the information retrieved from the RPYEU xml file, according to the defined selection criteria. \\ \\
At line 266 changed one line
If the RP1099RW process cannot select any information from the xml file to print, users must run RMEX with the RP1099RW Mex ID to review any error or exception messages to locate the problem.
If the RP1099RW process cannot select any information from the xml file to print, users must run RMEX with the RP1099RW Mex ID to review any error or exception messages to identify the problem.
At line 285 added 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 310 added one line
**rpyeu_1099R_750234.txt - Magnetic media file to be sent to the government
At line 319 added one line
**rpyeu_1099R_150277.txt - Magnetic media file to be sent to the government
At line 400 added one line
The following exception messages are always printed for an employee:
At line 534 added one line
At line 559 added 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 removed 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 576 added 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 563 changed 10 lines
||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
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
At line 574 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 580 changed one line
Then ‘US WEST BW’ code will be printed. \\
Then ‘US WEST BW’ code will be printed.
At line 585 changed 4 lines
* 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. \\ \\
Users can run RPREGT for a group, unit, department, etc., or for a list of employees using the People List Code parameter. \\ \\
At line 599 added 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 622 changed one line
\\
At line 630 changed one line
|Person|Enter the Person Code of the employee you are testing with. Optional
|Person|Enter the Person Code of the employee you are tesating with. Optional
At line 634 changed one line
|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
|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
At line 636 changed one line
|Local Regist Type|To define and report on a specific Local Registration type, defined on IDGV. Optional
|Local Regist Set|To define and report on a specific Local Registration type, defined on IDGV. Optional
At line 669 changed one line
The US 1099R Forms (RP1099RW) report will print a list of 1099R forms. The RP1099RW program currently supports the 2 on-a-page format.
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 changed one line
||Report Parameters||Description
||Report Parameters||
At line 676 changed one line
|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
|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 updated. \\When set to NO, the Print Stage will be changed to Forms Printed
At line 679 changed one line
||Report Filters||Description
||Report Filters||
This page (revision-21) was last changed on 26-Nov-2021 10:22 by Karen ParrottTop