Hi Lance

That table will work. But it's not an easy table to work with. For one thing, credit notes appear as positives unless you turn them around using a formula. For another, orders are in there and you want to exclude them if it's a sales report.

What's wrong with using the OE History Header table - it doesn't have the item details but it certainly has the total sales? And if you want the details, what's wrong with using the History button, Items tab in OrderEntry itself?

You are almost definitely doing something wrong in building the GridView but figuring that out on the forum will not be easy. If you are determined to use that table, select all fields and see which one(s) result in the desired output. Then pare it down.

Steve