Skip to Content
Menu
This question has been flagged
1 Reply
7155 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?

Avatar
Discard
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
Related Posts Replies Views Activity
3
Jul 25
2093
3
Jun 25
3559
1
Apr 25
1570
1
Apr 25
1325
0
Oct 24
1279