Use this report to see an overview of your customer's credit history. This report provides aging, customer credit history, and a brief look at the last transactions Receivables recorded for this customer.
Receivables retrieves information from Oracle Credit Management to present the most accurate view of your customer's credit history.
See: Common Report Parameters.
Collector Name: Receivables prints information for collectors between the low and high values you specify. Receivables prints all collectors by default.
Note: This report captures collectors that are assigned at the customer account or site level in the Customers set of pages.
Customer Name: Receivables prints information for customer names between the low value and high value you specify. Receivables prints all customers by default.
Customer Number: Receivables prints information for customer numbers between the low value and high value you specify. Receivables prints all customers by default.
Bucket Name: Enter the bucket set to use for aging. You can enter any bucket set with a bucket set type of Credit Snapshot.
Billing Address: Receivables prints each billing address for this customer.
Phone: Receivables prints your customer's primary telephone number.
Receivables prints your current aging information based on the aging buckets you define in the Aging Buckets and Interest Tiers window whose type is Credit SnapShot. Debit items that have any adjustments whose status is pending are treated as disputed items.
Bucket: Receivables prints the aging periods that you define in the Aging Buckets and Interest Tiers window for these aging buckets.
Amount: Receivables prints the total amount of open invoices, debit memos, and chargebacks for each aging category.
Percent: Receivables prints the percent of total open receivables in each aging bucket.
Adjusted Balance: Receivables calculates and displays the adjusted balance for this customer. This figure represents your customer's outstanding balance minus any unapplied or on-account payments.
Buckets 1-7: Receivables prints the name of your seven aging buckets in this column. You define your aging buckets in the Aging Buckets and Interest Tiers window.
In Collection: The amount of your customer's account that is in collection.
On-Account Cash: The total of this customer's on-account payments.
Outstanding Balance: The total of your customer's open invoices, debit memos, and chargebacks.
Unapplied Cash: The total of this customer's unapplied payments.
This section displays historic information for this customer account. This information includes the amount and date of this customer's Largest Invoice and the Highest Credit Limit assigned to this customer.
This section displays a twelve month rolling history for this customer's account. Each row of this section provides the total amount and/or count for the last twelve months for each of the following indicators.
Sales Gross
Payments
Credits
Late Charges
Amount Written Off
Earned Discounts Taken
Unearned Discounts Taken
NSF/Stop Payments
Average Payment Days
Average Days Late
Number of Late Payments
Number of On Time Payments
The Credit Summary section provides summary information about the customers current credit assignments. These assignments include:
Credit Tolerance
Credit Rating
Risk Code
Credit Hold
Account Status
Standard Terms
Exempt from Dunning
Collector
If your customer uses more than one currency, Receivables prints credit information for each currency. This information includes the currency type and the amount in that currency for each of the following indicators.
Credit Limit
Order Credit Limit
Available Credit
Exceeded Credit Amount
This section displays a summary of each this customer's last transactions types. These transaction types include:
Invoice
Credit Memo
Guarantee
Deposit
Debit Memo
Chargeback
Payment
Adjustment
Write Off
Note: If the system option Require Billing Location for Receipts is set to No, any payments entered for customers without a statement site or who do not have a billing location associated with the receipt will not appear in this report.