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?


Thanks for your feedback! Did this solve your issue?

Comments (optional):


Thanks for your feedback!
We're glad it was helpful but sorry it didn’t solve your issue. If you need assistance, click Chat with Support below.
We’re sorry to hear that. Please tell us why.

 I don't like how this works.

 The answer is confusing.

 The answer didn't match what I was searching for.

Additional Comments (optional):


Thanks for your feedback! If you need assistance, click Chat with Support below.
Thanks for your feedback. Help us make our products even better by sharing details in our Idea Banks or our online Community.
Thanks for letting us know. We'll work on clarifying the information in the article. If you need assistance, click Chat with Support below.
Thanks for letting us know. We'll work on updating the search engine to return more relevant results.