We need a simple way to query a report for on hold accounts and their outstanding payment amounts. I thought I could use some of the data provide from the AR Customer Inquiry table, but I can't seem to find what that table is called?
We need - Customer number / Customer name / On Hold / Inactive / Due date / Balance Due (not necessarily in this order).
Any ideas as to how to accomplish this or feedback on which tables to use to join would be great!
Thanks in advance!