Understanding the Build G/L Workfile Program

Unlike the A/P ledger method, you build the worktable for the G/L method at the end of the 1099 process.

After you adjust payment amounts in the Account Ledger table (F0911), you build the worktable from which you will create 1099 returns. The Build 1099 G/L Workfile program (R04514) uses data from the Address Book Master (F0101) and Account Ledger (F0911) tables to create the 1099 G/L Worktable (F045141). The F045141 worktable is used only to gather information to be reported to the IRS on 1099 forms, and is not used for any other purpose.

Oracle recommends that you use the Build G/L Workfile program to generate a single worktable for all returns, regardless of whether you submit 1099 returns for several companies or different types of 1099 returns for the same company. You can then run the Write 1099 Media program (P04515) for each type of return using data selection by company to control what prints on the 1099 forms.

The Build G/L Workfile program does not generate a report. To ensure that the program finishes successfully, review your workflow messages. You can run this program as many times as necessary. If you enter adjustments by using the Enter Payment Adjustments program (P04510) after you build the worktable, you must rerun the Build 1099 G/L Workfile program each time you enter corrections. This program clears the F045141 table and then rebuilds it.

Note: If you use both the A/P ledger and G/L methods and you use the Enter A/P Workfile Adjustments program (P04510FP) to enter corrections, you will not have an audit trail for those adjustments.