Skip to content
+1-888-319-3663

COMMUNITY FORUM

Bank Transaction Mapping

Charles asked 5 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?
 
Answers
Mark Anderson Staff answered 5 years ago
Please check out this link with the same error from our site and ensure you are following these steps.
 
http://www.eonesolutions.com/help-article/kba-01081-c2s6p5/
 
 
Charles replied 5 years ago

Mark,

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.