Ir al contenido
Menú
Se marcó esta pregunta
1 Responder
7154 Vistas

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
Descartar
Mejor respuesta

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
Descartar
Publicaciones relacionadas Respuestas Vistas Actividad
3
jul 25
2087
3
jun 25
3556
1
abr 25
1567
1
abr 25
1324
0
oct 24
1277