Hello,I have a problem with communication entries that have been synchronized with Outlook with the Classic plugin.When a new appointment has been set, all team members can see it in TeamCRM.After synchronization it disappears from teamCRM and nobody can see it anymore. As far as I know, when synchronizing an entry with Outlook the Comm_OutlookId is set in the table "Communication".What do I have to do to keep the entry visible to all team members?
Thank you in advance Guido
I know that this isn't the newest version but maybe someone has a tip for me.
Have you checked in the database to see whether the communication record and the associated comm_link record exists? If a record 'disappears' from Sage CRM it make be that the security profile have caused the record to be hidden from the user. For example can the System Administrator see the records in the interface?
thank you for your Reply.
I don't see the records As an Administrator either
What rights do you mean and what do I have to check.
Do you have access to the database and are you happy running SQL statements?
If you are then you can look at the communication table and the comm_link table check whether the record exists.
You can also see whether the comm_deleted flag is set (This would supress the display of the record).
A simple check is to see whether the record is having its status changed so that it no longer is show in the list screens. Within the communication list page make sure that the filter box is looking for all records.
These are my Statements
select Comm_Deleted, * from Communication
where Comm_Subject ='Testtermin nicht löschen!!!'
select CmLi_Deleted, * from Comm_Link
where CmLi_Comm_CommunicationId = 49746
and both are not deleted
The filterbox, you mentioned, is set to all.
Do you have further suggestions
Try this: Run Sql profiler while this is happening.
Once done; check what queries making change in which area related to communication, may be you will get a clue if it is related to database or at least you will be able to narrow down the issue.
© The Sage Group plc 2017All Rights Reserved