/
Account Trial Balance - Error updating SOY balance

Account Trial Balance - Error updating SOY balance

Description of Issue

When running Account Trial Balance for next year Munis error received
Error updating soy balance. Status:
System log Id: #

Context
  • Account Trial Balance (ATB)

  • Next Year (NY) calculated Start of Year (SOY)

  • Configuration & Setup

  • Error Message

Cause
  • 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

Resolution
  1. Run Table Validation to see if there are any controls defined with the wrong closing balance for their fund type

    1. Browse to Enterprise ERP > Financials > General Ledger Menu > End of Period > General Ledger Table Validation

    2. Consolidated

    3. Accept

    4. Run Table Validation

    5. Select needed output (save, pdf, display or print)

    6. Review for any closing balance error messages.

  2. Run Account Trial Balance with a narrowed record set selection and keep narrowing it down until specific fund or funds are identified

  3. Contact Munis Financial General Ledger Support if problem funds cannot be identified

  4. Correct Appropriations and or Estimated Revenue control account listed reference account which should be same fund's Budgetary Fund Balance - Unreserved Control

    1. Browse to Enterprise ERP > Financials > General Ledger Menu > Set Up Chart of Accounts > Account Master

    2. Search by Fund and control account field for needed account that is suspect

    3. Accept or Enter

    4. Update

    5. 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

    6. Accept or Enter

    7. 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.

Additional Information

Run Account Audit to see who setup account if no records found Implementation may have used Chart of Account Builder to setup funds

 

Related content

Account Trial Balance control account error- reference account not found
Account Trial Balance control account error- reference account not found
More like this
Month End Manager and Balance Sheet Report has unbalanced fund but not Table Validation report
Month End Manager and Balance Sheet Report has unbalanced fund but not Table Validation report
More like this
Account Trial Balance - A subquery has returned not exactly one row
Account Trial Balance - A subquery has returned not exactly one row
More like this
Fund Control Discrepancies for Expense or Revenue Control - Account Type Changed to Balance Sheet
Fund Control Discrepancies for Expense or Revenue Control - Account Type Changed to Balance Sheet
More like this
Unable to update fund in Chart of Account Segments. Error Invalid Budgetary Method
Unable to update fund in Chart of Account Segments. Error Invalid Budgetary Method
More like this
Revenue Control account has SOY balance for annual fund
Revenue Control account has SOY balance for annual fund
More like this