Error: Incorrect syntax near the keyword 'group' received when non-admin users add revenue to an opportunity

When adding revenue to an opportunity, non-admin users receive the error, "Error: Incorrect syntax near the keyword 'group'". Admin users are able to accomplish perform this function.
We are currently evaluating this issue for a fix in a future service pack.

Steps to Duplicate

1. Search constituent
2. Click the Prospect tab
3. Click the specific plan
4. Click the Opportunities tab
5. Click Go to Opportunity
6. Click Associated Revenue Tab
7. Click Add - Existing Revenue
8. Search constituent with specific revenue
9. Error: Incorrect syntax near the keyword 'group'

Environment

 Blackbaud CRM
 4.0
 4.0.180

Was this article helpful?