How to prevent Opportunity attachments from showing up in Account attachments?

Question

I have an issue where files that have been attached to opportunities are showing up in the parent accounts as well. How do I prevent an attachment associated with an account's opportunity from rolling up to the account?

Answer 1

There is one way to move the attachments as Files on Opportunity. Please refer to the code below (from one of my class) to get the idea:

public void addAttachment()
{
    attachment.parentId=caseId;
    insert attachment;

    //Adding a Content post
    FeedItem post = new FeedItem();
    post.ParentId = caseId; //eg. Opportunity id, custom object id..
    post.Body = 'Attachment added';
    post.ContentData = attachment.body;
    post.ContentFileName = attachment.Name;
    insert post;
}

This code can be used to run in loops (with DML statement outside loops) for the Opportunities you identify and once done the attachments for the same opportunities can be deleted using code as well.

Answer 2

It doesn't appear that there's a lot you can do to modify the way Attachments are handled by Salesforce. This blog entry by Jeff Douglas recommends creating a new custom object with accompanying triggers and buttons to allow for modification.

Additionally, you could mark the attachments as Private so that only the User who loaded the document would see it.

Though, is there a particular reason why you would want to take away this functionality?