Issue Detail:

Getting the error: [Microsoft][ODBC SQL Server Driver][SQL Server]The multi-part identifier "PLUSBAL.HCAMOUNT" could not be bound. While running the GL Transactions Incl OpenBalance report from Sage 300  Intelligence Report viewer & Report Manager. 

Cause:

Issue was found to be related to an MSSQL Arabic Database Collation.

Resolution:

Database collations Arabic_CI_AS and Arabic_100_CI_AI have been tested and confirmed to resolve the error. Applying either collation ensures compatibility and proper interpretation of Arabic character data, preventing identifier-related conflicts during query execution.

Sage 300 support team