Export a list of Customer payments to Excel
Description of Issue
- How can a full list of Customer payments be exported to Excel?
- Would like to see every payment made by a Customer in Excel.Â
Context
- Accounts ReceivableÂ
- Customers (arcstmnt)
- PaymentsÂ
- Receipt Inquiry (arrecinq)
- Excel
Cause
A list of a Customer's payments is needed in Excel.Â
Resolution
- Navigate to the Receipt Inquiry program either by searching or via the following path:Â General or Property Revenues > Accounts Receivable > Inquiries and Reports > Receipt InquiryÂ
- Click Search.Â
- Enter the Customer's Number in the Customer No. field.Â
- More criteria can be used to narrow the find if needed, but searching by Customer Number will return every receipt associated with that Customer Number.Â
- Click Accept.Â
- Click Excel.Â
Additional Information
If additional assistance is required, please contact the appropriate Accounts Receivable Support Team: How to determine the correct Accounts Receivable support team to assist with an issue