Skip Headers
JD Edwards World Accounts Receivable Guide
Release A9.3

E21489-02
Go to Documentation Home
Home
Go to Book List
Book List
Go to Table of Contents
Contents
Go to Index
Index
Go to Feedback page
Contact Us

Go to previous page
Previous
Go to next page
Next
PDF · Mobi · ePub

47 Print Analytical Reports

This chapter contains these topics:

To review and analyze information about your customer's accounts, print analytical reports.

The processing time for these reports depends on the amount of history retained in the Customer Master (F0301) and A/R Ledger (F0311) tables. Print analytical reports during off-peak hours.

Navigation

From Accounts Receivable (G03), choose Accounts Receivable Reports

From Accounts Receivable Reports (G0341), choose an analytical report

47.1 Printing the Summary by Pay Status Report

To review a summarized total of open amounts by customer and pay status, print the Summary by Pay Status report. Examples of pay status include:

Figure 47-1 Receivable Summary by Pay Status report

Description of Figure 47-1 follows
Description of "Figure 47-1 Receivable Summary by Pay Status report"

47.2 Printing the Summary by Parent/Child Report

To review a multi-level management summary of A/R with both parent (national) and child (subsidiary) account totals, print the Summary by Parent/Child report.

This report can list up to 25 levels of parent-to-child relationships.

Figure 47-2 Open A/R Summary by Parent report

Description of Figure 47-2 follows
Description of "Figure 47-2 Open A/R Summary by Parent report"

47.3 Printing the Open A/R by Business Unit and Address Report

To review open A/R detail by customer within a business unit, print the Open A/R by Business Unit and Address report. The totals are at the business unit and customer levels. You can print this report using information from the As of Ledger table (F0311A) to list A/R information as of a specific date.

Figure 47-3 Open A/R by Business Unit and Address report

Description of Figure 47-3 follows
Description of "Figure 47-3 Open A/R by Business Unit and Address report"

47.3.2 Data Selection and Sequence for Open A/R by Business Unit

The following data selections are mandatory:

  • Payment/Item Document Type = NE (not equal to) RE (change in invoice gross amount)

  • Type Input = NE G

  • Pay Status = NE *Value

  • Open Amount = NE * Value

All other data selections are optional.

Business unit and parent must appear first in the data sequence. After these two criteria, you can add other sequencing and totaling lines. To print a new page for each business unit, set the Page Break field for each business unit accordingly.

47.4 Printing Additional Credit and Collections Reports

To assist you in managing your credit and collections activities for your customer accounts, you can print various credit and collections reports.

This task consists of:

All of these reports are versions of the Open A/R Detail report.

47.4.1 Printing the Customer Receipts History Report

To review both paid and open items for each customer, print the Customer Receipts History report. The information on this report is similar to the information you can view on Customer Ledger Inquiry.

Figure 47-4 Customer Receipts History report

Description of Figure 47-4 follows
Description of "Figure 47-4 Customer Receipts History report"

47.4.2 Processing Options

See Section 104.7, "A/R Detail Report (P034201)."

47.4.3 Data Selection for the Customer Receipts History Report

You can change the data selection. For example:

  • To exclude audit trails for amounts changed in posted invoices, set the Payment/Item Document Type field to N (not equal) RE

  • To exclude general ledger receipts, set the Type Input field to NE (not equal) G (general ledger)

The following data selections are mandatory:

  • Payment/Item Document Type = NE RE

  • Type Input = NE G

47.4.4 Printing the Disputed Items (Outstanding Chargebacks) Report

To review unpaid chargeback invoices, print the Disputed Items (Outstanding Chargebacks) report. This report lists the chargeback invoices you created on Receipts Entry to rebill customers for the open amount on partially paid or disputed items.

For example, a chargeback might be for freight charges or disallowed discounts.

Figure 47-5 Outstanding Chargebacks report

Description of Figure 47-5 follows
Description of "Figure 47-5 Outstanding Chargebacks report"

