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.

The report is doable using Adagio (Crystal) reports, but really unnecessary as you are going to use the same data to produce this report using that Adagio uses to produce it's report.

Have you looked at the Stock Card report to answer some of these questions? Alternatively, you could dump the transactions for the item from History.