Per the Knowledgebase, Blackbaud's suggested solution to apply soft credits to pledge payments is as follows (https://kb.blackbaud.com/articles/Article/61979):
However, this then skews some query and report results.
For example, if I wanted to see all gifts received in FY17, Blackbaud recommends using this query criteria (https://kb.blackbaud.com/articles/Article/61952)
Journal Entry Date = 7/1/16 to 6/30/17
AND Individual Transaction Received > 0.01
The problem is that this query (and many others) only includes the Journal Entries captured in #1 and #2 above. It does NOT include the disbursement entry (#3 above) to properly net against #2. Thus, the query or report results are overstated by the amount of the soft credit pledge payment(s).
Since we REALLY don't want to have to rewrite many of our queries or have to remember to net out all the soft credit pledge payments, it would be great if Blackbaud could create a better solution for handling these types of transactions.
I am having this same issue. I would love for disbursements to be included in the total of Campaign Analysis Reports because with almost every campaign, we get a handful of third party pledge payments from either constituents who are paying on behalf of a company to foot a pledge, or matching gifts that are received for an individual who made a pledge. We don't want to eliminate the pledge, nor the constituent who footed the pledge, but there is a hole in the reporting on what was actually received and the total is overstated. Same thing with Tribute totals.