47.4.5 Printing the Unresolved Matters Report

To determine the problems that need to be resolved with your customer accounts, print the Unresolved Matters report. This report lists problem invoices and unusual conditions, such as:

  • Unapplied receipts

  • Unapplied credit memos

  • Chargeback invoices

  • Partially paid balances

The Unresolved Matters report reads information from the A/R Ledger table. Printing this report does not adjust the status of any item.

Figure 47-6 Unresolved Matters report

Description of Figure 47-6 follows
Description of "Figure 47-6 Unresolved Matters report"

47.4.7 Data Selection and Sequence for the Unresolved Matters Report

The data sequence for this report is mandatory. The totals are dependent on this exact sequence. If you modify the sequence, you must also modify the totaling logic of the program.

47.4.8 Printing the Receivables/Payables Netting Report

If you have an address book record for an organization that is both a customer and a supplier, print the Receivables/Payables Netting report. This report lists whether a company owes or is owed money.

This report reads information from the A/R Ledger (F0311) and A/P Ledger (F0411) tables. Printing the Receivables/Payables Netting report does not adjust any items. It only lists unusual conditions, such as:

  • The A/R balance is a credit.

  • The A/P balance is a debit.

  • The customer/supplier has both A/R and A/P balances.

When you print this report, the system does the following in sequential order:

  1. Totals the open A/R and open A/P balances for each account.

  2. Compares the two sums.

  3. Lists the potential offsets in the corresponding column on the report. For example, an account with an open A/R balance of 50,000 and an open A/P balance of 30,000 has a potential offset of 20,000. If the opposite is true, it lists the potential offset.

  4. Nets the two offset fields and lists the grand total in the appropriate column, after calculating the potential offset for each address book number.

Use A/R or A/P Netting to reclassify open receivables to the Accounts Payable system or to reclassify open payables to open Accounts Receivable system. Alternatively, use the Credit Note Reimbursement program to reclassify a credit memo or an unapplied receipt to an open voucher in the Accounts Payable system.

47.4.9 Before You Begin

  • Verify that the Address Number Logical table (F03450) exists in your library. Unlike other reports, the Receivables/Payables Netting report will not create the table if it does not already exist.

Figure 47-7 A/R to A/P Netting report

Description of Figure 47-7 follows
Description of "Figure 47-7 A/R to A/P Netting report"

47.4.10 Data Selection and Sequence for Receivables/Payables Netting

Each data selection field should be equal to *ALL so that the report includes all data and gives a complete picture of potential netting.

This report is sequenced by address number and company. You should not change this sequence.

47.4.11 Printing the Problem Accounts Receivable Report

To review a list of your customer accounts in need of attention, print the Problem Accounts Receivable report. This report lists a specified number of problem accounts, such as the account with the oldest and largest open amount.

When you print the Problem Accounts Receivable report, the system creates a worktable in order to rank the accounts. The system ranks customers first by the largest amount due and then by the greatest number of days overdue.

Figure 47-8 Problem Accounts Receivable report

Description of Figure 47-8 follows
Description of "Figure 47-8 Problem Accounts Receivable report"

47.4.13 Data Sequence for the Problem Accounts Receivable Report

The data sequence for this report is mandatory. The totals are dependent on this exact sequence. If you modify the sequence, you must also modify the totaling logic of the program.

47.5 Printing the Customer Totals by G/L Account Report

To review a list of all G/L account totals for a customer, print the Customer Totals by G/L Account report. This report selects and prints information from the Account Ledger table (F0911) and lists totals associated with each customer.

Figure 47-9 Customer Totals by G/L Account report

Description of Figure 47-9 follows
Description of "Figure 47-9 Customer Totals by G/L Account report"

47.5.2 Data Sequence for the Customer Totals by G/L Account Report

If you specify customer totals based on the AA ledger, the totaling sequence is address number, account ID, business unit, and company. If you specify customer totals based on the CA ledger, the totaling sequence is address number, currency code, and account ID.