Hello All
This is so nice to be able to put out a request for help.
So I am looking for a report that will show all client records that have a balancing owing on them. I found the "On Account" report, but that is not what I am looking for. I am looking for a report that will show that we bought in something but no payment has been applied to it and or/ a part payment has been made and still has a balance.
I have tried looking for something, and I am sure that there must be something out there, but being so new to this system, i just cant seem to find one.
Thanks
Debbie, Accounting Manager
Hi Debbie,
If you are looking for ticket orders with an outstanding balance you can use either the report called Single Sale Order Listing or the Order Search screen.
The Single Sale Order Listing report is in the Ticketing Box Office Reports folder and allows options for finding those ticket orders where money is still due. You begin by identifying a date range for the performances and also a date range for when the orders were made. You can then choose to view the orders that are paid or not. In fact it also has options for finding those orders where tickets have been seated or not and tickets that have been printed or not.
You can also use Order Search to find unpaid orders. Click here to open the documentation. It is a ridiculously powerful function.
If you are looking for package ticket orders with an outstanding balance there is a report called Package Order Listing. It is in the Ticketing Subscription Reports folder and works much like the Single Sale Order Listing but looks at packages instead of single tickets.
If you are looking for contribution pledges with an outstanding balance look in the Finance folder for two different reports. One called Pledge Balance Detail and the other called Pledge Gift. Try them both to find out which one better suits your needs.
Good luck!
Jared