I get most of the views that use tables in the database to be created as remote views. I get the error 8120. Column 'invdetail.product' is invalid in the select list because it is not contained in either an aggregate function or the GROUP BY clause. I get the same error on a couple of my views. I don't know understand why I get it. Do you know a little bit about this error?

Thanks,
Tyler