## Appendix: JD Edwards EnterpriseOne Accounts Payable Reports

This appendix provides an overview of accounts payable reports and enables you to:

- View summary tables of all reports.

- View details for selected reports.

Note. Country-specific reports for accounts payables exist for many countries.

See Also

JD Edwards EnterpriseOne Country-Specific Reports for the Americas

JD Edwards EnterpriseOne Country-Specific Reports for Asia and Australia

JD Edwards EnterpriseOne Country-Specific Reports for Europe

### JD Edwards EnterpriseOne Accounts Payable Reports: A to Z

The following table lists the accounts payable reports, sorted alphanumerically by report ID.

You can also generate a report for supplier balances.

See Printing Customer/Supplier Balance Reports.

Report ID and Report Name | Description | Navigation
R00311A Address Book Exception Report | Use this report to view any suppliers in the JD Edwards EnterpriseOne Address Book system that do not have corresponding bank account information (such as bank transit and account numbers) in the Bank Transit Master table (F0030). The system reviews suppliers only if their payment instrument is T or B. This program does not update any information. If any records appear on the exception report, you must perform one of these actions: Enter the missing bank account information using the Bank Account Cross-Reference program (P0030A). Change the payment instrument for the supplier to one that does not require bank account information. | Automatic Payment Setup (G04411), Address Book Exception Report
R04305 Voucher Journal Report | Use this report to review voucher journal information in a printed format, instead of viewing the information online. | Supplier and Voucher Entry (G0411), Voucher Journal Report
R04311 Manual Payment Journal Report | Use this report to review manual payment journal information in a printed format, instead of viewing the information online. | Manual Payment Processing (G0412), Manual Payment Journal Report
R04413 A/P Summary Report | Use this report to review summary information about open voucher balances and aging. | Accounts Payable Reports (G0414), Open A/P Summary Report, A/P Summary Report Period End Processing (G0421), Open A/P Summary Report, A/P Summary Report
R04413C As-Of Open A/P Summary Report | Use this report to review summary information about open voucher balances as of a specific date. | Period End Processing (G0421), Open A/P Summary Report, "As-Of"-Open A/P Summary Report Accounts Payable Reports (G0414), Open A/P Summary Report, "As-Of"-Open A/P Summary Report
R04423A A/P Detail by Supplier with Remarks and Net Amounts | Use this report to review detailed voucher information. This report lists each voucher for a supplier, and includes net amounts, due dates, and remarks. | Accounts Payable Reports (G0414), Open A/P Detail Report, A/P Detail with Remarks Period End Processing (G0421), Open A/P Detail Report, A/P Detail with Remarks
R04423B A/P Details w/Aging | Use this report to review detailed voucher information, along with aging information. | Accounts Payable Reports (G0414), Open A/P Detail Report, A/P Detail with Aging
R04423C "As-Of" A/P Detail by Supplier | Use this report to review detailed AP ledger information as of a specific date. | Period End Processing (G0421), Open A/P Detail Report, "As-Of" A/P Detail with Remarks Accounts Payable Reports (G0414), Open A/P Detail Report, "As-Of" A/P Detail with Remarks
R04423D "As-Of" Open A/P Details with Aging | Use this report to review detailed AP ledger information as of a specific date, with aging. | Period End Processing (G0421), Open A/P Detail Report, "As-Of" Open A/P Details with Aging Accounts Payable Reports (G0414), Open A/P Detail Report, "As-Of" Open A/P Details with Aging
R04424 Payment Details | Use this report to determine which vouchers have been paid. | Accounts Payable Reports (G0414), Payment Details
R04428A A/P Detail by Approver with Remarks | Use this report to view due dates, expense suspense accounts, and open amounts for suppliers. This report lists suppliers by approver number. | Other Voucher Entry Methods (G04111), Voucher Detail Report, A/P Detail by Approver with Remarks
R04428B A/P Detail by Approver with Aging | Use this report to view due dates, expense suspense accounts, open amounts, and aging information for suppliers. This report lists suppliers by approver number. | Other Voucher Entry Methods (G04111), Voucher Detail Report, A/P Detail by Approver with Aging
R04431 Cash Requirements Report | Use this report to determine how much money you need for payments and how much money you have in your bank accounts. You can also use this report to review upcoming cash requirements. | Automatic Payment Processing (G0413), Cash Requirements Report, Cash Requirements Report
R04578 Payment Analysis Report | Use this report to review all payments currently in a payment group. Using the processing options for this report, you can also view the pay items for each payment. | Automatic Payment Processing (G0413), Payment Analysis Report
R04601 Suspected Duplicate Payments | Use this report to identify duplicate payments. | Accounts Payable Reports (G0414), Suspected Duplicate Payments
R04602 Supplier Analysis | Use this report to review a supplier's transaction history. | Accounts Payable Reports (G0414), Supplier Analysis
R09313 Payment Register | Use this report to print an additional copy of a payment register. | Accounts Payable Reports (G0414), Payment Register
R09450 Supplier/Customer Totals by G/L Account | Use this report to review GL account detail information and totals by supplier from the F0911 table. | Accounts Payable Reports (G0414), Supplier/Customer Totals by G/L Acct

