Net activity amounts are incorrect on query when fiscal year if hard closed. Totals are doubled in the Net activity column of the query and do not match the Trail balance report or General Ledger report.
1) In GL > Query > Open Account Query 2) Select Criteria Net activity by Project and set the criteria- does not equal $0. Set the date to Specific fiscal periods 7/1/2014-7/31/2014/. Set the Fund to 11. The output is the Account code, Project Id, Account, Department, Project status, Active/Inactive, Account category, Fund. 3) Results:Net Activity shows double the amount that what is listed on the Trail Balance and General Ledger report. Total for account 11-1010-00-000 amount $-628.973.58 4) Run trail balance and totals shows $314,486.79 *Note: This is only happens when the fiscal year is hard close.