• Problem running an SQL Update query in a table script using CreateQueryObj() Exec()

    Hi all, I have a problem running a query to update a Company record from inside of the Comm_Link (secondary) entity. The query starts in Comm_Link > grabs Communication details > grabs Company details > updates a new custom field in the Customer entity…
  • SQL Server Web Edition

    Hi guys, Just wondering if anyone has any experience running Sage CRM on SQL web edition? The pricing seems quite competitive and wondering if there are any limitations/licence implications? Thanks, David
  • Creating a report based on a view using parameters

    Hallo, i have created a report based on a view. The where clause of the view containts a fixed value. for ex : where QtyDays = 5 and ... Our customer wishes that the fixed value becomes variable and act like a parameter. My tought was to create…
  • Deleted Opportunity List

    HI All Hope anybody can help, Running Sage CRM 7.2d The Opportunity list was deleted by accident When I go to opportunities there is just a blank Screen When trying to recreate the views in Admin-> Customization Now When I add items to the…
  • add link image to panel or screen

    Hi How can i do this in .net SDK i try but not work
  • Best practice and SQL 2012 entity size

    A quick question about best practise, maximum entity size, and SQL 2012. We are currently redeveloping our implementation of CRM and in our Oppo entity we will have circa 100 fields at release and I know, due to the demanding and changing requirements…
  • CRM sData SQL Grammar exception

    Hi I am trying to access Company data through sData and I can view stuff like Users, People, or the schema with no issues. When I try to view the company list, or even just a specific company with these URLs: servername/.../Company servername/.…
  • Getting Field generated Case Reference ID in CreateScript

    Hi Is there a way on the New Case screen to get the generated Case_referenceid in the CreateScript for another field. What I need to do is have a caption link to an external site. The link will for instance be www.testsite.com?case=1-12345 This…
  • Entities based on Custom views

    Good day This is so trivial thing but I could not find anything on the community. What I want to do is to create a view in the CRM DB and create an entity in CRM with that view as the basis. I need to expose the values I get from this view in…