We're a national nonprofit that runs a number of clinics accross the country. Sometimes these clinics recieve local donations/grants for themselves (easy), and sometimes we nationally recieve donations/grants that are assigned to clinics (the issue).
To solve this currently we were using a custom object "Clinic Donations" to connect opportunities to the Clinic object (also custom). We had also created a lookup field on payments to related payments to clinics for payment tracking.
The issue: it has come to our attention that there are times when we may need to track an opportunity that has just 1 payment (to us nationally), but disbursements to multiple clinics. Is the custom "clinic donations" object the best way to handle these credits, or am I missing something simpler?
Thank you!
1 件の回答
Hi Ernest
Try using a juncstion object between opportunity and clinic
https://www.forcetalks.com/salesforce-topic/what-is-the-use-of-junction-object-in-salesforce/
Hope it helps!