Reviewing the 1099 Audit File
You can review the contents of the audit file online using the Audit File Review program or by running the 1099 Audit Report and the 1099 G/L Audit Register.
Reviewing the audit file includes the following tasks:
Reviewing the audit file online
Reviewing the 1099 audit report
Reviewing the 1099 G/L audit register
Reviewing the Audit File Online
The Audit File Review program (P045142) displays a view of the 1099 reportable expenses and allocated payment records from the 1099 Audit File (F045144). You can review voucher and payment information for specific suppliers, as well as make payment adjustments.See Entering Payment Adjustments for more information.
Use the fields in the header portion of the screen to filter the information that displays, including: Supplier Number, Document Number, Company, Record Code (Type) and Obj/Subsidiary. If you do not use this feature, the program displays all records in the F045144 file. Additionally, the program allows you to access other programs, such as Supplier Ledger Inquiry (P042003) or Account Ledger Inquiry (P09200).
With the exception of calendar year, which the system retrieves from the 1099 Processing Option Setup program (P04510STUP), processing options allow you to preload values into any of the header fields. You can also specify the version of Supplier Ledger Inquiry and Account Ledger Inquiry to use for research purposes. For example, you might want to set up a version of Supplier Ledger Inquiry to sort and display records in a specific manner for 1099 processing.
Use the Audit File Review program in conjunction with the 1099 Audit Report (P04514R1) and the 1099 G/L Audit Register (P04514R2) to review and update your audit records.
Navigation
From The G/L Method (G04221), choose Audit File Review
Processing Options
Reviewing the 1099 Audit Report
As an alternative to reviewing the audit records online, you can use the 1099 Audit Report (P04514R1). The report prints the Type 1 (voucher expense) and Type 2 (payment) records from the 1099 Audit File (F045144) based on the data selection. JD Edwards World provides two ZJDExxxx versions, each with a different data sequence:
ZJDE0001 - sequence information by document (company/type/number), and then by account number (object/subsidiary).
ZJDE0002 - sequence information by account number (object/subsidiary), and then by document (company/type/number).
The Original Amount column on the report displays the voucher expense amount from the Type 1 record. The Processed Amounts column on the report displays the payment amount for the vouchers.
Sample: 1099 Audit Report
Navigation
From The G/L Method (G04221), choose 1099 Audit Report
Data Selection
JD Edwards World recommends that you not include Calendar Year as part of your data selection because transactions might cross calendar years. Instead, consider using Closed Item EQ *BLANK for the data selection to retrieve the current year transactions.
Reviewing the 1099 G/L Audit Register
As an alternative to reviewing the audit records online, you can use the 1099 G/L Audit Register (P04514R2).
The system includes the Type 3 (payment) and Type 4 (payment adjustment) records from the 1099 Audit File (F045144) on the report based on the data selection. The system uses the same transactions for this report and for the Build the G/L workfile; therefore, you can use this report as a preview of the G/L workfile. For example, you might want to add data selection criteria for a specific account range that correlates to a specific 1099 form and box. You can use this information to verify the current year reportable amounts.
JD Edwards World provides four ZJDExxxx versions, each with a different data sequence of the audit register:
ZJDE0001 - sequences information by address book number, account number (object/subsidiary), and then document (company/type/number).
ZJDE0002 - sequences information by document (company/type/number), and then by account number.
ZJDE0003 - sequences information by company, account number (object/subsidiary), and then document (company/type/number).
ZJDE0004 - sequences information by company, account number (object/subsidiary), address book number, and then document (company/type/number).
Use the Address Number processing option to print either the supplier address book number or the payee address book number on the report. Based on the processing option setting, the system also prints the corresponding tax ID from the Address Book Master file (F0101).
Sample: G/L Register by Supplier Account
Navigation
From The G/L Method (G04221), choose 1099 Audit Register