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

Â