Welcome to Forums Sign in | Join | Help | Forums
in Search





Make the world a better place.

Soft Credits in Query

Last post 10-09-2009 1:21 PM by JoAnn Strommen. 2 replies.
Page 1 of 1 (3 items)
Sort Posts: Previous Next
  • 10-08-2009 6:24 PM

    • Karen Snyder
    • Not Ranked
    • Posts 13
    • Organization: Greater Minneapolis Council of Churches

    Soft Credits in Query

    Normal 0 false false false MicrosoftInternetExplorer4 st1\:*{behavior:url(#ieooui) } /* Style Definitions */ table.MsoNormalTable {mso-style-name:"Table Normal"; mso-tstyle-rowband-size:0; mso-tstyle-colband-size:0; mso-style-noshow:yes; mso-style-parent:""; mso-padding-alt:0in 5.4pt 0in 5.4pt; mso-para-margin:0in; mso-para-margin-bottom:.0001pt; mso-pagination:widow-orphan; font-size:10.0pt; font-family:"Times New Roman"; mso-ansi-language:#0400; mso-fareast-language:#0400; mso-bidi-language:#0400;}

    Does anyone else have an issue with the gift amount not reflecting the actual soft credit amount in Query?? Specifically, following what I consider a "best practice" (Knowledge Base #BB75014), we hard credit the United Way organization and soft credit the appropriate gift amount to each donor.  I frequently have a need to query on specific gift amounts.  In Query, I always set the “Query Options/Gift Processing” (under “Tools” on the pull-down menu) to “Credit Soft Credits to Recipients / Use amount in grid”.  The correct donor gift amount is actually available in the “Soft Credit Amount” field in Query.

    This Query is used in the Export module to create my Excel spreadsheets and the donors of these soft credit gifts appear in the exported file and are identified with “$0” gifts.  So, I do multiple sorts on the spreadsheet to find and delete these rows.

     

    Is what I perceive to be a weakness in the software an issue with anyone else? Thanks for your input!  Karen

    Filed under:
  • 10-09-2009 10:47 AM In reply to

    Re: Soft Credits in Query

    I think I am confused as to what you are saying. It sounds like you are using a Query that includes soft credit donors and then exporting and deleting all of the soft credit donors. If that is the case - why not just exclude soft credit donors from your query? I am unclear as to what you are tryng to accomplish. I use soft credits all of the time and have no issues with the functionality. Query is not a reporting tool so you need to be aware of that as well. Maybe your needs would be met by choosing Soft Credits apply to both full amount to all?

     

    Laurel Quaintance
    Manager, Fund Development Services
    Friends of Bassett, Inc.
    607/547-3081

    Donate Now! https://www.friendsofbassett.org/fob.php

    Bassett Healthcare: Right Where You Need Us

    Bassett Healthcare, A network of 5 Hospitals and over 25 Health Centers, offers the finest medical care to residents of rural Central New York
  • 10-09-2009 1:21 PM In reply to

    • JoAnn Strommen
    • Top 10 Contributor
    • User Since: 2006
    • Posts 255
    • Organization: Rapid City YMCA
    • Products:  The Raiser's Edge

    Re: Soft Credits in Query

    I was/am really confused too.  Not sure if the question is about the query or the export.  I ran a quick export and my export showed the full amount of the soft credits when I chose 'soft credit amount'.  Don't know why you'd get $0 or if that's the issue.

    Only issues we've had with soft credits was initially knowing how it would afftect some reports - for some there is potential for double counting $. Just have to be aware of it.

    JoAnn Strommen
    YMCA of Rapid City
    Rapid City, SD
    Filed under:
Page 1 of 1 (3 items)