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

Hi, I´m trying do import purchase orders from another system to OpenERP v7.0, but, everytime I have a different error. I´m trying to import with this data fields:

Destination Warehouse 
Order Lines/Quantity (I think it´s quantity of the product)
Order Lines/Analytic Account
Order Lines/ Unit Price (I think it´s unit price of the produtct)
Supplier/ External ID (I imported supplier from another system too)
External ID
Product/External ID
Destination (OpenERP requires a destination field, I give 1 value to every line in this field, i tried a lot of values (stock, default, location and many more)
PriceList (OpenERP requires a Pricelist field, I give 1 value to every line in this field)

It doesn´t work. What fields I should I import?

Imagine profil
Abandonează

The error message is usually quite clear. May be you should paste your messages here, this will help people answering your question.

Autor

This is the error message I received on validation

No matching record found for name '1' in field 'Destination' at row 2 Get all possible values (821 more)

No matching record found for name '1' in field 'Pricelist' at row 2 Get all possible values (821 more)

Missing required value for the field 'location_id'. This might be 'Destination' in the current model, or a field of the same name in an o2m. at row 2 (626 more)

Cel mai bun răspuns

May you can be more productive if you use some ETL tool, if there are too many data.

Regards,

Imagine profil
Abandonează
Autor

I never used, wich one you recommend ?

Yep! Talend is a good choice.

Cel mai bun răspuns

OpenERP cannot relate the data from your file with the one in OpenERP.

You should export a Purchase Order with the fields you want to import to figure out which data you need to put in your file and how to format it.

Imagine profil
Abandonează
Autor

I did that, but I don´t need destination and Price List, so, if I don´t import that, OpenERP says this fields are required. If I just copy Destination and Price List from Export file, many other errors with location_id occurs.

Can you post the error message when you set the Destination and Price list?

Autor

I did again, export a Purchase made on the system, got Destination database Id and Price List databse Id from the export, set that on my import, and receive this message:

"current transaction is aborted, commands ignored until end of transaction block"

I don´t know what can be

Can you provide more info from the log ?

Related Posts Răspunsuri Vizualizări Activitate
1
nov. 24
1522
4
nov. 18
8133
0
mar. 15
4123
1
mar. 15
4269
1
iul. 24
1618