The INSERT statement conflicted with the FOREIGN KEY constraint FK_BATCHREVENUEAPPLICATION_REVENUEID". The conflict occurred in database "<databasename>", table "dbo.FINANCIALTRANSACTION", column 'ID' when changing the application of a payment in batch."


When using the Apply to Commitments window in batch to change the application of a payment, the above error message may occur.
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 3, Patch 20
 4.0.138, patch 2

Was this article helpful?