This question has been flagged

Could someone help me solve this problem? Thank you very much in advance.


When I try to 'Mark as done' a Manufacturing Order a window appears that does not let me proceed and with the following warning:

The operation cannot be completed:

- Create/update: a mandatory field is not set.
- Delete: another model requires the record being deleted. If possible, archive it instead.

Model: Journal Entry (account.move), Field: Status (state)


The log information is that:

2023-03-18 17:24:01,954 2301727 ERROR SenoriodeBocos odoo.sql_db: bad query: INSERT INTO "account_move" ("id", "create_uid", "create_date", "write_uid", "write_date", "auto_post", "company_id", "currency_id", "date", "invoice_incoterm_id", "invoice_user_id", "is_move_sent", "journal_id", "move_type", "not_in_mod347", "ref", "state", "stock_move_id", "team_id", "to_check") VALUES (nextval('account_move_id_seq'), 1, (now() at time zone 'UTC'), 1, (now() at time zone 'UTC'), false, 1, 1, '2023-03-18', NULL, 1, false, 8, 'entry', false, 'ZA/ET/FA/23/0002 - Vino Tinto TVZ Reserva 2017 (Jaulón)', NULL, 6361, 1, false) RETURNING id
ERROR: null value in column "state" of relation "account_move" violates not-null constraint
DETAIL: Failing row contains (1144, null, null, 2023-03-18, ZA/ET/FA/23/0002 - Vino Tinto TVZ Reserva 2017 (Jaulón), null, null, null, entry, f, 8, 1, 1, null, null, f, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, f, null, null, 1, null, null, null, null, null, null, null, null, null, null, null, null, null, null, 1, 2023-03-18 17:24:01.698129, 1, 2023-03-18 17:24:01.698129, null, null, null, null, 1, null, 6361, null, null, null, null, null, null, null, null, null, null, f, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null). 

Avatar
Discard