Account Trial Balance - Error updating SOY balance
When running Account Trial Balance for next year Munis error received
Error updating soy balance. Status:
System log Id: #
Account Trial Balance (ATB)
Next Year (NY) calculated Start of Year (SOY)
Configuration & Setup
Error Message
One or more funds have incorrect reference account in Account Master for balance sheet with closing balance ZERO
Appropriations, Estimated Revenue with closing balance ZERO do not correctly reference the same fund's Budgetary Fund Balance - Unreserved Control
Run Table Validation to see if there are any controls defined with the wrong closing balance for their fund type
Browse to Enterprise ERP > Financials > General Ledger Menu > End of Period > General Ledger Table Validation
Consolidated
Accept
Run Table Validation
Select needed output (save, pdf, display or print)
Review for any closing balance error messages.
Run Account Trial Balance with a narrowed record set selection and keep narrowing it down until specific fund or funds are identified
Contact Munis Financial General Ledger Support if problem funds cannot be identified
Correct Appropriations and or Estimated Revenue control account listed reference account which should be same fund's Budgetary Fund Balance - Unreserved Control
Browse to Enterprise ERP > Financials > General Ledger Menu > Set Up Chart of Accounts > Account Master
Search by Fund and control account field for needed account that is suspect
Accept or Enter
Update
Scroll down to bottom of screen and confirm the listed reference account is for the correct fund
Update to be correct fund's Budgetary Fund Balance - Unreserved Control
Accept or Enter
Rerun Account Trial Balance report using same records selection and report options that were used to trigger error originally and confirm error no longer occurs.
Run Account Audit to see who setup account if no records found Implementation may have used Chart of Account Builder to setup funds
Â