Sage CRM - Tips, Tricks and Components
Letter merge is a part of daily activity followed in sage CRM implemented in several financial and service industries. Apart from emails being sent out, these people always keep in touch with clients by posting them the welcome letters, account Kits, statements, cards etc. These letters can be very easily merged in Sage CRM using Document Merge functionality on Person and Company Entity. Now have you ever wondered how exactly Document merge pulls up all the data for person at the time of merging.
There is a view under Person entity named vMailMerge. Whatever fields this view presents can be included in the word merge templates and merged there on. Below is the original view from sage CRM version 6.2.
Now as you can see that this view already takes care of the phone numbers using the fields from Person table for fax and the default business number. Now what I want here is all the phone numbers under Phone/Email tab of that person to be available for merging in letter. So the only way I can achieve it by joining above query with phone table based on phone type and person id. Now while changing the view above we have to take care that the view should not generate more than one row for single person. You know that there may be multiple entries in phone table for that person so we have to combine them all in single row. Below is how I changed the above view to bring Business and mobile phone numbers separately from the phone table.
Now you can add the field Business_Phone_Number in the template to be merged and get the value when the template s merged.
Note: Sage CRM version 7.1 has the different structure for maintaining phone numbers i.e. using link table. So to use the above view in version 7.1 you have to join on phone link table also to get the actual numbers.
If you enjoyed this article, please consider sharing it!
