Import RFQ V13

Question

theres its a way that i can import a rfq succesfully i get this error.

new row for relation "purchase_order_line" violates check constraint "purchase_order_line_accountable_required_fields" DETAIL: Failing row contains (1923, JARRON CON CARA DE CERÁMICA DE 6" BLANCO H5.59L5.12W4.92, 10, 18.000, null, 2022-07-30 04:00:00, null, 13084, 377.30, null, null, null, 5415, null, null, null, null, null, null, null, null, null, null, 2, 2022-07-30 16:48:43.795982, 2, 2022-07-30 16:48:43.795982, null, nul

CandidRoot Solutions Private Limited · Answer

Hello Marco Guridi
There is a sql constraints written in purchase module for puchase_order_line model as below.
display_type, product_id, product_uom and date_planned is not null. you can import data along with those fields and value to avoid this error.
_sql_constraints = [
( 'accountable_required_fields' ,
"CHECK(display_type IS NOT NULL OR (product_id IS NOT NULL AND product_uom IS NOT NULL AND date_planned IS NOT NULL))" ,
"Missing required fields on accountable purchase order line." )] Than

Related Posts	Replies	Views
Import user group fails with No matching records found for name importing importerror	0 Jun 24	656
Odoo 14: Purchase Order Receipt Date updated by vendor online issue.... purchase_order RFQ v14	1 Oct 22	2563
[V13] Odoo Server Error in Purchase app error purchase_order v13	1 Feb 21	1543
Import invoices: associate each invoice with purchase order references invoice purchase_order importing	0 May 20	2577
Importing Purchase Order from another system import purchase_order importing	2 Mar 15	6408

This question has been flagged

CandidRoot Solutions Pvt. Ltd.

Enjoying the discussion? Don't just read, join in!