This question has been flagged
1 Reply
1967 Views
purchase_orderimportingimporterrorv13RFQ
Avatar
Marco Guridi

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, null, null, t, null, null).

and when that error doesn't show, theres other about a name line its missing


Avatar
Discard
Avatar
CandidRoot Solutions Private Limited
Best 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.")]

Thanks & Regards,

​

CandidRoot Solutions Pvt. Ltd.

Mobile: (+91) 8849036209
Email: info@candidroot.com
Skype: live:candidroot
Web: https://www.candidroot.com
Address: 1229-1230, Iconic Shyamal, Near Shyamal Cross Road, Ahmedabad, Gujarat 380015
    

Avatar
Discard