Ending Balances on Query do not match Ending Balances on Project Record

Ending Balances on Project Query does not match Ending Balances on Activity tab of Project Record when filtering query by account category.  

To view balance information for Revenue and Expense in a Query, choose the output of Summary > Net Activity, rather than Ending Balance.  Ending Balance information in a query should be used for Balance Sheet accounts, while Net Activity should be used for Income Statement accounts.

Steps to Duplicate

1) In GL > Query > Open Project Query 
2) Select Output: Ending Balance 1 : Category equals Revenue  
and Ending Balance 2: Category equals Revenue 
3) Results: Revenue shows 3,000 and Expense shows 3,000 
4) Open Project Record > Activity > Note Revenue shows 1,500 and Expense shows 3,000
*Note: When you drill down on the activity for Revenue total shows 1,500  

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.