Sage 300 ERP: Difference between revisions
From Accelerator for SageCRM
(Created page with "You can customise the search to display for example the ERP customer ID in the search lists (IE and Outlook) This is an example of the settings change <add key="company_s...") |
No edit summary |
||
| Line 1: | Line 1: | ||
You can customise the search to display for example the ERP customer ID in the search lists (IE and Outlook) | You can customise the search to display for example the ERP customer ID in the search lists (IE and Outlook) | ||
This is an example of the settings change | This is an example of the (web.config) settings change | ||
<add key="company_selectsql" value="select *, rtrim(comp_name) + ' ('+rtrim(isnull(comp_idcust,''))+')' as 'compdesc' from vSearchListCompany where comp_name like '#searchsql#%' and comp_deleted is null"/> | <add key="company_selectsql" value="select *, rtrim(comp_name) + ' ('+rtrim(isnull(comp_idcust,''))+')' as 'compdesc' from vSearchListCompany where comp_name like '#searchsql#%' and comp_deleted is null"/> | ||
<add key="company_listfields" value="compdesc,Comp_WebSite"/> | <add key="company_listfields" value="compdesc,Comp_WebSite"/> | ||
Latest revision as of 11:40, 18 December 2014
You can customise the search to display for example the ERP customer ID in the search lists (IE and Outlook)
This is an example of the (web.config) settings change
<add key="company_selectsql" value="select *, rtrim(comp_name) + ' ('+rtrim(isnull(comp_idcust,))+')' as 'compdesc' from vSearchListCompany where comp_name like '#searchsql#%' and comp_deleted is null"/>
<add key="company_listfields" value="compdesc,Comp_WebSite"/>
