add sum table to report and reconcile pages and edit query transactiontype