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'