Browse By Tags
Home
»
All Tags
»
Person
»
Company
Add()
address
Addresses
ASP
clientside
COM
create script
CRMEmailPhoneData
Email
Import
insert
newproduct
Opportunity
OrderItems
orders
phone
progress table
Record Object
Reports
Runblock
SQL
triggers
uomfamily
Views
Web Services
Blog Post:
Company and Person Workflow Progress with Tracking tab in CRM
Jeff Richards
Many thanks must go to a colleague in the UK professional services team for this article. Introduction Customers often request the ability to track Company or Person changes in much the same way that CRM offers with Opportunity and Case entities. As standard, CRM does not offer a CompanyProgress...
on
3 Jul 2009
Blog Post:
Add an Additional Address to an Existing Company and Person using SOAP Web Services
Jeff Richards
Below is some simple C# code that shows how to add a new Address to an existing company. The address is inserted and linked to the company and the default contact for that company. Notes : The webservice object is called CRMbinding. The Company ID is assumed to be passed from a textBox control...
on
23 Sep 2011
Blog Post:
Using Joins in Web Services
Jeff Richards
Imagine you need to retrieve information from CRM via the webservices interface; this query should combine data from multiple tables. In the COM API (ASP pages, self service, table level scripts etc) you could use the QueryObject to build the exact SQL you need. var mySQL = "SELECT Person.*,...
on
9 Jun 2009
Blog Post:
Creating your own Import Scripts using the COM API
Jeff Richards
Please read the article " Some thoughts on Importing Data " as background. The previous article discussed the different programming techniques that can be used for importing data into Sage CRM. Web Services COM Based Mechanisms .NET API Direct Data Interaction The COM...
on
20 Aug 2010
Blog Post:
Understanding the CRMEmailPhoneData table
Jeff Richards
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 explaining the table and the following information...
on
19 Jun 2015
Blog Post:
Why do Phone numbers appear in the Company and Person screens when they are stored in the Phone table?
Jeff Richards
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 it's job is to speed up reports. It holds a row for each company or person with that company or persons...
on
24 Jun 2015
Blog Post:
Hold the Phone! A round up of articles that discuss Phone Numbers and Email addresses in Sage CRM
Jeff Richards
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 address. Both the company and the default...
on
24 Jun 2015