Views:

A new Smartlist is created in Smartlist Builder using the Receivables Transactions Smartlist and linking it to the Record Notes Index table to get the Notes Text included in the smartlist.  Results display correctly in Smartlist but in Smartview an error was received, “Argument data type text is invalid for argument 1 of rtrim function”.  Smartview rtrims all string fields and since the type was text, it could not rtrim.  A calculated field must be created to convert the text to a string, Cast({Record Notes Master:Text Field} as varchar (MAX)).  This resolved the issue in Smartview and the field in Smartlist displayed correctly as well.