Not sure if this is the right forum for this discussion, but I wanted to bring it up to see if anyone knew anything about this. I had noticed sometimes in the "Activites" that there were duplicate appointments, but on the calendar and in the account it would only show one, so I was a little confused as to how this happened. While using Crystal Reports and running reports based on activites, I started to notice this happening more and more, so after a lot of testing I was able to replicate the issue.
So from what I've learned, it looks like we have two tables where information based on appointments is stored, ACTIVITY and HISTORY. Activity for the future, History for the past and completed. When something is on the calendar, it will show up in Activity until it's been completed then moved to History - great, that works.
However, when you complete an Activity, you have the option of scheduling a Follow Up Activity. When doing this, it creates a duplicate activity entry in the database, one that now can never be completed. Does anyone know how this is happening, and how to prevent it? I mean I am ready to take off that follow up button, but it's a very handy feature to have. |