Bad Debt Recovery Report

Introduction

Purpose of Report

The Bad Debt Recovery report is designed to provide Accounts Receivable users with the ability to view all invoices that have been written off to bad debt and subsequently paid. Users can view the original invoice amount, the amount written off to bad debt, the date of the write off, and any payment subsequent to write off as long as that payment was deposited in the AR lockbox.

Intended Audience

The intended audience includes anyone with responsibility for tracking, analyzing, and managing AR invoices.

Parameters Screen

Note:

Enter single values or a limited number of values to fields on the Parameters screen to improve system performance and obtain results more quickly.

In This Field

Enter

Request Description (optional)

A freeform description of the report. This will display in the View Requests form.

Note: System defaults to Blank.

Tub (optional)

Tub value(s) using dashes and/or commas for continuous and noncontinuous ranges, respectively

Note: System defaults to all tubs.

Org (optional)

Org value(s) using dashes and/or commas for continuous and noncontinuous ranges, respectively

Note: System defaults to all orgs.

Customer Name (Low / High) (optional)

Pick a customer name from the list of values, or enter a partial name to get a reduced list of values to select from. The default is "All."

Customer Number (Low / High) (optional)

Pick a customer number from the list of values, or enter a partial number to get a reduced list of values to select from. The default is "All."
Customer Site

Pick a customer site from the list of values, or enter a partial name to get a reduced list of values to select from.

Date of Bad Debt: Low

The start date of Credit Memos written off to Bad Debt.

Date of Bad Debt: High

The end date of Credit Memos written off to Bad Debt.

Bad Debt Recovery Start Date (required)

The start date for which the Debit Memo recoveries are to be returned in standard Oracle format (DD-MON-YY). The default is last closed period.

Bad Debt Recovery End Date (required)

The end date for which the Debit Memo recoveries are to be returned in standard Oracle format (DD-MON-YY). The default is last closed period.

Primary Sort / Subtotal (optional)

Variable by which you want the report sorted and subtotaled

Note: Select from the following list: Tub, Org, Customer Name, Customer Number, Site, Recovery Amount, Recovery Date, Recovery Debit Memo Number, Bad Debt Credit Memo Number, Original Invoice Number, Original Invoice Date.

Secondary Sort / Subtotal (optional)

Variable by which you want the report sorted and subtotaled

Note: Select from the following list: Tub, Org, Customer Name, Customer Number, Site, Recovery Amount, Recovery Date, Recovery Debit Memo Number, Bad Debt Credit Memo Number, Original Invoice Number, Original Invoice Date.

Tertiary Sort (optional)

Variable by which you want the report sorted and subtotaled

Note: Select from the following list: Tub, Org, Customer Name, Customer Number, Site, Recovery Amount, Recovery Date, Recovery Debit Memo Number, Bad Debt Credit Memo Number, Original Invoice Number, Original Invoice Date.

Show Parameters?

Select Yes or No to print an initial page that displays the selected parameters.


Report Heading

The report heading should follow the standard report headers for all reports. See the layout for what to include.

All parameter information is displayed on the parameter page.


Interpret Report Output

Below is a description of what information should be in each of the columns. These are the column headers.

Use commas to separate thousands. Display negative values using parantheses ( ). Display all numbers with the cents.

Column Name

Contains

Tub

The tub value from the recovery debit memo distribution line is printed in this column.

Org

The org value from the recovery debit memo distribution line is printed in this column.

Customer Number

The customer account numbers are printed in this column.

Customer Name

The customer name is printed in this column.

Customer Site

The customer site from the original invoice is printed in this column.
Recovery Date The date that the Recovery Debit Memo was recorded is printed in this column.
Debit Memo Number

The number of the Recovery Debit Memo is printed in this column. This column should show only those Debit Memos where the originating Credit Memo has a Reason code of "Bad Debt Write Off."

Note: The Debit Memo (Recovery) Number will always be the original invoice number with the letter R as the tail.

Amount Recovered The total amount recovered after the original invoice was written off to Bad Debt is printed in this column.

Invoice Number

Invoice numbers are printed in this column.

Invoice Date The date of the invoice is printed in this column in standard Oracle format (DD-MON-YY).

Invoice Amount

The original invoice amount is printed in this column.

Credit Memo Number

The number of the Bad Debt Credit Memo appears here.

Credit Memo Date

The date that the invoice was written off to Bad Debt (Credit Memo) is printed in this column.

Footer

The following items should be on the same line.

Security View: XXXX

Print the name of the security level or view of the user who printed the report; left aligned.