Updating Voucher Pay Items for 1099 Processing
When you build the1099 A/P Workfile (F045143) you use processing options to specify the form and box to update and data selection to specify the vouchers to include. By updating the value of category code 07 on your voucher pay items, you streamline the selection process to build the workfile.
Depending on whether you updated category code 07 for the supplier's address book record, you have different options for updating voucher pay items for inclusion in the 1099 process:
If you supplied a default value to the supplier's address book record after you entered vouchers for the supplier, you can update the value of category code 07 on the voucher pay items by running the Update A/P Records with A/B Info program (P04802).
If the supplier has vouchers that update multiple boxes or multiple forms or you did not set up a default value in the supplier's address book record, you can use the Voucher 1099 Info Update program (P04125) to manually update the 1099 Reporting field (AC07) on voucher pay items.
Additionally, if you supplied a default value to category code 07 and need to remove the value, you can use the Voucher 1099 Info Update program to update the 1099 Reporting field to blank. The program does not supply the default category code 07 value from the supplier's address book record.
Note:When you update category code 07, the system updates the 1099 Reporting field (AC07) in the A/P Ledger file. Different programs reference the AC07 field differently, such as CatCode (P04105), Categ Code (P04114), and 1099 Reporting (P04125), but all of them update the AC07 field on F0411 records.
If you need to identify voucher pay items to exclude from the process, you can use the Voucher 1099 Info Update program to manually update the Flag for 1099 field (TNN), which you can then include in the data selection when you build the A/P workfile.
For example, Flag for 1099 EQ *BLANK or Flag for 1099 NE 1.
Updating voucher pay items for 1099 processing includes one or more of the following tasks:
Running Update A/P Records with A/B Info (P04802)
Using the Voucher 1099 Info Update Program (P04125)
If you do not have the Voucher 1099 Info Update program, JD Edwards World does not recommend that you open a prior G/L period to update the voucher using Standard Voucher Entry (P04105); instead, you should enter an adjustment using the 1099 Adjustments program (P045101).
Running Update A/P Records with A/B Info (P04802)
When you run Update A/P Records with A/B Info (P04802) the system automatically copies information from the Address Book Master file (F0101) to A/P Ledger records (F0411), including the value for category code 07.
The P04802 program does not use the Voucher Category Code 07 field (YC07), which you can specify to update via a processing option, for 1099 processing. The 1099 process uses only address book Category Code 07 field (AC07), which the program automatically updates unless you set the Field Protection processing option to 1.
Use data selection, if necessary, to limit the records that the system updates.
Navigation
From A/P Advanced & Technical Operations (G0431), choose Update A/P Records with A/B Info
Processing Options
Using the Voucher 1099 Info Update Program (P04125)
You use the Voucher 1099 Info Update program (P04125) to update one or both of the following fields:
The 1099 Reporting field (AC07)
You update this field with a category code 07 value from UDC 01/07.
Flag for 1099 (TNN)
Typically you use this field only to flag voucher pay items for exclusion from the 1099 process. However, because the Voucher 1099 Info Update program does not supply a default value for category code 07 (as the voucher entry programs do), you can also remove the value from category code 07 to exclude the voucher pay item from the process.
Unlike Standard Voucher Entry (P04105), which validates the voucher G/L date against the current open period, the Voucher 1099 Info Update program allows you to update both fields without any G/L date validations.
Navigation
From Annual 1099 Processing (G0422), choose Supplier Ledger Inquiry (P042003)
Alternatively, you can choose the Voucher 1099 Info Update program from the Annual 1099 Processing menu (G0422).
On Supplier Ledger Inquiry, to display paid vouchers for the supplier for the 1099 reporting year, complete the following fields.
Address Number
Date From and Date Through
Enter 8 in the Ledger Inquiry Sequence field to display paid vouchers by G/L date.
Enter 1 or P in the Paid field to limit the display to paid vouchers and click Enter.
Enter 9 in the Option field (Voucher 1099 Information Update) to select the vouchers to update and click Enter.
On Voucher 1099 Info Update, complete one or both of the following fields and click Enter:
Flag for 1099
1099 Reporting