We would like a field on our Opportunity record that reflects all of the Product Category values on related Revenue Line Items. For instance, for an Opportunity with 2 Revenue Line Items, if a "WP" Product Category was on 1 Revenue Line Item and "EC" was on the second Revenue Line Item, we would have a field on the Opportunity that reflects both "WP" and "EC" so that we can filter and report on "Opportunities with Product Category "WP", for instance.
We like the idea of the "RollUp" SugarLogic formulas, but there isn't anything like this for these fields, so we were thinking maybe a SugarBPM process could do this for New Opportunities and whenever the RLI Product Category field was changed.
Thanks...VO