Passa al contenuto
Menu
È necessario essere registrati per interagire con la community.
La domanda è stata contrassegnata
3 Risposte
8421 Visualizzazioni

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?

Avatar
Abbandona
Autore Risposta migliore

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)


Avatar
Abbandona
Risposta migliore

do you have the updated template for V16?

Avatar
Abbandona
Risposta migliore

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

I am trying to do the same in Odoo 13 CE


Avatar
Abbandona
Post correlati Risposte Visualizzazioni Attività
4
dic 22
7261
1
lug 24
2247
1
set 23
3596
6
mag 24
21750
0
mar 23
1998