Sage 300 ERP

From Accelerator for SageCRM
Revision as of 13:40, 18 December 2014 by Sagecrmw (talk | contribs)
(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 (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"/>