Account Trial Balance - A subquery has returned not exactly one row

When attempting to output Account Trial Balance receive error
Error
Program stopped at 'glatrbal.4gl', line number 3297.
SQL statement error number -284 (-1).
A subquery has returned not exactly one row.

• Account Trial Balance (ATB)

• Chart of Accounts

• Control Accounts

• Duplicate

There is a duplicate value somewhere in the record set of select accounts and selected fiscal year/period date range

1. Run report for a smaller range of funds or accounts and attempt to narrow down the scope of the possible error

2. Contact Munis Financial General Ledger Support for review of the root cause and provide performed troubleshooting and examples

If run for Next Fiscal Year if duplicate control accounts may exist for fund that is not marked for secondary balancing

• • Revenue control

  • Expenditure control

  • Estimated Revenue control

  • Appropriations control