This appendix contains the following topics:
Section C.1, "JD Edwards EnterpriseOne Accounts Payable Reports: A to Z"
Section C.2, "JD Edwards EnterpriseOne Accounts Payable Reports: Selected Reports"
|
Note: Country-specific reports for accounts payables exist for many countries. |
The following table lists the accounts payable reports, sorted alphanumerically by report ID.
You can also generate a report for supplier balances.
| 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 |
The following table lists the integrity reports, sorted alphanumerically by report ID.
| Report | Description | Navigation |
|---|---|---|
| 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 and information about processing options. These reports are listed alphanumerically by report ID in this appendix.
Generally, you review voucher journal information online. However, to perform a detailed analysis, a printed journal provides 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.
Specify the account number to print. Value are:
Blank: Number entered during input
1: Account Number
2: Short Account ID
3: Unstructured Account
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 must 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.
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.
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.
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.
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.
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.
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
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.
Enter 1 to apply credits to the appropriate aging column. Leave this processing option blank to apply credits to the Current aging column.
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.
These processing options specify print options on reports.
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.
Enter 1 to print recurring voucher information.
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.
Enter 1 to print payment information on the report.
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.
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.
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.
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.
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.
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
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.
Enter 1 to apply credits to the appropriate aging column. Leave this processing option blank to apply credits to the Current aging column.
These processing options specify print options for this report.
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.
Enter 1 to print recurring voucher information.
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.
Enter 1 to print payment information on the report.
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.
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.
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.
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.
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.
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.
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.
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
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.
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.
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.
The Update Payment Instrument program (R04830) updates the payment instrument on open vouchers. The Update Payment Instrument Format program selects all the vouchers with payment instrument value set to @ in the processing option of the Update Payment Instrument Format program and updates the vouchers that have an open amount that is not equal to zero.
Processing options enable you to specify the default processing for programs and reports.
Specify a value from UDC table 00/PY to enter the payment instrument for the voucher. The system uses this value to update the payment instrument of the voucher in the Accounts Payable Ledger (F0411).
If you leave this field blank, the system updates the payment instrument for the voucher with a blank value in Accounts Payable Ledger (F0411).
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.
Enter 1 to print voucher detail information on the report.
Enter 1 to print the business unit on the report. This processing option applies only when you process payment groups by business unit.
Before 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 gross amount based on the Update YTD Voucher Amounts program (R04820A), with the supplier with the highest amount 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 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.
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.
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.
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.
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.