I have a SQL script (not a CR report) that does this and breaks down
information based on billing groups and has some totals at the end (also
split into various billing groups) if you're interested. It doesn't
contain any information regarding check numbers though. That should be a
piece of cake to add to the output if you're tracking it somehow. We're
using Emerald 2.1.11 (SQL 6.5), so we have no easy way of dealing with
I have another script that's nearly identical to the above-mentioned one
that displays all payment info for a given month.
The daily-payment list takes only a second or two to run, but the monthly
one beats the daylights out of the server for a couple minutes.
When I upgrade my CR to 5.0 (or 6.0?) I guess I'll be able to create a
report that queries the user to enter in dates, etc...
Let me know if you want me to send you the script.