Understanding the Update Payment Information Program
If you use the JD Edwards EnterpriseOne Procurement system to create vouchers using three-way matching, run the Update Payment Information - Receipts program (R045131) before you run the Update Payment Information program (R04513) to ensure that all purchase order payment information has been updated in the Account Ledger table (F0911).
The Update Payment Information program identifies vouchers that were partially or completely paid in the 1099 reporting year, are within the range for AAI item PXxxxx and are eligible for 1099 reporting. The program updates the payment information in the F0911 table with valid payment numbers and dates for those records that do not already include that information.
You can run this program multiple times for the current reporting year. The program does not change any adjustments that you have entered. Processing time depends on the number of records in the F0911 table. Run the program during off-peak hours. This program does not generate a report. To verify that the program finished successfully, review the workflow messages in the work center.
The Update Payment Information program (R04513) performs these steps:
For those records that are eligible for 1099 reporting, the program compares the open and gross amounts of each voucher to determine whether a payment has been applied and then either excludes vouchers if the open and gross amounts are equal (no payments have been made) or includes vouchers if the open and gross amounts are not equal (payments have been made).
If vouchers are included, the program then:
Reads the Account Ledger table (F0911) and matches the document number, document type, and company to the Accounts Payable Ledger table (F0411).
Reads the Accounts Payable Matching Document Detail table (F0414) for the payment ID. It then uses the payment ID to locate the record in the Accounts Payable - Matching Document table (F0413), from where it retrieves the payment number and payment date.
Bypasses deducting discount amounts from payments. However, if you leave the Discount Handling Method processing option blank, the program flags records with discounts as an exception. You can then create an adjustment record to reflect the discount so that the 1099 amount for the supplier is not overstated.
If the voucher was paid in full, the program updates the record in the AA ledger of the F0911 table with the payment number and date of the first related payment. If the open amount of the voucher is 0, and all of the payments were made in the reporting year that was specified in the processing option, then the system considers the voucher as paid-in-full for that reporting year
The payment is a partial payment for the reporting year specified in the processing option if the open amount of the voucher is not 0 or the open amount is 0, but not all payments were made in the reporting year. The Update Payment Information program then performs these steps:
Updates the record in the AA ledger of the F0911 with the payment number and payment date.
Creates an adjusting record in the tax ledger (TX) of the F0911 table with the payment number and payment date for the amount not paid in the current reporting year. The net effect of the AA and TX records is the payment amount.
Creates an adjusting record in the TX ledger of the F0911 table for the open amount of the voucher and uses a date one year in the future and a payment number of *. The program does not process this entry in the current reporting year because it is marked with * and contains the next year in the Reporting Year field. This future record is a reminder record for the program and is used during the next year's 1099 processing.
Reads unresolved adjustment records in the TX ledger from the previous year. Depending on how you set the processing option for Process Exception Items, the program:
Leaves the record as an exception and you must manually update the payment number when you leave the processing option blank.
Replaces the * with a payment number when you enter 1 in the processing option.