Problem Description
When closing a POS session in Odoo 17 Community, I consistently encounter a foreign key constraint violation error on the account_bank_statement_line table. The system attempts to insert rows using payment record IDs as partner IDs.
Error Message
ERROR: An insert or update on table "account_bank_statement_line" violates the foreign key
constraint "account_bank_statement_line_partner_id_fkey"
DETAIL: Key (partner_id)=(211) is not present in table "res_partner".
Problematic SQL Query
INSERT INTO "account_bank_statement_line"
("amount", "create_date", "create_uid", "move_id", "partner_id", "payment_ref", "sequence", "write_date", "write_uid")
VALUES
(50.0, '2025-03-17 11:46:13.066248', 2, 2050, 213, 'Payment: 50.0', 1, '2025-03-17 11:46:13.066248', 2),
(246.96, '2025-03-17 11:46:13.066248', 2, 2051, 212, 'Payment: 246.96', 1, '2025-03-17 11:46:13.066248', 2),
(99.96, '2025-03-17 11:46:13.066248', 2, 2052, 211, 'Payment: 99.96', 1, '2025-03-17 11:46:13.066248', 2),
(246.96, '2025-03-17 11:46:13.066248', 2, 2053, 206, 'Payment: 246.96', 1, '2025-03-17 11:46:13.066248', 2)
RETURNING "id"
Problem Analysis
I discovered that the partner_id values (213, 212, 211, 206) in this query exactly match the record IDs in the pos_payment table associated with this POS session.
Expected Behavior
The system should use the partner_id from the associated POS orders (pos_order.partner_id) or NULL if no partner is specified, not the payment record IDs.
Environment
- Odoo version: 17.0 Community
- Installation type: On premise
- Operating system: Linux
Question
Is this a known bug in Odoo 17 Community? Is there a solution or patch available?
Thank you for your help.
