Accountability Summary does not subtract reversals from total expenses

When using the Accountability Summary in The Raiser's Edge, expenses that have been reversed and posted in Journal Entry are not removed from the Expenses in the report.  They are only removed from the Expenses if they are added through an Invoice and the Invoice is reversed by being deleted and the reversal is posted. 

We are currently evaluating this issue and will update this article when we have more information.

Steps to Duplicate

1. In FE, create an account attribute with a Table data
2. In the Table Name column, select [Add New Table] and enter a table name for the attribute (Functional Expense)
3. Add entries to the table created for the new attribute (i.e. food, salaries, supplies, etc.)
4. Globally Add the account attribute to GL accounts and select any description
5. In RE, set up integration between RE and FE in Config>General Ledger
6. Under Accountability Options, select Account Attribute setup in FE for Accountability options
7. Check the boxes to Show Budgeted Distribution and select a Budget Scenario from the drop down (Administration)
8. Check the box to Include Loss Accounts and Include Transfer Accounts
9. Set up a Fund in RE with GL Distribution in FE (Botanical Garden Fund)
10. Navigate to Robert Hernandez’s record, open any gift to Fund selected in Step 9
11. Click View>Summaries>Accountability Summary
12. Select a date range of 1/1/2007 through 1/15/2007 (for a small data set) and refresh the report
13. Note the Total Expenses, Losses and Transfers amount
14. In FE, add a $1000 Expense via Journal Entry and post the entry
15. In RE, fresh the Accountability Summary, the Expense increases by $1000
16. In FE, go to the Journal Entry and reverse an expense for $1000 on 1/15/2007 and post the entry
17. In RE, refresh the Accountability Summary, no change in the numbers
18. In FE, add a $1500 invoice expense on 1/15/2007 and post the invoice
19. In RE, refresh the Accountability Summary and the Expenses increases by $1500
20. In FE, delete the $1500 invoice and post the reversal
21. In RE, refresh the Accountability Summary and the Expenses decrease by $1500
1. In FE, create an account attribute with a Table data
2. In the Table Name column, select [Add New Table] and enter a table name for the attribute (Functional Expense)
3. Add entries to the table created for the new attribute (i.e. food, salaries, supplies, etc.)
4. Globally Add the account attribute to GL accounts and select any description
5. In RE, set up integration between RE and FE in Config>General Ledger
6. Under Accountability Options, select Account Attribute setup in FE for Accountability options
7. Check the boxes to Show Budgeted Distribution and select a Budget Scenario from the drop down (Administration)
8. Check the box to Include Loss Accounts and Include Transfer Accounts
9. Set up a Fund in RE with GL Distribution in FE (Botanical Garden Fund)
10. Navigate to Robert Hernandez’s record, open any gift to Fund selected in Step 9
11. Click View>Summaries>Accountability Summary
12. Select a date range of 1/1/2007 through 1/15/2007 (for a small data set) and refresh the report
13. Note the Total Expenses, Losses and Transfers amount
14. In FE, add a $1000 Expense via Journal Entry and post the entry
15. In RE, fresh the Accountability Summary, the Expense increases by $1000
16. In FE, go to the Journal Entry and reverse an expense for $1000 on 1/15/2007 and post the entry
17. In RE, refresh the Accountability Summary, no change in the numbers
18. In FE, add a $1500 invoice expense on 1/15/2007 and post the invoice
19. In RE, refresh the Accountability Summary and the Expenses increases by $1500
20. In FE, delete the $1500 invoice and post the reversal
21. In RE, refresh the Accountability Summary and the Expenses decrease by $1500

Environment

 Raiser's Edge
 7.93

Was this article helpful?