Hi, i am having this error when i trying to close a point of sale session:
The operation cannot be completed, probably due to the following:
- deletion: you may be trying to delete a record while other records still reference it
- creation/update: a mandatory field is not correctly set
[object with reference: account_id - account.id]
And in the log i can see:
2020-04-27 13:56:13,879 1 ERROR callejerosc odoo.sql_db: bad query: b'INSERT INTO "account_move_line" ("id", "reconciled", "tax_exigible", "account_id", "amount_currency", "debit", "date_maturity", "statement_line_id", "currency_id", "payment_id", "blocked", "credit", "name", "move_id", "partner_id", "create_uid", "write_uid", "create_date", "write_date") VALUES(nextval(\'account_move_line_id_seq\'), false, true, NULL, 0.0, 1050.0, \'2020-04-26\', 38, NULL, 384, false, 0.0, \'Callejero/0013: \', 388, NULL, 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 (779, Callejero/0013: , null, null, null, 1050.0, 0.0, null, null, null, null, 0.0, null, null, null, null, null, null, 388, null, 384, 38, null, f, null, null, f, 2020-04-26, null, null, null, null, null, null, null, t, 1, 2020-04-27 13:56:13.688416, 1, 2020-04-27 13:56:13.688416).
The error is with a specific order Callejero/0013, but when i see the order, everything looks fine.
Is anything else that should i look?
Thanks.