Skip to content


Bank Transaction Mapping

Charles asked 6 years ago
I’m getting the error message below when trying to import a bank transaction:
Violation of PRIMARY KEY constraint PKCM20100. Cannot insert duplicate key in object ‘dbo.CM20100’. The duplicate key value is (1013.00000,0).
The file has a single row in it.
I’ve specified that I’m using the Enter Transaction option and Decrease Adjustment type.
The distribution is one-sided with the amount in the Debit column.
What is causing this error?
Mark Anderson Staff answered 6 years ago
Please check out this link with the same error from our site and ensure you are following these steps.
Charles replied 6 years ago


I’d seen this but I only have one row in my spreadsheet.

If I could paste an image of the mapping, I’d do so.

If you would like to submit an answer or comment, please sign in to the eOne portal.