Problem:
After the upgrade to PM 11.2 users get the following error when accessing the Credit Centre in Central Console.
Advance Credit Centre
ExecSP: Column '#ClientIDs.ClientID' is invalid in the select list because it is not contained in either an aggregate function or the GROUP BY clause.
Cause:
A bug when the relationship type ID is set in SUPS-->Credit Management
Resolution:
Please refer to Knowledge Article 01770 (Practice Management 11.2 Known Issues) for a new Version Control (11.2005) that fixes this issue