x Want to participate? Join the group to interact
  • State Not Answered
  • Replies 3 replies
  • Subscribers 74 subscribers
  • Views 408 views
  • Users 0 members are here
Browse Forums
Announcements
105
topics
32
replies
General Discussion
6k
topics
18k
replies
Adam Scratcherd

Communications from Person entity not showing in associated Company

Posted By

I am having a problem with the communications not showing in parent entities. If i create a communication for the Person it shows fine in the person entity but is not showing up on the company page. The same is happening with Opportunities, communications created here are not sowing in person or company. This used to work fine, but I am not sure where to check now.

Thanks

Version: Sage 7.3

  • 0

    The problem could be as simple as the filters used on the Communication List.

    You need to check the SQL log to see the actual SQL that is passed when accessing the CommunicationList under the context of Person and Company.

    The link from the Communication record to the person and the company is made through the comm_link table. See the foreign keys cmli_comm_personid and cmli_comm_companyid.

    These both have to be completed.

  • 0

    Thanks for your suggestions Jeff,

    I have investigated the SQL log and had a look at the database tables.

    It seems the cmli_comm_companyid is not updating when the communication is created. The link is created ok and cmli_comm_personid is correct.

    thanks

  • 0

    the cmli_comm_companyid is not updating when the communication is created. The link is created ok and cmli_comm_personid is correct. Any idea how to get the companyid updating again?

*Community Hub is the new name for Sage City