I am looking to have a report run that will show the sales by date like the ones in the tool, but with an addl column, showing profit (order grand total - item cost of all items in the order )

Anyone create something like this? since the item cost info isnt put into order details, it will need to do a lookup of each P/N to get its cost, sum them together, and then subtract from the grand total.

before i create this, i wanted to see if there is something out there already

thanks

wade