Odoo Help

Welcome!

This community 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.

0

Bank statement import entry lines / credit

By
Robin Alexander Holm Pedersen
on 3/13/14, 10:58 AM 1,582 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?

0

Marc Cassuto

--Marc Cassuto--
815
| 4 4 8
Montreal, Canada
--Marc Cassuto--


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

Your Answer

Please try to give a substantial answer. If you wanted to comment on the question or answer, just use the commenting tool. Please remember that you can always revise your answers - no need to answer the same question twice. Also, please don't forget to vote - it really helps to select the best questions and answers!

About This Community

This community is for professionals and enthusiasts of our products and services. Read Guidelines

Question tools

0 follower(s)

Stats

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