Good morning all,
I am writing a custom report to show board member giving. Some board members are part of a household and the contributions are stored at the household level, but we want to show them next to the individual names on this particular report.
I am planning to build a custom view using one of the V_CUSTOMER_WITH_ views or maybe a function that will grab the household id for me. But I'm wondering if someone knows of a way using standard objects, or has written something custom, to do this.
I found VSB_CONTRIBUTION but that appears to do the opposite. i.e. Allowing contributions on an individual record to be pulled by the household customer_no.
Any thoughts are appreciated!
Thanks
- Levi
Hey Levi -
I'm not sure if this is what you want or not... Check in your scalar valued functions and see if FS_GET_HOUSEHOLD actually made it into your build. It was a little piece of code heaven that Chuck whipped up (I think so stop all my whining while testing) - and I know it is standard in v12, just not sure when it made it into v11.
I use it all the time - with the caveat that it is not super SUPER efficient. So if you used it on something that was pounding through a gazillion records you'd probably notice some performance hit.
HTH,
Heather
That sounds perfect Heather! I'm dealing with something less than 100 records. Unfortunately you seem to have a bit more pull than I :) The function is missing from my V11 database. If you have a few moments and can shoot me the SQL for it I'd be eternally grateful.