Accounts Receivable Report (transactions and receipts)

Summary

Need ad-hoc AR report identifying customer billing and receivable transactions (including accounting information)

Content

Boise State has a requirement to provide campus end-users with a report  that will allow them to search for an Accounts Receivable customer and have all their billing and receivable transactions (including accounting information) displayed.    The requirement is to allow the end-user to enter a customer number, a customer account description, an accounting segment and/or an accounting date range.    

Has anyone had similar requirement and developed a report or SQL that we could model?