I'm trying to import customer invoice with the template I've received with an export.
Here is my xls file :
partner_id/id __export__.res_partner_403
payment_term_id/id account.account_payment_term_net
invoice_line_ids/quantity 95
invoice_line_ids/product_id/id __export__.product_product_3380_27c18c87
invoice_line_ids/id __export__.account_invoice_line_36206_0837b668
name période test 5
I'm able to create a new invoice with it but with the field invoice_line_ids/id that use an existing id, it overwrites an existing invoice.
When I use the same file without importing invoice_line_ids/id, I get this error message: null value in column "name" violates not-null constraint DETAIL: Failing row contains (36221, 58, 2019-08-22 10:05:16.037967, 2019-08-22 10:05:16.037967, 58, null, null, null, null, 14877, null, null, null, null, 0.00, null, null, 3380, 10, 95.000, null, null, null, null, f, null). à la ligne 2
What is wrong in the file ? How can I import a new invoice ?