Hello,
I crated a new View in the Customer entity where I needed to extract Sales information from Sage300.
The view is created in CRM and a "Select * from" that view executes without errors in SSMS (SQL Management Studio).
When trying to execute a new report based on that view in CRM, I get the following message:
"Could not convert variant of type (OleStr) into type (Double)"
I can't find any details on that error in the CRM logs and Tomcat logs.
System info: Sage CRM 2019 R2
Any help would be appreciated.
Thanks.