Importing Purchase Order from another system

Odoo is the world's easiest all-in-one management software.
It includes hundreds of business apps:

CRM
e-Commerce
Accounting
Inventory
PoS
Project management
MRP

Take the tour

Posts People Badges

Tags View all

odoo accounting v7 pos invoice

About this forum

Help

Importing Purchase Order from another system

2 Replies

6133 Views

import purchase_order importing

Renato Ferreira

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?

Fabien Pinckaers (fp)

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

Renato Ferreira

Author

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)

Sandro Regis

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

Regards,

Renato Ferreira

Author

I never used, wich one you recommend ?

Maxime Chambreuil

Talend http://www.talend.com

Sandro Regis

Yep! Talend is a good choice.

Maxime Chambreuil

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.

Renato Ferreira

Author

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.

Maxime Chambreuil

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

Renato Ferreira

Author

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

Maxime Chambreuil

Can you provide more info from the log ?

This question has been flagged