Bỏ qua để đến Nội dung
Menu
Câu hỏi này đã bị gắn cờ
2 Trả lời
7447 Lượt xem

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?

Ảnh đại diện
Huỷ bỏ

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

Tác giả

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)

Câu trả lời hay nhất

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

Regards,

Ảnh đại diện
Huỷ bỏ
Tác giả

I never used, wich one you recommend ?

Yep! Talend is a good choice.

Câu trả lời hay nhất

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.

Ảnh đại diện
Huỷ bỏ
Tác giả

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?

Tác giả

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 ?

Bài viết liên quan Trả lời Lượt xem Hoạt động
1
thg 11 24
1684
4
thg 11 18
8256
0
thg 3 15
4260
1
thg 3 15
4446
1
thg 7 24
1756