I would like to create the following GridView report with listed columns, if possible.

Item #
Item Description
Qty Sold By Period (by location if possible)
Qty Sold YTD (by location if possible)
Qty Sold LY (by location if possible)
Total sell of each item. (ie we sold 12, each priced at 8.00 for a total of 96 dollars)

Thank you.

That report can be developed using the @Z80C Composite Dictionary. The table you want is *SR Trans w SR Description. You will need to use the Date functions in GridView to allocate the Sales by Period. The Taxes and Miscellaneous Charges are not assigned to a location.