Acknowledgement Report with Donor Advised Funds

@Carly Foland
in a gift query, you are not going to get the soft credit's receipeient's contact info directly. there are few ways I can think of, but none is direct.

1. run gift query, use query option to soft credit recipient with grid amount. When you output the constituent info from the Constituent section, you will get the soft credit's ID, name, address, etc.
   • This method's problem is going to be with multiple soft credit, IF your org does not allow soft credit to multiple, then your query is good to go, but
   • IF your org does allow multiple soft credit, then your amount column is not going to work out as it will export the gift amount for the WHOLE of the gift, not just the soft credited amount. In this case, you will need to work with “DUP” record rows. Output from the “Soft Credits” section in the gift query for the soft credit receipient's ID and amount. You will get duplicates rows for each soft credit. (if a gift has 2 soft credits, there will be 4 rows of data). You can use a simple excel formula where Constituent ID column = Soft Credit Recipient ID column, and delete the row that has FALSE. the remaining TRUE rows will have the soft credit amount column you need for proper acknowlegement.
2. Run 1 gift query on the gifts you want to do acknowledgement for. use Query Option that select soft credit to Donor. In your output, you will output the Soft Credits section's Soft Credit Recipient ID column. THEN you will need to run a Constituent query, and copy the Soft Credit Recipient ID from the gift query export and do “one of” as criteria and output the info you need (making sure you output Constituent ID column). Then use XLOOKUP in excel to wrong the constituent info into the gift export.
3. IF you are self hosted and know the RE Database Schema, you can run a SQL Query to do this in one shot, if you can do this route, I can help you with the SQL statement to execute
4. If you are RE NXT, you can do this using SKY API, but will require some learning curve

Maybe there is another way to do this that I'm not aware of, but #1 option is probably the least technical

@Candy Reichert We do not use an Export, we use RE MAIL: Donor Acknowledgement Letters. On the General tab/Soft Credit Gifts to, choose either BOTH (what we do) or SOFT CREDIT RECIPIENTS. If you choose BOTH the DAF will appear in the letters (and you can remove them) and the soft credit (the donor) will appear. If you use SOFT CREDIT RECIPIENTS, on the the soft credit person will show and not the DAF. The only downside to this is if you have a couple who each have their own record the spouse gets soft credited, the spouse will appear and not the main person. But whether you use Export or RE MAIL Donor Acknowledge Letters, this is a way more simple approach than what I have heard others do and we never had any issues.

If you do use an export, you can do the same thing. On the Export, right click on the Top line of the Output and click on Criteria and choose either for the Soft Credit Gifts to of either Soft credit recipients or both. Make sure you query you are attaching is a gift query. And that on the query options you choose for the Credit Soft Credits to (in the Record Processing) you pick Recipient or Both. Also in your query, if you code your DAFs a certain way, have the query say DOES NOT EQUAL DAF (that is if you code your DAF in RE, which is always a good idea. We you an attribute for that, but as long as you code it somewhere, you can use that.