Integrity Reports

The following table lists the integrity reports, sorted alphanumerically by report ID.

R047001A A/P to G/L by Offset Account | Use this report to compare posted, open amounts in the F0411 table to the balance in the offsetting AP trade accounts in the F0902 table | Period End Processing (G0421), A/P to G/L by Offset Account
R04701 A/P Orig Doc to G/L by Batch | Use this report to verify that the gross amount of each batch in the F0411 table balance with the amounts in the corresponding batch in the F0911 table. This report also checks each pay item for an invalid pay status. | Period End Processing (G0421), A/P Orig Doc to G/L by Batch
R04702A A/P Payments to G/L by Batch | Use this report to verify that each batch of payment amounts in the F0414 table is in balance with the corresponding batch of amounts in the F0911 table. | Period End Processing (G0421), A/P Payments to G/L by Batch

### JD Edwards EnterpriseOne Accounts Payable Reports: Selected Reports

Some reports include a more detailed description, as well as information about processing options. These reports are listed alphanumerically by report ID in this appendix.

#### R04305 - Voucher Journal Report

Generally, you review voucher journal information online. However, if you need to perform a detailed analysis, a printed journal might provide a more workable format. Printed reports are helpful when you are resolving out-of-balance conditions.

The system calculates the tax amounts that appear on the Voucher Journal Report based on the tax explanation code and tax rate and area for a pay item.

This report lists transactions from the F0411 and F0911 tables. To see value-added tax (VAT) amounts from the F0018 table, set the VAT Receivable Amounts processing option to 1. VAT amounts appear on the report only if the voucher has been posted.

The processing time for this batch process is related to the number of records in your system.

The following table describes the abbreviated columns headings used in this report.

Abbreviated Column Heading | Description
Ty | Document Type
PC | Posted Code
LT | Ledger Type
PS | Payment Status
PI | Payment Instrument

#### Processing Options for Voucher Journal Report (R04305)

Processing options enable you to specify the default processing for programs and reports.

Print Options

Account Number Format | Specify the account number to print. Value are: Blank: Number entered during input 1: Account Number 2: Short Account ID 3: Unstructured Account
VAT Receivable Amounts | Enter 1 to print posted VAT receivable amounts from the F0018 table. If you leave this processing option blank, the system prints tax amounts from only the F0411 table.

#### R04311 - Manual Payment Journal Report

Print the Manual Payment Journal Report to review payments in print instead of reviewing them online. .

If the transactions in a batch have not been posted, the totals by batch indicate that it is not in balance. This is because the system has not yet created the journal entry offsets. If the transactions have been posted and the totals indicate that the batch is not in balance, you need to determine the cause of the problem and correct it.

The processing time for this batch report is related to the amount of history retained in the F0411 table, the Accounts Payable - Matching Document (F0413) table, and the Accounts Payable Matching Document Detail (F0414) table.

#### Data Selection for Manual Payment Journal Report

The DEMO versions of this program print the entire F0413 and F0414 tables. You can limit your selection based on date, user ID, or any other criteria.

The user ID in this program is from the payment record. Therefore, if you limit your selection based on user ID and if the voucher was entered by one user and paid by another, you must select the user ID of the person who paid the voucher.

#### Processing Options for Manual Payment Journal (R04311)

