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.  
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:  Any
Constituent is the:  Employee
Organization is the: Employer
Mark 'This is the primary business for constituent
Mark The organization will match contributions for this relationship
4.  Save. 
5.  On the Organization record's Organization info tab, under matching gift conditions, click Add. 
Type:  Employee
Revenue type: Gifts
Matching factor: 1
Relationship type:  Employee
6.  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 7
10.  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'."



 

Environment

 Blackbaud CRM
 4.0

Was this article helpful?