Error: Data could not be saved. The DELETE statement conflicted with the REFERENCE constraint FK_REVENUESPLITGIFTAIDREFUND_ORIGINALBASEEXCHANGERATEID" - when deleting a payment"

When deleting a foreign currency payment where Gift Aid is present, instead of a refund being generated the following error is encountered:

Data could not be saved. The DELETE statement conflicted with the REFERENCE constraint "FK_REVENUESPLITGIFTAIDREFUND_ORIGINALBASEEXCHANGERATEID". The conflict occurred in database "[database name]", table "dbo.REVENUESPLITGIFTAIDREFUND", column 'ORIGINALBASEEXCHANGERATEID'.
The statement has been terminated.

Download and install the latest patch, which contains all fixes from previous patches. If you are running an older version, download and install the latest version and then the patch. 

Environment

 3.0.516, Service Pack 4
 3.0.516, Service Pack 6

Was this article helpful?