How to Find Outstanding Credits for Refund

Owned by Knowledge Assistant
Nov 21, 2023
1 min read
Description of Issue

Need an effective way of searching for outstanding credit amounts to refund to the customer.

Context

  • General Billing

  • Payments Report

  • Refunds

  • AR Customers

Cause

Instructional

Resolution

The Payments Report program can be used to easily find outstanding credits. Follow these steps to do so:

  1. Navigate to Enterprise ERP > General Revenues > Accounts Receivable > Inquiries and Reports > Payments Report.

  2. Click Define on the toolbar, and fill out the criteria as desired.

  3. Make sure to set the Category Range to 01 (General Billing), and set the Principal Balance Range as a large negative value through -.01 so it targets only credit amounts.

  4. In the Receipt Detail Report section, check the box for Print receipt detail. 

  5. Click Select on the toolbar to get your findset.

  6. Choose one of the Output options. The resulting report will display receipt information, including the bill number that has a credit balance. 

  7. Use these bill numbers to process Refunds in the Bill Refund Processing program, making sure to check the box for Create an AP batch.

Additional Information

To get to the Bill Refund Processing program, navigate to Enterprise ERP > General Revenues > Payment Processing > Bill Refund Processing.