...
The Consolidated Sales Report has different summaries with the report. The first summary is broken down by categories then by UPC's. It reflects the Unit cost which is how much the buisness spent on the item to retail price which is how much the business is selling it for. This also includes Tax[inc] where tax is specific to certain items and pre set and Tax[exc] where is shows the tax that is for each store. At the end of this summary it will show all totals that has no royalty add in. Users can use this report to find out the item sales drivers in their business.
Price Level Summary is reflecting pricing at the transaction level where the user can have the total at full price or their discounts added in ie: Holiday discount, new customer discount. User can use this too see how much these discounts are affecting their sales.
Last summary it the Sub-cat summary where you can see which category is driving sales. Each category is then broken down and you can see the quantity sold, Extended cost, Retail sales, Tax[inc], Tax[exc] and net sales.item to retail price which is how much the business is selling it for. This also includes Tax[inc] where tax is specific to certain items and pre set and Tax[exc] where is shows the tax that is for each store. At the end of this summary it will show all totals that has no royalty add in. Users can use this report to find out the item sales drivers in their business.
Note
Unit cost can be found in postrasactionitemdetail table
...