- modify the application to add the filter CSDSTS = 'A' in the transaction count report to tally the total of transaction count report with the per location sales report, for the solution in the concern why there is a discount in an item but has 0 qty sold
- an error is encountered when test the application, fix the encountered error to successfully generate the report
- Add a total to SOLD_QTY,  GROSS_AMOUNT, TOTAL_DISCOUNT, AND NET AMOUNT for the user to easily see the total of each column
- test the modified application, as per checking, it is now OK and the data extracted is tally with the per location sales report
- send the exe to Arvin for checking on his side