Upgrade from 7.5 to 8.0 Database error: text, ntext, and image by

[SundancerKid]

I am receiving the following error:

The text, ntext and image data types can not be used in a Group by clause.

I upgraded from 7.5 to 8.0 of Great Plains. The orginal views and SP's i created for reporting purposes does not work any more when creating SQL views or SP.

Any Suggestions?

Thanks RP

 

[stef315]

I'm not sure I understand what you are saying. However, if you wrote some custom views and/or stored procedures for the 7.5 tables, you might need to make changes. It depends on what tables and fields you are using. Those table and fields may have changed in version 8. They could have changed data types, name, location, eliminated them, etc.