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
The following table lists the accounts payable reports, sorted alphanumerically by report ID.
Report ID and Report Name |
Description |
Navigation |
R00311A |
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:
|
Automatic Payment Setup (G04411), Address Book Exception Report |
R04305 |
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 |
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 |
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 |
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 |
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 |
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 |
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 |
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 |
Use this report to determine which vouchers have been paid. |
Accounts Payable Reports (G0414), Payment Details |
R04428A |
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 |
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 |
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 |
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 |
Use this report to identify duplicate payments. |
Accounts Payable Reports (G0414), Suspected Duplicate Payments |
R04602 |
Use this report to review a supplier's transaction history. |
Accounts Payable Reports (G0414), Supplier Analysis |
R09313 |
Use this report to print an additional copy of a payment register. |
Accounts Payable Reports (G0414), Payment Register |
R09450 |
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 |
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 |
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 |
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 |
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.
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 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. |
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.
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 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.
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. |
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.
The report totals are dependent on this sequence:
Company
Address Number
Do not change the data sequence for this report.
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. |
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. |
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.
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.
The report totals for the A/P Detail by Supplier with Remarks and Net Amounts are dependent on the following data sequence:
Company
Address Number
Do not change the data sequence for this report. Doing so could cause unpredictable results.
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. |
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.
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.
The report totals for the A/P Detail with Aging report are dependent on the following data sequence:
Company
Address Number
Do not change the data sequence for this report. Doing so could cause unpredictable results.
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. |
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).
The report totals are dependent on the following sequence:
Payee Address Number
Payment/Item Number
Do not change the data sequence for this report. Doing so could cause unpredictable results
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. |
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 enable you to specify the default processing for programs and 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 in the F0401 table. |
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 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. |
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. |
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 enable you to specify the default processing for programs and reports.
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. |
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.
The report totals are dependent on the following sequence:
Address Number
Invoice Number
Document Number
Document Type
Document Company
Pay Item
Pay Item Extension Number
Do not change the data sequence for this report. Doing so could cause unpredictable results.
This report does not have processing options.
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.
The report totals are dependent on the following sequence:
Amount Vouchered Year-to-Date.
Address Number.
Do not change the data sequence for this report. Doing so could cause unpredictable results.
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. |
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.
The report totals are dependent on the following sequence:
Batch Number
Check Date
Document Type
Document Number
Document Company
Address Number
Do not change the data sequence for this report. Doing so could cause unpredictable results.
This report does not have processing options.
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 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. |