Checked and debugged the query to see more differences to the query in the application versus the query made by sir Ian and to see why it does not have other transactions like return but there are deductions made for the total gross.