This appendix provides an overview of Accounts Receivable reports and enables you to:
View summary tables of all reports.
View report details for 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. If you need 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 of time. |
Accounts Receivable Reports (G03B14), Statistical Trend Analysis |
R03B166 Aging Trend Analysis Report |
Prints customer payment trends over a period of time. |
Accounts Receivable Reports (G03B14), Aging Trend Analysis |
R03B167 Receipt Trend Analysis Report |
Prints the payment history of a customer within a specific period of time. |
Accounts Receivable Reports (G03B14), Receipt Trend Analysis |
R03B168 Invoice Trend Analysis Report |
Prints the invoice history of a customer within a specific period of time. |
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.
See Also
Updating Accounts Receivable Statistics for Customer Analysis
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.
Insured Credit Limit
These processing options specify how the system displays insured credit limit information on the report.
1. Open Amount to be Exceeded |
Specify the amount against which the customer balance will be 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. |
2. Currency Code of Open Amount |
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. |
3. Standard or Insured Credit Limit |
Specify which customer records will be 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 of time. 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 of time. 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 of time, 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 of time, 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).
Column Headings
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.
1. Account Format - G/L Receipts and Drafts |
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). |
2. Account Format - Bank Account |
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.
Batch Date
These processing options specify the date range to use to select the records to print on the report.
1. From Date and 2. Through Date |
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.
Overrides
1. Display Foreign Amounts |
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. |
2. New Page for Each Receipt |
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.
Aging
1. Age From Constants |
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. |
2. Aging Date |
Specify the date that the system uses to age open balances. If you leave this processing option blank, the system uses today's date. |
3. Date to Age Accounts From |
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 |
4. Aging Method |
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. |
Aging Days
This processing option specifies the aging specifications.
5. Aging Days |
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. |
Age Credits
This processing option specifies whether the system ages credits.
6. Age 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.
7. Print Parent Number |
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.
1. Print Receipts |
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. |
2. Include Receipts in Total |
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. |
3. Date - As of |
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 will show 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. Warning! Using the as of date feature can dramatically increase the report's processing time. |
4. Currency Code -Restatement |
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.
Aging
These processing options specify how the JD Edwards EnterpriseOne Accounts Receivable system ages customer invoice information.
1. Aging Specifications |
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. |
2. Aging Date |
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. |
3. Date Type |
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. |
4. Aging Method |
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. |
5. Aging Category 1 through 10. Aging Category 6 |
Specify the interval that the system uses for the aging category that prints on the report. |
11. Age Credits |
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. |
Receipts
These processing options specify whether to include receipt amounts on the report and in the total.
1. Print Receipts |
Specify whether receipt information prints on the report. Values are: Blank: The system prints only invoices and unapplied cash information. 1: Print receipts information. |
2. Original Total |
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. |
Date
This processing option is used to invoke the "as of" process feature.
1. Date - As Of |
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 will show 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. |
2. Pre-Activity As Of |
Specify whether pre-activity receipt amounts print on the report. Values are: Blank: Normal “as of” processing 1: The system will include all selected invoices for "as of" processing, and any payment activity that is prior to the invoice G/L Date will be reflected in the Open Amount column with a sign opposite of the Original Amount. |
Currency
This processing option is used to restate amounts in another currency.
1. Currency Code - Re-calculated |
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. |
Insured Credit Limit
These processing options specify how the system displays insured credit limit information on the report.
1. Amount Open to be Exceeded |
Specify which customer records are displayed on the report. Enter an amount. Only records with open amounts greater than or equal to this amount will be displayed. If you leave this processing option blank, the system displays all insured credit limit records on the report. |
2. Currency Code of Amount Open |
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). |
3. Standard or Insured Credit Limit |
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. |