I'm trying to build a report for a client to double check the transactions that are going through IC.

What I'm trying to produce is a report that they can run after day end to verify that the numbers in the running total equal the numbers in the location details.

I've attached a sample of what I have in mind here:
http://img33.imageshack.us/img33/4559/iciloc.png

Thanks.