Technical mailing list archives


Re: Odoo CE v11 error.

- 2018年09月04日 10時39分42秒

Check accounts for product category of products that was sold by POS or accounts of  journals cash , you must link them by accounts

On 29 Aug 2018 22:28, "Joseph" <> wrote:
Doing some POS testing with Odoo when I close a session (POS) and post entries, I often get an error. 

The log reports. 

2018-08-25 19:21:09,745 675 ERROR odoo odoo.sql_db: bad query: b'INSERT INTO "account_move_line" ("id", "move_id", "statement_line_id", "reconciled", "name", "tax_exigible", "currency_id", "date_maturity", "debit", "payment_id", "amount_currency", "partner_id", "account_id", "credit", "blocked", "create_uid", "write_uid", "create_date", "write_date") VALUES(nextval(\'account_move_line_id_seq\'), 1215, 688, false, \'Cash Register/0248: \', true, NULL, \'2018-08-25\', 10.7, 1075, 0.0, NULL, NULL, 0.0, false, 1, 1, (now() at time zone \'UTC\'), (now() at time zone \'UTC\')) RETURNING id'
ERROR: null value in column "account_id" violates not-null constraint
DETAIL:  Failing row contains (2667, Cash Register/0248: , null, null, null, 10.7, 0.0, null, null, null, null, 0.0, null, null, null, null, null, null, 1215, null, 1075, 688, null, f, null, null, f, 2018-08-25, null, null, null, null, null, null, null, t, 1, 2018-08-25 19:20:11.446311, 1, 2018-08-25 19:20:11.446311).

I can tell that in SQL we are trying to update a table with account_id = NULL; and that violates the table setting. 

So I ask, is there a "default" cash account_id that Odoo POS uses? I can't figure out why this occurs... 

Post to: