This question has been flagged

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.


Avatar
Discard
Best Answer

Hi,

Please check your account configuration of accounting tab inside product.

Thanks

Aswini iWesabe 

Avatar
Discard
Author

Hi Aswini,

In the product, is that in the Invoicing tab? because accounting tab is not showing...

Author Best Answer

Hi Aswini,

In the product, is that in the Invoicing tab? because accounting tab is not showing...

Avatar
Discard