This appendix contains the following topics:
Section E.1, "JD Edwards EnterpriseOne Accounts Receivable Reports"
Section E.2, "JD Edwards EnterpriseOne Accounts Receivable Reports: A to Z"
Section E.3, "JD Edwards EnterpriseOne Accounts Receivable Selected Reports"
This section provides overviews for these types of Accounts Receivable reports:
Standard
Analytical
You print standard reports to review and manage open accounts receivable balances and aging information for:
All customers
A specific customer
A specific category code
Multicurrency amounts
When you print these reports, the system reads information from these tables:
Customer Master by Line of Business (F03012).
Customer Ledger (F03B11).
Receipts Header (F03B13).
Receipts Detail (F03B14).
The processing time for these reports depends on the amount of history retained in these tables. You might want to print standard reports during off-peak hours.
You print analytical reports to review and analyze information about:
Totals by customer and pay status.
Collections, such as unresolved matters and accounts that require immediate attention.
Credit limits, such as assigned credit limit exceeded.
Customer trends and statistics, such as high balances and DSO (Days Sales Outstanding).
The JD Edwards EnterpriseOne system offers a variety of analytical reports that can help you analyze the transaction history and paying habits of customers. You can determine the payment trends based on history. For example, you can print a report that shows the number of chargebacks or insufficient funds (NSF) receipts associated with a customer. The analytical reports enable you to identify potential problem accounts before doing further business with a customer.
The processing time for these reports depends on the amount of history retained in their corresponding tables. You might want to print analytical reports during off-peak hours.
This table lists the JD Edwards EnterpriseOne Accounts Receivable reports, sorted alphanumerically by report ID. For more information about a report, refer to the report details at the end of this appendix.
| Report ID and Report Name | Description | Navigation |
|---|---|---|
| R03B155
Open A/R Summary Analysis Report |
Lists the status of customer accounts. | Accounts Receivable Reports (G03B14), Open A/R Summary Analysis |
| R03B165
Statistical Trend Analysis Report |
Prints the trends of a customer within a specific period. | Accounts Receivable Reports (G03B14), Statistical Trend Analysis |
| R03B166
Aging Trend Analysis Report |
Prints customer payment trends over a period. | Accounts Receivable Reports (G03B14), Aging Trend Analysis |
| R03B167
Receipt Trend Analysis Report |
Prints the payment history of a customer within a specific period. | Accounts Receivable Reports (G03B14), Receipt Trend Analysis |
| R03B168
Invoice Trend Analysis Report |
Prints the invoice history of a customer within a specific period. | Accounts Receivable Reports (G03B14), Invoice Trend Analysis |
| R03B1691
Statistical Calculations by Company Report |
Summarizes period information from the A/R Statistical History table (F03B16) by company. | Accounts Receivable Reports (G03B14), Statistical Calculations by Company |
| R03B1692
Statistical Calculations by Credit Manager Report |
Summarizes the period information from the A/R Statistical History table (F03B16) by credit manager. | Accounts Receivable Reports (G03B14), Statistical Calculations by Credit Mgr |
| R03B1693
Statistical Calculations by Collection Manager Report |
Summarizes period information from the A/R Statistical History table (F03B16). | Accounts Receivable Reports (G03B14), Statistical Calculations by Collect Mgr |
| R03B305
Invoice Journal |
Prints invoice journal information. | Customer Invoice Entry (G03B11), Invoice Journal Report |
| R03B311
Receipts Journal Report |
Prints receipt journal information. | Select Receipts Journal Report from one of these menus:
Manual Receipts Processing (G03B12) Automated Receipts Processing (G03B13) Real Estate Receipts (G1513) |
| R03B408
Receipts Deposit Journal |
Prints all payments received and processed as of a specific batch date or range of batch dates by bank account. This report also shows any receipts that are voided or designated as NSF. | Manual Receipts Processing (G03B12), Receipts Deposit Journal |
| R03B413A
Open A/R Detail - Summarized Report |
Prints current summary information about customer accounts. | Accounts Receivable Reports (G03B14), Open A/R Detail - Summarized |
| R03B4201A
Open A/R Detail with Remarks Report |
Prints a list of open items such as invoices, credit memos, and unapplied receipts for every customer. | Accounts Receivable Reports (G03B14), Open A/R Detail with Remarks |
| R03B4201B
Open A/R Detail with Aging Report |
Prints open A/R items for specific aging categories. This report lists totals for each company and a grand total for all companies. | Accounts Receivable Reports (G03B14), Open A/R Detail with Aging |
| R03B450
Receivables/Payables Netting Report |
Prints the potential offsets between open accounts payable balances and open accounts receivable balances. | Accounts Receivable Reports (G03B14), Build Netting Report File |
| R03B461
Collection Report |
Prints a list of outstanding items for customers with past-due accounts. | Accounts Receivable Reports (G03B14), Collection Report |
| R03B466
Netting - Aging Report |
Lists transactions by customer and supplier aged by currency type. | Accounts Receivable Reports (G03B14), Netting - Aging Report |
| R03B560
Receipts Activity Register |
Prints a list of all processed items | Automated Receipts Processing (G03B13), Receipts Activity Register |
| R03B574
NSF Drafts Notification |
Prints the total amount of drafts that have been returned for insufficient funds. | Draft Remittance and Collection (G03B162), NSF Drafts Notification |
| R7404002
Customer / Supplier Balance Report |
Prints the detail of the transactions between the company and customers or suppliers. | Use one of these navigations:
Accounts Payable Reports (G0414), Supplier Balance Report. Accounts Receivable Reports (G03B14), Customer Balance Report. Spanish Reports (G74S09), Customer / Supplier Balance Report. French Reports (G093151), Customer / Supplier Balance Report |
This section provides detailed information, including processing options, for individual reports. These reports are listed alphanumerically by report ID.
This report enables you to review these types of information:
Account balances at the parent or child level.
Open amounts and their associated aging categories.
Customers who have exceeded their standard credit limit at the customer and company level (based on how you set the processing options).
Customers who have exceeded their insured credit limit.
Customers who are under their credit limit.
The customer's currency of open amounts.
Summary information at the company level.
To update the appropriate date information, you must run the Credit Analysis Refresh program (R03B525). When you print the Open A/R Summary Analysis report, the system reads information from the Credit and Cash Management table (F03B15) and the Credit Insurance Table (F03B29).
Processing options enable you to specify the default processing for programs and reports.
These processing options specify how the system displays insured credit limit information on the report.
Specify the amount against which the customer balance is compared to determine whether to print the customer on the report. The system uses the currency specified in the Open Amount processing option for the amount specified in this processing option. The system retrieves the exchange rate to use to restate customer balances from the Currency Exchange Rates table (F0015), and then compares the restated balance with the amount specified in this processing option to determine whether to print the customer on the report. The system prints only customer balances with amounts greater than or equal to the amount specified in this processing option.
Note:
The system prints the customer balances in the currency specified in the A/B Amount Codes field (CRCA) of the customer master record (F03012), not in the currency specified for the Open Amount processing option.Specify the currency of the amount entered in the Open Amount to be Exceeded processing option. The system calculates open amounts based on the currency specified, and then compares the customer's balance with the amount entered in the Open Amount to be Exceeded processing option to determine whether to print the customer on the report.
If you leave this processing option blank, the system uses the currency code USD.
Note:
The system does not print amounts in the currency specified; it uses the currency code only for data selection.Specify which customer records are printed on the report. Values are:
Blank: Print all records.
1: Print records with the open amount greater than or equal to the credit limit that is set up on the customer master record (F03012).
2: Print records with the open amount greater than or equal to the insured credit limit.
Note:
If the Open Amount to be Exceeded processing option contains a value, it overrides this processing option.As part of the customer management and collection activities, print the Statistical Trend Analysis report. This report enables you to analyze the trends of a customer within a specific period. Depending on the data selection, this report shows this statistical information about customers:
Open balance by period.
Number of days sales outstanding (DSO) and delinquent DSO.
Number of days credit is granted.
Weighted average days late.
Non-weighted average days late.
When you print the Statistical Trend Analysis report, the system uses information from these tables:
A/R Statistical History (F03B16)
A/R Statistical Summary (F03B16S)
This report does not have associated processing options.
Before you run this program, run the Statistics History Update program (R03B16A) so that the most up-to-date statistical information prints on the report.
To analyze customer payment trends, print the Aging Trend Analysis report. This report enables you to view customer payment trends over a long period. For example, you can determine whether a customer is becoming more delinquent each year, based on monthly totals over a two-year period.
When you print the Aging Trend Analysis report, the system uses information from these tables:
F03B16
F03B16S
This report does not have associated processing options.
Before you run this program, run the Statistics History Update program (R03B16A) so that the most up-to-date statistical information prints on the report.
To analyze the payment history of a customer within a specific period, print the Receipt Trend Analysis report. Depending on the data selection, this report shows:
Ending date and amount of payments.
Late payments.
Discounts taken, earnable discounts, and unearned discounts.
Number of insufficient payments (NSF receipts and amounts).
Number and amount chargebacks.
When you print the Receipt Trend Analysis report, the system uses information from these tables:
F03B16
F03B16S
This report does not have associated processing options.
Before you run this program, run the Statistics History Update program (R03B16A) so that the most up-to-date statistical information prints on the report.
To analyze the invoice history of a customer within a specific period, print the Invoice Trend Analysis report. Depending on the data selection, this report shows:
Ending date and ending balance.
Gross amount.
Number of invoices.
Sales amount.
Amount of discounts taken and credits entered.
Delinquency fees.
When you print the Invoice Trend Analysis report, the system uses information from these tables:
F03B16
F03B16S
This report does not have associated processing options.
Before you run this program, run the Statistics History Update program (R03B16A) so that the most up-to-date statistical information prints on the report.
The Statistical Calculations by Company report (R03B1691) summarizes period information from the F03B16 table by company. The customer information is at the company level. The system summarizes statistical information for all companies under Company 00000, which you can use to provide statistical information for the organization.
You can use data selection to narrow the selection criteria, but you should not change data sequencing. Because the totals are dependent on the exact sequencing of this report, changing the data sequence could compromise the results.
This report does not have associated processing options.
Before you run this program, run the Statistics History Update program (R03B16A) so that the most up-to-date statistical information prints on the report.
The Statistical Calculations by Credit Manager report (R03B1692) summarizes the period information from the F03B16 table by credit manager. All customer information is provided based on the credit manager and company.
You can use data selection to narrow the selection criteria, but you should not change data sequencing. Because the totals are dependent on the exact sequencing of this report, changing the data sequence could compromise the results.
This report does not have associated processing options.
Before you run this program, run the Statistics History Update program (R03B16A) so that the most up-to-date statistical information prints on the report.
The Statistical Calculations by Collection Manager report (R03B1693) summarizes period information from the F03B16 table. All customer information is provided based on the collection manager and company.
You can use data selection to narrow the selection criteria, but you should not change data sequencing. Because the totals are dependent on the exact sequencing of this report, changing the data sequence could compromise the results.
This report does not have associated processing options.
Before you run this program, run the Statistics History Update program (R03B16A) so that the most up-to-date statistical information prints on the report.
Generally, it is easier to review invoice journal information online. However, if a balancing problem occurs, or if batches are large, you might find the printed invoice journal more useful.
When you print invoice journal information, the system selects transactions from the F03B11 and Account Ledger (F0911) tables.
This report lists messages in the blank area next to the far right column. These messages describe:
Balance discrepancies (if the total gross/discount amount does not equal the G/L distribution).
Intercompany transactions (if the document contains G/L transactions for more than one company).
The batch number, user ID, and batch date are commonly used data selections.
If you create additional versions of this report, you must use the data sequence in this order:
User ID (alphabetical order)
Batch Date
Batch Number (most recent date first)
Document Company
Document Type
Document Number (ascending order)
Pay Item
As an alternative to reviewing receipts online, you can run the Receipts Journal Report (R03B311). You can create different versions to display specific information. For example, you might set up a version of the report that displays specific batches based on a particular date or for a specific user.
When you run the Receipts Journal Report, the system displays a list of the receipts entered for each bank account, and the invoices that each receipt paid, if any. For drafts, the system does not include a bank account number on the header of the report until the draft reaches a contingent liability or collection status. The report prints unposted transactions unless you use data selection to specify a posted code of D.
This report includes information from the Receipts Header table (F03B13) and the Receipts Detail table (F03B14).
The column heading TI represents the receipt type code that the system assigns to the TYIN field in the F03B13 table when you enter a receipt. The system assigns one of these values from UDC 03B/TI:
| Receipt Type Code | Description of Code |
|---|---|
| A | Applied receipt |
| D | Draft |
| G | General ledger receipt |
| L | Logged receipt |
| R | Rounding record |
| U | Unapplied receipt |
The system displays the transactions in this sequence:
User ID
Batch number
Batch date
G/L account
Company
Address number
Payment (receipt) number
Note:
The totals on the report depend on this sequence. If you modify the sequence, you must also modify the program logic that determines how totals are calculated.Processing options enable you to specify the default processing for programs and reports.
These processing options enable you to specify the format that the system uses to print account numbers on the report.
Specify the format to use to print account numbers on the report. The system prints the account number in the detail section of the report for general ledger receipts and drafts only; otherwise, the system prints the document numbers of the invoices paid. If you leave this processing option blank, the system does not print the account number. Values are:
1: Print the account number in the standard format, BU.Obj.Sub (business unit.object.subsidiary).
2: Print the 8-character account ID that the system assigns to the account number in the Account Master table (F0901).
3: Print the account number that you assign to the Free Form (3rd Acct. No.) field in the Account Master table (F0901).
Specify the format to use to print the bank account numbers on the report. The system prints the bank account number in the header section of the report. If you process drafts, the system does not print the bank account number on the report if the draft is at acceptance stage and has not been registered. If you leave this processing option blank, the system does not print the bank account number. Values are:
1: Print the account number in the standard format, BU.Obj.Sub (business unit.object.subsidiary).
2: Print the 8-character account ID that the system assigns to the account number in the Account Master table (F0901).
3: Print the account number that you assign to the Free Form (3rd Acct. No.) field in the Account Master table (F0901).
Regardless of the G/L or receipt date that you use when you enter a receipt, the system always assigns the system date as the batch date. Therefore, if you run this report and do not get expected results, verify that you have correctly entered the range of dates, based on the batch date.
This report prints information from the F03B13 table only.
Processing options enable you to specify the default processing for programs and reports.
These processing options specify the date range to use to select the records to print on the report.
Specify the range of batch dates to select receipt or draft records from the F03B13 table to print on the report. The system includes records with a batch date on or after the date specified. If you leave this processing option blank, the system uses today's date.
To review a list of all processed items, you can print the Receipts Activity Register (R03B560). This enables you to review the unapplied and applied receipt records. The report prints information from the Receipts Header (F03B13) and the Receipts Detail (F03B14) table.
Processing options enable you to specify the default processing for programs and reports.
Specify whether the system prints foreign amounts in addition to domestic amounts on the report. Values are:
Blank: Print only the domestic receipt amounts.
1: Print both the foreign and domestic receipt amounts.
Specify whether the system page breaks on customer or on receipt. Values are:
Blank: Page break on customer.
1: Page break on receipt.
This report has multiple versions to summarize information by:
Company.
Parent.
A/B Category Code 01.
A/B Category Code 01 and Company.
A/R Category Code 01.
A/R Category Code 01 and Company.
Company Totals only.
The totals and aging amounts reflect those transactions that you specify in the data selection for the report.
Processing options enable you to specify the default processing for programs and reports.
Specify whether the system retrieves aging specifications from the A/R constants or from processing options. Values are:
Blank: Use processing options.
1: Use A/R constants.
Specify the date that the system uses to age open balances. If you leave this processing option blank, the system uses today's date.
Specify the date from which the system ages accounts. Values are:
D: Due Date (default)
I: Invoice Date
G: General Ledger Date
S: Statement Date
Specify which aging categories the system uses to assign invoices. The system uses the date specified in the Aging Date processing option and the value specified in the Date Type processing option to calculate the aging for each invoice, and then assigns them to the aging category specified by this code. Values are:
1: Aging days. The system assigns invoices to the aging categories specified in the Aging Category 1 through Aging Category 6 processing options. The aging categories are user defined.
2: Fiscal periods. The system uses the fiscal periods defined by the date pattern assigned to the company record as the aging categories.
3: Calendar. The system uses each calendar month as an aging category.
This processing option specifies the aging specifications.
Specify the aging days that the system uses to age accounts. If you enter a 1 in the Age From Constants processing option, the system ignores this processing option.
This processing option specifies whether the system ages credits.
Specify whether the system ages credits. Values are:
Blank: Credits are not aged. Credits appear in the Current Aging Column.
1: Age credits.
This processing option specifies whether the system prints the parent number on the report.
Specify whether to print the parent number on the report. Values are:
Blank: The parent number does not print the parent number on the report.
1: The parent number prints on the report.
This report includes the remarks that are associated with each pay item. For example, during invoice entry, you might enter a remark to describe the type of service or product in which the customer is being billed. This report shows totals for each company and a grand total for all companies.
You can run versions of this report that include:
Discount information (A/R Details with Discounts, Net Amounts & Remarks).
Retainages (Retainages Receivable).
Receipts history (Customer Receipts History). This version includes both paid and open items for each customer. The information on this report version is similar to the information that you can view online using Customer Receipts Inquiry.
You can run this report so that it lists information as of a specific date, such as the end of the month. To do so, specify the as of date in the appropriate processing option.
Processing options enable you to specify the default processing for programs and reports.
These processing options specify information that the system prints on the report.
Specify whether the report includes receipt information. Values are:
Blank: With the exception of unapplied receipts, the report does not include receipt information.
1: The report includes receipt information.
Specify whether to include receipt amounts in the total that appears on the report. Values are:
Blank: Do not include receipt amounts in the total.
1: Include receipt amounts in the total. If you enter 1, you must additionally set the Print Receipts processing option to 1; otherwise, the system does not include receipts in the total.
Specify the date to use to recalculate and print open invoice amounts on the report. The system compares the date that you enter with the G/L date of the receipt to determine whether the invoice was open or paid as of the date specified. If the G/L date of the receipt is after the as of date entered, the system considers the invoice open and includes it on the report. If the G/L receipt date is on or before the as of date entered, the system considers the invoice closed and does not include it on the report.
For example, suppose you enter an invoice with a G/L date of June 15, 2008 that is paid by a receipt with a G/L date of July 15, 2008. If the as of date is June 30, 2008, the invoice shows as open on the report. This is useful if a customer requests a report for a specific date or for a date other than the date for which the report was originally processed.
If you leave this processing option blank, the system does not perform as of processing.
Note:
To determine whether an invoice was open as of a specific date, do not limit data selection using payment status or open amount. A demo version of the report using the proper data selection for as of processing is available.Caution:
Using the as of date feature can dramatically increase the report's processing time.Specify the currency to use to restate amounts that appear on the report. Enter a valid currency code. The system retrieves the exchange rate from the Currency Exchange Rates table (F0015). If an exchange rate is not set up, the system prints a blank report. If you leave this processing option blank, the report prints amounts in the domestic currency.
You can run this report so that it lists information as of a specific date, such as the end of the month. To do so, specify the as of date in the appropriate processing option.
Processing options enable you to specify the default processing for programs and reports.
These processing options specify how the JD Edwards EnterpriseOne Accounts Receivable system ages customer invoice information.
Specify whether to retrieve the aging specifications from the Accounts Receivable Constants or to use the values specified in the processing options for aging.
Note:
If you enter 1 to retrieve aging specifications from the Accounts Receivable Constants, the system ignores all other aging processing options with the exception of the Aging Date processing option. The system uses the value for the Aging Date processing option only if the Aging as of Date field in the constants is blank. To use the current date in the constants, which you specify by the Age as of Date field blank, do not complete the Aging Date processing option.Specify the date to use to determine the aging category to which to assign open invoices. The system compares the date that you enter to the date on the invoice, as specified by the Date Type processing option, to determine the number of days the invoice is past due.
If you leave this processing option blank, the system uses today's date to age open invoices.
Specify the date on the invoice to use to determine the aging category. The system compares the date that you specify to the value in the Date Calculation processing option to determine the number of days the invoice is past due. Values are:
Blank: Use the invoice due date.
1: Use the invoice date.
2: Use the G/L date.
3: Use the statement date.
Specify which aging categories the system uses to assign invoices. The system uses the date specified in the Aging Date processing option and the value specified in the Date Type processing option to calculate the aging for each invoice, and then assigns them to the aging category specified by this code. Values are:
1: Aging days. The system assigns invoices to the aging categories specified in the Aging Category 1 through Aging Category 6 processing options. The aging categories are user defined.
2: Fiscal periods. The system uses the fiscal periods defined by the date pattern assigned to the company record as the aging categories.
3: Calendar. The system uses each calendar month as an aging category.
Specify the interval that the system uses for the aging category that prints on the report.
Specify whether to age credit memos according to the aging specifications, or to apply credits to the Current aging column that prints on the report.
These processing options specify whether to include receipt amounts on the report and in the total.
Specify whether receipt information prints on the report. Values are:
Blank: The system prints only invoices and unapplied cash information.
1: Print receipts information.
Specify whether receipt amounts print on the report. Values are:
Blank: Only original amounts are totaled in this column.
1: The system includes the receipt amounts in the Original Amount column total on the report.
This processing option is used to invoke the "as of" process feature.
Specify the as of date when you must produce a report as of a specific date. A common mistake is to use this date as the aging date, which dramatically increases report processing time.
When using as of date processing, the system recalculates open invoice amounts as of the date you enter. The system reads the G/L date of the receipt to determine whether the invoice has been paid. If the G/L date of the receipt is after the as of date entered, the system considers the invoice open and includes it on the report. If the G/L receipt date is on or before the as of date entered, the system considers the invoice closed and does not include it on the report.
For example, suppose you enter an invoice with a G/L date of June 15, 2008 that is paid by a receipt with a G/L date of July 10, 2008. If the as of date is June 30, 2008, the invoice shows as open on the report. This is useful if a customer requests a report for a specific date or for a date other than the date that the report was originally processed.
Note:
To determine whether an invoice was open as of a specific date, do not limit data selection using payment status or open amount. There is a demo version provided for this purpose.Specify whether pre-activity receipt amounts print on the report. Values are:
Blank: Normal "as of" processing
1: The system includes all selected invoices for "as of" processing, and any payment activity that is prior to the invoice G/L Date is reflected in the Open Amount column with a sign opposite of the Original Amount.
This processing option is used to restate amounts in another currency.
Specify the currency to use to recalculate amounts. The system does this only if it locates a valid exchange rate in the Currency Exchange Rates table (F0015). For example, if you enter amounts in U.S. dollars, but you want the amounts printed in Canadian dollars, enter CAD in this processing option. The system locates an exchange rate to recalculate the amounts. Leave this processing option blank to use the domestic currency.
These processing options specify how the system displays insured credit limit information on the report.
Specify which customer records are displayed on the report. Enter an amount. Only records with open amounts greater than or equal to this amount are displayed. If you leave this processing option blank, the system displays all insured credit limit records on the report.
Specify the currency code of the amount entered in the Open Amount to be Exceeded processing option. If you leave this processing option blank, the default currency code is USD (US Dollar).
Specify which customer records print on the report. Values are:
Blank: Print all records
1: Print records with the open amount greater than or equal to the credit limit
2: Print records with the open amount greater than or equal to the insured credit limit
A value (other than blank) in the Open Amount to be Exceeded processing option overrides the value that you specify in this processing option.