import template

Question

Hello
I am trying to import quotations and sales order in the sale app every time I load the file i got this error as below
new row for relation "sale_order_line" violates check constraint "sale_order_line_accountable_required_fields" DETAIL: Failing row contains (17, 61, KIT, SEAL & GASKET, 10, no, 0.00, null, null, null, null, null, null, 0.00, null, 1.000, null, null, 0.000, 0.000, null, null, null, null, null, null, null, null, null, null, draft, 0, null, 2, 2020-03-05 12:35:00.863795, 2, 20

Thuy Ngoc · Answer

Hi
Abdulmonem,
I think this video can help you: https://www.youtube.com/watch?v=UOBxxnYDIsM&list=PLSKcWRTtEl5qzvRaI-VTGavfReiHS_EEb&index=1 (starting at minute 55 in this video)

Cybrosys Techno Solutions Pvt.Ltd · Answer

Hi,
Refer the app:
https://apps.odoo.com/apps/modules/16.0/import_template_download/ [1]
Hope it helps
This application allows you to download the import template for sales

[1] https://apps.odoo.com/apps/modules/16.0/import_template_download/

Abdulmonem · Answer

Hi Paresh,
Thank you for your response I have export one quotation  also then use it as import template  but other error appear to me also
Missing required value for the field 'product_id'   at row 2 (S00047)
Best Regards
Abdulmonem

Paresh Wagh · Answer

Hi Abdul:
It looks like the Accounting related information is missing in your data file. The fastest way to identify this information would be to manually create one order and export it to a importable csv file. You can then create your template based on the exported csv file.
You can find more information about the import/export functionality at the following link.
https://www.odoo.com/documentation/user/13.0/general/base_import/adapt_template.html

This question has been flagged

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