Error: The DELETE statement conflicted with the SAME TABLE REFERENCE constraint FK_FINANCIALTRANSACTIONLINEITEM_SOURCELINEITEMID - when adjusting the amount of a payment with a matching gift claim associated

When working in CRM, you may find the need to adjust the amount of a payment with a matching gift claim associated using a Revenue Update Batch. Under certain circumstances, you may receive Error: "The DELETE statement conflicted with the SAME TABLE REFERENCE constraint "FK_FINANCIALTRANSACTIONLINEITEM_SOURCELINEITEMID". The conflict occurred in database "databasename", table "dbo.FINANCIALTRANSACTIONLINEITEM", column 'SOURCELINEITEMID' when doing so.

Article
Number:99092

Products:

Blackbaud_CRM

We're currently evaluating this issue for a fix in a future release

Steps to Duplicate

1. Log-in to 4.0.2. Go to Constituents and add an Individual.3. On the Relationships tab, click Add Organization. Related Organization: AnyConstituent is the: EmployeeOrganization is the: EmployerMark 'This is the primary business for constituentMark The organization will match contributions for this relationship4. Save. 5. On the Organization record's Organization info tab, under matching gift conditions, click Add. Type: EmployeeRevenue type: GiftsMatching factor: 1Relationship type: Employee6. Save. 7. Go to Revenue and click Add a payment. Add a donation for your constituent from step 2. Save. 8. On the Matching Gifts tab, click the Match Amount hyperlink to go to your Matching gift claim. Click Add Payment, enter an amount, and Save. *You should now have a fully paid off matching gift claim.9. Go to Revenue, Batch Entry, and click Add. Add a Revenue Update Batch. Revenue: transaction from step 710. On the Revenue tab, click Matching Gifts. Adjust the Date to another date. Click Ok. 11. Update the revenue amount to $0. Press No on both the pop-ups which confirm resetting the Recognition credits and Matching gifts.12. Update projected totals and Validate. Notice Error: "The DELETE statement conflicted with the SAME TABLE REFERENCE constraint "FK_FINANCIALTRANSACTIONLINEITEM_SOURCELINEITEMID". The conflict occurred in database "databasename", table "dbo.FINANCIALTRANSACTIONLINEITEM", column 'SOURCELINEITEMID'."