Processing options enable you to specify the default processing for programs and reports.

Do not modify JD Edwards EnterpriseOne demo versions, which are identified by ZJDE or XJDE prefixes. Copy these versions or create new versions to change any values, including the version number, version title, prompting options, security, and processing options.

Print

1. Account Number Format | Specify which account number to print on the Manual Payment Journal report. Blank: Print the number entered during input. 1: Print the account number. 2: Print the short account ID. 3: Print the free form number.

#### R04413 - A/P Summary Report

Use the A/P Summary Report to review summary information about open balances and aging information. This report prints total open amounts for each supplier.

Using the Aging Specifications processing option for this program, you can control the type of date from which to age your vouchers and the aging categories that appear on the report.

If you leave the Aging Specifications processing option blank, the system uses the information that you specify in the remaining Aging processing options, and overrides the aging information in the Accounts Payable constants. You can designate aging by due date, invoice date, or GL date, and by one of these aging methods:

- Aging days

- Fiscal periods

- Calendar

If you enter 1 in the Aging Specifications processing option, the system uses the aging information specified in the Accounts Payable Constants, where you designate the number of days in each time interval for the columns on your aging reports. For example, you can designate 30, 60, 90, and 120 days and more.

This report uses information from the F0101 and F0411 tables.

Processing time for this report depends on the number of transactions retained in the F0101 and F0411 tables. It is recommended that you run this report during off-peak hours.

#### Data Sequence for A/P Summary Report (R04413)

The report totals are dependent on this sequence:

1. Company

2. Address Number

Do not change the data sequence for this report.

#### Processing Options for A/P Summary Report (R04413)

Processing options enable you to specify the default processing for programs and reports.

Aging

If you do not change any of the default settings on this tab, the system retrieves aging specifications from AP constants. If you change the first processing option from the default of 1 to blank, the system retrieves aging specifications from the values that you enter on this tab.

1. Aging Specifications | Enter 1 to retrieve aging specifications from the General Constants table (F0009). Leave this processing option blank to retrieve aging information from the processing options for this program.
2. Aging Date | Specify the date that the system uses to age open balances. The system compares the date in the processing option to the date on the voucher to determine the aging category in which to place each transaction. If you leave this processing option blank, the system compares the current date to the date on the voucher to determine the aging category.
3. Date Type | Specify which date on the voucher that the system uses to age open balances if the Aging Specifications processing option is set to use the aging processing options. The system compares this date to the aging date to determine the aging period in which to place each transaction. Values are: Blank or D: Use the due date to age vouchers. G: Use the GL date to age vouchers. I: Use the invoice date to age vouchers.
4. Aging Method | Specify which aging periods the system uses if the Aging Specifications processing option is set to use the aging processing options. The system ignores these values if the Aging Specifications processing option is set to retrieve aging specifications from the Accounts Payable Constants. Values are: Blank or 1: Aging days 2: Fiscal periods 3: Calendar months
5. Aging Days (Aging Categories 1–5) | Specify the aging intervals in each of the five aging category processing options. The system uses these five processing options to determine the five aging columns on the report. For example, if the aging days specified in these five processing options are 30-, 0, 30, 60, and 90, then the five aging columns of the report will be Current, 1-30, 31-60, 61-90, and Over 90. These processing options apply only if the Aging Specifications and Aging Method processing option are blank.
6. Age Credits | Enter 1 to apply credits to the appropriate aging column. Leave this processing option blank to apply credits to the Current aging column.

Print

1. Hold Payment | Enter 1 to exclude suppliers for which a payment hold is in effect. The hold status of the supplier is specified in the Hold Payment Code field in the F0401 table.

#### R04423A - A/P Detail by Supplier with Remarks and Net Amounts

Use this report to view detailed voucher information for one or more suppliers. This report shows each voucher pay item, net amounts, due dates, and remarks with the open amount information and aging. Print any of these versions:

- Open A/P Detail with Net Amounts & Remarks.

- Open A/P Detail with Remarks.

- Open A/P Detail with Recurring Frequency.

- Supplier Payment Information.

This report uses information from the F0101 and F0411 tables.

Processing time for this report depends on the number of transactions retained in the F0101 and F0411 tables. It is recommended that you run this report during off-peak hours.

