Last communication date on company summary screen

Question

Hi 
 a client would like to see the last communication date on the company summary screen, has anyone been able to do this before and if so would anyone have any sample code for this please 
 Many Thanks

Matthew Shaw · Accepted Answer

I get asked this from time to time, I handle it via a SQL Trigger on the Communication table, to update a date/time field I create on Company. (sometimes it could be Opportunities, in other times both) 
 Through the script I then handle the customers requirements, Do you only show the date from a communication assigned to the sales team? Do you ignore eMarketing Comms? Do you ignore 'Pending' comms? All action types or just some? Though for the date most times it tends to be the Start Date of the communication in the majority of times.

Sage CRM

Last communication date on company summary screen

Top Replies

COMMUNITY

COMPANY

PARTNERS

SUPPORT & TRAINING