Net activity amounts are incorrect on query when fiscal year if hard closed.

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.
This issue has been resolved in The Financial Edge version 7.87 patch 23.  If your database is not hosted by Blackbaud please download and install the latest patch: How to install a patch (includes video demo)
  case_13458059_fundrequirements.png

Steps to Duplicate

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. 

Environment

 Financial Edge
 7.87

Was this article helpful?