#### Data Selection for A/P Detail by Supplier with Remarks and Net Amounts

The Open A/P Detail by Supplier with Remarks and Net Amounts report requires the following data selection:

- Open amount not equal to zero.

- Pay item extension number equal to zero.

Do not remove either of the required data selection for this report. Doing so could cause unpredictable results.

#### Data Sequence for A/P Detail by Supplier with Remarks and Net Amounts

The report totals for the A/P Detail by Supplier with Remarks and Net Amounts are dependent on the following data sequence:

1. Company

2. Address Number

Do not change the data sequence for this report. Doing so could cause unpredictable results.

#### Processing Options for A/P Detail by Supplier with Remarks and Net Amounts (R04423A)

Processing options enable you to specify the default processing for programs and reports.

Print Options

These processing options specify print options on reports.

1. Hold Payment | Enter 1 to exclude suppliers for which a payment hold is in effect. The hold status of the supplier is specified in the Hold Payment Code field (HDPY) of the F0401 table.
2. Recurring Voucher Information | Enter 1 to print recurring voucher information.
3. Remaining Payments | Specify the number of remaining payments to highlight on the report if the recurring voucher information processing option is set to print recurring information. The system prints three asterisks ( ) beside the number of remaining payments for the voucher if the number is less than or equal to the number specified.
4. Payment Information | Enter 1 to print payment information on the report.
5. Include Payment Amounts | Enter 1 to include payment amounts in the column totals for the original amount if the Payment Information processing option is set to print payment information.

#### R04423B - A/P Detail with Aging

To view voucher information for one or more suppliers, print the Open A/P Detail with Aging report. This report shows aging information and due dates with the open amount information. Print one of these versions:

- Open A/P Details with Aging.

- Retainages Payable with Aging.

- Open A/P Details Recurring Frequency with Aging.

This report uses information from the F0101 and F0411 tables. Processing time for this report depends on the number of transactions retained in the F0101 and F0411 tables. It is recommended that you run this report during off-peak hours.

#### Data Selection for A/P Detail with Aging

The Open A/P Detail with Aging report requires the following data selection:

- Open amount not equal to zero.

- Pay item extension number equal to zero.

#### Data Sequence for A/P Detail with Aging

The report totals for the A/P Detail with Aging report are dependent on the following data sequence:

1. Company

2. Address Number

Do not change the data sequence for this report. Doing so could cause unpredictable results.

#### Processing Options for A/P Detail with Aging (R04423B)

Processing options enable you to specify the default processing for programs and reports.

Aging

These processing options specify aging criteria that will be used for this report. If you do not change any of the default settings on this tab, the system retrieves aging specifications from AP constants. If you change the first processing option from the default of 1 to blank, the system retrieves aging specifications from the values that you enter on this tab.

1. Aging Specifications | Enter 1 to retrieve aging specifications from the General Constants table (F0009). Leave this processing option blank to age transactions based on the information set up in the processing options.
2. Aging Date | Specify the date that the system uses to age open balances. The system compares the date in the processing option to the date on the voucher to determine the aging category in which to place each transaction. If you leave this processing option blank, the system compares the current date to the date on the voucher to determine the aging category.
3. Date Type | Specify which date on the voucher the system uses to age open balances if the Aging Specifications processing option is set to use the aging processing options. The system compares this date to the aging date to determine the aging period in which to place each transaction. Values are: Blank or D: Use the due date to age vouchers. G: Use the GL date to age vouchers. I: Use the invoice date to age vouchers.
4. Aging Method | Specify which aging periods the system uses if the Aging Specifications processing option is set to use the aging processing options. If the Aging Specifications processing option is set to retrieve aging specifications from the accounts payable constants, the system ignores the values in this processing option. Values are: Blank or 1: Aging days 2: Fiscal periods 3: Calendar months
5. Aging Days (Aging Categories 1–5) | Specify the aging intervals in each of the five aging category processing options. The system uses these five processing options to determine the five aging columns on the report. For example, if the aging days specified in these five processing options are 30-, 0, 30, 60, and 90, then the five aging columns of the report will be Current, 1-30, 31-60, 61-90, and Over 90. These processing options apply only if the Aging Specifications and Aging Method processing option are blank.
6. Age Credits | Enter 1 to apply credits to the appropriate aging column. Leave this processing option blank to apply credits to the Current aging column.

