I am setting up a new instance for our org and am trying to figure out the best/easiest way to handle opportunities that are split between different designations/programs. Our users are extremely green when it comes to SF and aren't currently tying their financials to the database so I was trying to just use a custom 'Designation' field on the opp record so that all the info is contained within one record.
The problem I am running into is for opps that are to be used for multiple designations/programs. I know I can do a multiselect picklist but that really messes up reporting and I'm worried it will not function well with donor payment platform integrations. Short of creating GAU records for every opp, does anyone's orgs have a way that they handle these types of situations?
