Error: Data could not be saved. Violation of PRIMARY KEY constraint 'PK__#36E0BE1__3F0526A238C9068C'. Cannot insert duplicate key in object 'dbo.@AccountCodeMappingTable' - when attempting to delete benefits from posted payments

When attempting to delete benefits from posted payments, users may receive the error below when saving the adjustment:

Data could not be saved. Violation of PRIMARY KEY constraint 'PK__#36E0BE1__3F0526A238C9068C'. Cannot insert duplicate key in object 'dbo.@AccountCodeMappingTable'. The duplicate key value is (99999999-9999-9999-9999-999999999999, 1).

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, patch 13
 3.0.516, Service Pack 3

Was this article helpful?