Print Options

These processing options specify print options for this report.

1. Hold Payment | Enter 1 to exclude suppliers for which a payment hold is in effect. The hold status of the supplier is specified in the Hold Payment Code field in the F0401 table.
2. Recurring Voucher Information | Enter 1 to print recurring voucher information.
3. Remaining Payments | Specify the number of remaining payments to highlight on the report if the recurring voucher information processing option is set to print recurring information. The system prints three asterisks (***) beside the number of remaining payments for the voucher if it is less than or equal to the number specified.
4. Payment Information | Enter 1 to print payment information on the report.
5. Include Payment Amounts | Enter 1 to include payment amounts in the column totals for the original amount if the Payment Information processing option is set to print payment information.

#### R04424 - Payment Details

The Payment Details report shows voucher detail for all payments for a selected supplier. Print this report to determine which vouchers have been paid.

When you print the Payment Details report, the system uses payment header and voucher detail information from the following tables:

- Address Book Master (F0101).

- Accounts Payable - Matching Document (F0413).

- Accounts Payable Matching Document Detail (F0414).

#### Data Sequence for Payment Details

The report totals are dependent on the following sequence:

1. Payee Address Number

2. Payment/Item Number

Do not change the data sequence for this report. Doing so could cause unpredictable results

#### Processing Options for Payment Details (R04424)

Processing options enable you to specify the default processing for programs and reports.

Print Formats

Print Amount Information | Enter 1 to print the report with foreign and domestic amounts of the payment. If you leave this processing option blank, only the payment amount will display.
Print Page Information | Enter 1 to begin a new page with each payment number. If you leave this processing option blank, a new page will begin with each payee.

#### R04428A - A/P Detail by Approver with Remarks

Use this report to view voucher detail information by approver number. This report shows due dates and expense suspense accounts along with the open amount.

This report is similar to the Open A/P Details with Aging Report.

#### Processing Options for A/P Detail by Approver with Remarks (R04428A)

Processing options enable you to specify the default processing for programs and reports.

Print

1. Hold Payment | Enter 1 to exclude suppliers for which a payment hold is in effect. The hold status of the supplier is specified in the Hold Payment Code field in the F0401 table.

#### R04428B - A/P Detail by Approver with Aging

This report prints by approver number and shows due dates and expense suspense accounts along with the open amount. This report is similar to the A/P Detail by Approver with Remarks, but enables you to view aging information.

#### Processing Options for A/P Detail by Approver with Aging (R04428B)

Processing options enable you to specify the default processing for programs and reports.

Aging

1. Aging Specifications | Enter 1 to retrieve aging specifications from the General Constants table (F0009). Leave this processing option blank to age transactions based on the information set up in the processing options.
2. Aging Date | Specify the date that the system uses to age open balances. The system compares the date in the processing option to the date on the voucher to determine the aging category in which to place each transaction. If you leave this processing option blank, the system compares the current date to the date on the voucher to determine the aging category.
3. Date Type | Specify which date on the voucher the system uses to age open balances if the Aging Specifications processing option is set to use the aging processing options. The system compares this date to the aging date to determine the aging period in which to place each transaction. Values are: Blank or D: Use the due date to age vouchers. G: Use the GL date to age vouchers. I: Use the invoice date to age vouchers.
4. Aging Method | Specify which aging periods the system uses if the Aging Specifications processing option is set to use the aging processing options. If the Aging Specifications processing option is set to retrieve aging specifications from the accounts payable constants, the system ignores the values in this processing option. Values are: Blank or 1: Aging days 2: Fiscal periods 3: Calendar months
5. Aging Days (Aging Categories 1–5) | Specify the aging intervals in each of the five aging category processing options. The system uses these five processing options to determine the five aging columns on the report. For example, if the aging days specified in these five processing options are 30-, 0, 30, 60, and 90, then the five aging columns of the report will be Current, 1-30, 31-60, 61-90, and Over 90. These processing options apply only if the Aging Specifications and Aging Method processing option are blank.
6. Age Credits | Enter 1 to apply credits to the appropriate aging column. Leave this processing option blank to apply credits to the Current aging column.

