Skip to Content
Meniu
Trebuie să fiți înregistrat pentru a interacționa cu comunitatea.
Această întrebare a fost marcată
3 Răspunsuri
8273 Vizualizări

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?

Imagine profil
Abandonează
Autor Cel mai bun răspuns

So, I think the issue was that I was trying to import Quantity Done, rather than Initial Quantity.

This is what I used to import the transfer:

picking_type_id/id

location_id/id

location_dest_id/id

Stock Moves/Product

Stock Moves/Description

Stock Moves/Initial Demand

Stock Moves/Unit of Measure

stock.picking_type_in

stock.stock_location_suppliers

stock.stock_location_stock

Terracotta Flower Pot 13cm

Terracotta Flower Pot 13cm

50

Unit(s)


Imagine profil
Abandonează
Cel mai bun răspuns

do you have the updated template for V16?

Imagine profil
Abandonează
Cel mai bun răspuns

How can you import "Receipt". What menu are you using?

I am trying to do the same in Odoo 13 CE


Imagine profil
Abandonează
Related Posts Răspunsuri Vizualizări Activitate
4
dec. 22
7136
1
iul. 24
2098
1
sept. 23
3423
6
mai 24
21590
0
mar. 23
1916