I've been trying unsuccessfully for some time to import a "Receipts" from csv file but keep getting a NULL error:
null value in column "name" violates not-null constraint DETAIL: Failing row contains (65, null, 10, 1, 2019-09-28 16:16:29.134301, 2019-09-28 16:16:29, 1, 2019-09-28 16:16:29, 693, null, 0.000, null, null, 8, 12, null, 72, null, draft, null, null, make_to_stock, f, null, null, t, null, null, null, null, null, f, null, null, 2, 2, 2019-09-28 16:16:29.134301, f, null, null, null, null). at row 2
I have tried creating a dummy stock move to export the template to use as a reference to import with but regardless of how many fields I attempt to import, I can get past this NULL error.
Name |
location_dest_id/id |
location_id/id |
move_lines/move_line_ids/product_id |
move_lines/quantity_done |
picking_type_id/id |
Picking type name |
sequence_id |
Code |
Test |
stock.stock_location_stock |
stock.stock_location_suppliers |
Terracotta Flower Pot 13cm |
50 |
stock.picking_type_in |
receipts |
My Company, Chicago Sequence in |
Vendor |
Can someone help me with a template so that I can import products from stock.stock_location_suppliers to stock.stock_location_stock using .csv?