I am building a custom report using SQL to better report on the finances around our contributions. Is there an easy identifier between T_CONTRIBUTION and gl_account_no other than using the T_FUND and then using a CASE statement to select the correct GL Code from there based on other factors?
Hi Robert,
I may be wrong (someone feel free to correct me!) but I believe the Fund associated with the Contribution is the only link for GLs.
Martin
Yep the contribution GLs are fund based ... there can be 5 per GL (future, current, restricted etc)
Ah, that's what I was afraid of. So basically, I just need to figure out the "rules" (when a contribution should be assigned each one) and employ that logic in the SQL code itself so it assigns the correct GL code to each contribution.