Sage 300 ERP

From Accelerator for SageCRM
Revision as of 11:39, 18 December 2014 by Sagecrmw (talk | contribs) (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...")
(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)

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_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"/>