Good day,
On version 7 of Sage Evolution, I created an SQL trigger to force the user to enter an Inventory group and Packs when creating new items.
On Version 10 and above, I am failing to achieve this due to the different stock table structure, as…
In Sage CRM development around phone numbers and email addresses needs careful thought. This is because Sage CRM "entities" can be complex. For example, the information for a Company consists of a company record, a default person record and a default…
This is a follow-up to the article I wrote previously called " Understanding the CRMEmailPhoneData table ".
That article explained that the CRMEmailPhoneData is a utility table and that its job is to speed up reports. It holds a row for each company…
If you have spent time looking at the way in which views are constructed in Sage CRM then you may have found the CRMEmailPhoneData table referenced and wondered what is the table's purpose.
I asked a colleague in our development team for some help in…