Print

Although processing options are set up during implementation, you can change processing options each time you run a program.

1. Hold Payment | Enter 1 to exclude suppliers for which a payment hold is in effect. The hold status of the supplier is specified in the Hold Payment Code field in the F0401 table.

#### R04578 - Payment Analysis Report

You can print the Payment Analysis report at any time in the automatic payment process to ensure that payments are correct. This report shows whether payments are ready to be written or ready to be updated to the AP ledger. It shows all payments in all payment groups.

#### Processing Options for Payment Analysis Report (R04578)

Processing options enable you to specify the default processing for programs and reports.

Print

1. Detail Voucher Information | Enter 1 to print voucher detail information on the report.
2. Business Unit | Enter 1 to print the business unit on the report. This processing option applies only when you process payment groups by business unit.

#### R04601 - Suspected Duplicate Payments

Prior to payment processing, you might want to identify any duplicate vouchers. To avoid duplicate vouchers, set the AP constants to display either an error message or a warning of a possible duplicate when you enter a voucher.

If the AP constants are not set to allow for editing duplicate supplier invoice numbers when you enter vouchers, print the Suspected Duplicate Payments report.

Information on this report is from the F0411 table. Vouchers appear on this report based on one of the following criteria:

- Duplicate invoice number.

- Duplicate amount within an invoice.

This report does not adjust the status of any vouchers listed.

#### Data Sequence for Suspected Duplicate Payments

The report totals are dependent on the following sequence:

1. Address Number

2. Invoice Number

3. Document Number

4. Document Type

5. Document Company

6. Pay Item

7. Pay Item Extension Number

Do not change the data sequence for this report. Doing so could cause unpredictable results.

#### Processing Options for Suspected Duplicate Payments (R04601)

This report does not have processing options.

#### R04602 - Supplier Analysis

Use this report to review a supplier's transaction activity. This report lists suppliers according to their year-to-date vouchered amount (gross amount less taxes), with the supplier with the highest amount vouchered appearing first. It also shows the amount vouchered the previous year and the value in the Hold Payment field of the Supplier Master record.

To have the Vouchered Year to Date column to list only the current year's activity, you must run the Update YTD Voucher Amounts program (R04820A) as part of your annual close procedures. Suppliers with a year-to-date balance of zero do not appear on this report. Information on this report is from the F0401 table.

See Verifying YTD Voucher Amounts.

#### Data Sequence for Supplier Analysis

The report totals are dependent on the following sequence:

1. Amount Vouchered Year-to-Date.

2. Address Number.

Do not change the data sequence for this report. Doing so could cause unpredictable results.

#### Processing Options for Supplier Analysis (R04602)

Processing options enable you to specify the default processing for programs and reports.

Currency

Currency | Enter the currency in which the system prints the report. If you leave this processing option blank, the system prints the report in U.S. dollars (USD). The system uses this option only when multicurrency is on.

#### R09313 - Payment Register

For audit purposes, you might need an additional copy of a payment register. The Payment Register report is similar to the register that prints during automatic payment processing. However, the payment information on this register is summarized instead of detailed. This register also lists multi-stub payments and payments that were voided due to a reset.

#### Data Sequence for Payment Register

The report totals are dependent on the following sequence:

1. Batch Number

2. Check Date

3. Document Type

4. Document Number

5. Document Company

6. Address Number

Do not change the data sequence for this report. Doing so could cause unpredictable results.

#### Processing Options for Payment Register (R09313)

This report does not have processing options.

#### R09450 - Supplier/Customer Totals by G/L Account

To analyze which suppliers provide specific types of services and products based on GL distributions, print the Supplier/Customer Totals by Account report. This shows GL account detail information and totals by supplier from the F0911 table.

#### Processing Options for Supplier/Customer Totals by G/L Account (R09450)

Processing options enable you to specify the default processing for programs and reports.

Display

1. Type Of Account Number To Print | Enter the type of Account Number to print on the report. Values are: Blank: Number entered during input. 1: Structured Account. 2: Short Account ID. 3: Third Account Number.
2. Print Supplier/Customer Address | Enter 1 to print the address of the supplier or customer. If you leave this processing option blank, the system does not print the supplier or customer address.