Odoo Help


Bank statement import entry lines / credit

Robin Alexander Holm Pedersen
on 3/13/14, 10:58 AM 2,110 views

In standard bank statmenet import, when validating the import and after mapped up this fields:

  • Entry lines / effective date
  • Entry lines / name
  • Entry lines / credit
  • Journal
  • Entry lines / journal
  • Entry lines / period

I get this error on the credit field:

ascii new row for relation "account_move_line" violates check constraint "account_move_line_credit_debit2" DETAIL: Failing row contains (131, 1, 2014-03-13 13:51:39.703299, 2014-03-13 13:51:39.703299, 1, 104, 8, null, null, null, null, null, -11633.07, normal, 1, null, draft, 0.00, f, null, 422, 3, 2014-03-13, 2014-02-27, 89, Overførsel utland, null, null, null, null, null, 0.00, null). 328 329 ordinal not in range(128)

What does this error message mean?

Marc Cassuto
On 4/26/14, 8:32 AM

Hello Robin,

this constraint is defined as bellow : "account_move_line_credit_debit2" CHECK ((credit + debit) >= 0::numeric)

In general, having a negative amount in one of these 2 columns will raise the error...

Hope this will help, Marc

About This Community

This platform is for beginners and experts willing to share their Odoo knowledge. It's not a forum to discuss ideas, but a knowledge base of questions and their answers.


Odoo Training Center

Access to our E-learning platform and experience all Odoo Apps through learning videos, exercises and Quizz.

Test it now

Question tools

0 follower(s)


Asked: 3/13/14, 10:58 AM
Seen: 2110 times
Last updated: 3/16/15, 8:10 AM