Hi Community,
My org is new to Raiser's Edge and we are having some issues with pledges and pledge payments in exports. I've been trying to pull an export of all giving from a select group of donors for the past 5 fiscal years, and for each donor that had a pledge/MG pledge that was later paid off, that gift is showing up doubled in my export (ex, X had a pledge for $15,000 on 6/14/21 which he paid off on 6/17/21 - his total giving is coming through as $30,000 for FY21). What's weird is that the pledge payments appear to have all been recorded correctly - they all appear to be tied to the correct gift in the gift record, and the Giving Summary in web view doesn't show them as being doubled.
I've tried excluding pledge payments by gift type (ie excluding ‘Pay-Cash’ and ‘MG Pay-Cash’), and it fixes the issue, but that also removes all soft credits, which I guess are also being recorded with the ‘Pay-Cash' gift type as a default. The export needs to include pledges, so I can't exclude those. I'm totally perplexed. Anyone else dealt with this? There has to be some difference in how soft credits and pledge payments are categorized, right? I'd appreciate any ideas! Especially if it's an easy fix that I'm missing as a year-one RE user!