• SQL query to get descriptions from selection lists

    Hello, Does anybody know which table are the descriptions of the codes for selection lists kept in? I am writing an SQL query to get some information for a report that is going to be outside of Sage CRM For example I have this lookup table setup…
  • Quarterly reports based on Join Date (Membership Renewal Report)

    Hi. I have a request from a new Sales member of our team to show on their CRM dashboard when an existing member is up for renewal. We renew a member every year (so yearly) - the month of their join date (aka startdate) is what triggers the invoice.…
  • Library Record Creation - Sage 2017 R2 - SOAP /WEBSERVICES - Question

    All, Thanks for taking the time to read this. I have an issue with creating a library record via web services. AIM : Create a library Record -> Populate fields with data. Sample Code: ewarebase[] CRMBase = new ewarebase[1];//Allows reference…