Sage CRM

Hi, Some background to the issue; We've altered our eware_default_values Stored Procedure to assigned custom incremental ID's to Leads. When creating a lead through CRM it assigns an incremental ID. However, the Leads created via Data Import do not…

We're using Sage 7.2e and are getting an error when accessing the Communication tab from Opportunity Summary. It's since I created a stored procedure that executes when the communication table is updated. Got a trigger on the communication table in…

Hi, We're looking to have incremental ID's for our Opportunities, similar to that of Case & Solution. I'm wondering if it's possible to, after having created a field on the opportunity entity call OppoRefID which will use a stored procedure. To then…

Hoping someone can help me with this. I am probably making it harder than it needs to be.... I want to place a button on an ASP page to launch a SQL stored procedure. I successfully put the button on my page as follows.... var strCallSyncButton =…

I have a stored procedure that gets called by a workflow escalation rule. If this is fired it creates a ToDo task. This all works perfectly. My issue is these tasks are not syncing to Exchange. My stored procedure is below. Any help is appreciated. …

Hi, I am using Sage CRM v7.2. I have to import data from an XML file to my custom entity. I noticed that Sage CRM doesnt support importing for custom entities. Is importing data in SQL server directly to my "Custom entity " table the most effective…

Hi all, We are looking into way of triggering an automated appointment creation based on selection. For example: If I create a new appointment in sage CRM 7.1 and select "Holiday" as the action. Complete all relevant details on for the appointment…

Hi all, I have a problem with run and stored procedure field of table, No run of workflow rule. I created a new field of stored procedure type in company table. My objective is to get the number of opportunities open by current company, and display…

Good Morning Community, I find myself in need of running a batch file from within a component. I have found the RunSQL command and know of the XP_CMDSHELL procedure in SQL, which runs a command line in command prompt. The command is to be used to run…