Fund Control Discrepancies for Expense or Revenue Control - GRV Journals Duplicating amount to the Control Account
Month End Manager Fund Control Discrepancies for Expense or Revenue after reversing a journal entry (GRV Journal source)
Table Validation Error
04 Fund XXXX DESCRIPTIONÂ Â Â Â Â Type: Expense PÂ Â Fund Does not Sum to Control
04 Fund XXXX DESCRIPTIONÂ Â Â Â Â Type: Revenue PÂ Â Fund Does not Sum to Control
- Munis
- Month End Manager
- General Ledger Tables Validation
Control account records were added to Journal Source Maintenance for source GRV when they are not necessary.
The functionality of the Journal Reversal is to take all lines of the transaction (including control account lines) and flip the debit/credit to reverse the amount. Since the program already reverses the control account lines, the system does not need to generate it's own control account lines. This means Journal Source Maintenance should have zero records tied to the GRV source code.
Financials > General Ledger Menu > Setup/Chart of Accounts > Journal Source Maintenance
- Delete the Journal Source Maintenance records for Source GRV
Financials > General Ledger Menu > End of Period > Month End Manager
- Month End Manager will have a hyperlink under the Fund Control Discrepancies column for each period where the issue occurs.
Financials > General Ledger Menu > Journal Entry/History > General Journal Entry/Proof
- To resolve
- a manual General Journal Entry is necessary to reduce the Expense or Revenue Control Account amount to the amount of the Expenses/Revenues within that period
- Since Munis balances by period, a journal should be entered/posted to each period where the out of balance occurs.
- Or the GRV's that caused the issue can be reversed in the same year and period
- Then reverse the original journals which should create the appropriate journal lines only
- a manual General Journal Entry is necessary to reduce the Expense or Revenue Control Account amount to the amount of the Expenses/Revenues within that period
For further information on entering the correcting journal, use the General Journal Entry Process documentation.