@mvelazquez
A little basic feedback... as I am far from an SQL Wiz ;-)
I have just tried your select statement on our local database, however the SubTotal and Total results returned are identical, so SubTotal is showing the Gross Sales before Discount figure, and Total is showing the same.
Also the RVC is incorrect, in the example extracted below, sales should show within RVC#5 which is one of our Bars, not #6 which is our Function Suite.
For example:
Obj_Num,Name,RVC_ID,RVC,Quantity,SubTotal,TAX,Total
112036,'Chicken Sandwich',6,'Function Suite',104,322.40,54.04,322.40
Thanks to all that are investigating this, as it would be hndy for many sites to have up their sleeve should tax investigation be required.