'SQL Statement error number...The multi-part identifier...could not be bound.' Error When Searching Character Code - Account Trial Balance

Description of Issue
  • Why am I unable to search accounts by Character Code?
  • Account Trial Balance program closes out to Munis menu when searching by Character Code
  • Account Trial balance crashes in 11.3
  • Full error example, in  2018.1:

'ERROR

Program stopped at 'glatrbal.4gl', line number 832.

SQL statement error number -6372 (4104).

[Microsoft][SQL Server Native Client 11.0][SQL Server]The multi-part identifier "GLObjects.CharacterCode" could not be bound.'

Context

Account Trial Balance

Cause


Resolution

Work Ticket MUN-369363 addressing the issue is currently open with our Development Team.

Use other segments to define the find set of accounts.

Additional Information