This chapter contains these topics:
Section 50.3, "Printing the Open A/R by Business Unit and Address Report"
Section 50.4, "Printing Additional Credit and Collections Reports"
Section 50.5, "Printing the Customer Totals by G/L Account Report"
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.
From Accounts Receivable (G03), choose Accounts Receivable Reports
From Accounts Receivable Reports (G0341), choose an analytical 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:
A (Approved for payment)
H (Hold pending approval)
P (Paid)
R (Retainage)
Figure 50-1 Receivable Summary by Pay Status report
See Section 107.4, "Receivable Summary by Pay Status (P03416)" for more information.
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 50-2 Open A/R Summary by Parent report
See Section 107.5, "Multi-Level Open A/R Summary by Parent (P03415)" for more information.
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 50-3 Open A/R by Business Unit and Address report
See Section 107.6, "Open A/R by Business Unit and Address (P03445)" for more information.
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.
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:
Printing the Customer Receipts History report
Printing the Disputed Items (Outstanding Chargebacks) report
Printing the Unresolved Matters report
Printing the Receivables/Payables Netting report
Printing the Problem Accounts Receivable report
All of these reports are versions of the Open A/R Detail 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 50-4 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
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 50-5 Outstanding Chargebacks 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.
See Section 107.8, "A/R Unresolved Matters (P03601)" for more information.
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.
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:
Totals the open A/R and open A/P balances for each account.
Compares the two sums.
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.
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.
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.
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.
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 50-8 Problem Accounts Receivable report
See Section 107.9, "Problem Accounts Receivable (P036001)" for more information.
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 50-9 Customer Totals by G/L Account report
See Section 107.10, "Customer Totals by G/L Account (P09450)" for more information.
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.