This question has been flagged
1 Reply
6239 Views
bank_statementimporting
Avatar
Robin Alexander Holm Pedersen

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?

Avatar
Discard
Avatar
Marc Cassuto
Best Answer

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

Avatar
Discard