Odoo Help

0

Which value do I need to use for the field name if I am importing a sales quotation? OpenERP is demanding a name field to import a sales quotation

By
Cano
on 9/10/14, 4:05 PM 941 views

I like to export a sales quotation and modify the quantities. OpenERp is demanding valöue for name and suggesting to use "order reference" for the field name. I did it but despite that I got the error below

Missing required value for the field 'name'. This might be 'Order Reference' in the current model, or a field of the same name in an o2m.

0
Cano
On 9/11/14, 1:10 PM

Hi 

thanks for the support. I exported a sales quotation - with all requiered field. Import works. But as soon ad to the import product quantity and id fields ERP asks for a name field. Strange. 

Previous import without product quantity and id fields works 

0
Ray Carnes
On 9/10/14, 6:58 PM

Export a Sales Quotation that is already created and see how it exports to learn the field names and which ones are required and optional.  You also need a 'name' for every line in the quote - do you have that information also?

(From the help on the Import page):

If you want to import sales order having several order lines; for each order line, you need to reserve a specific row in the CSV file. The first order line will be imported on the same row as the information relative to order. Any additional lines will need an addtional row that does not have any information in the fields relative to the order.

As an example, here is sample CSV file of some quotations you can import, based on demo data.

"Order Reference","Supplier","Destination","Pricelist","Order Lines / Product","Order Lines / Quantity"
"PO000020","ASUSTeK","Stock","Default Purchase Pricelist","ADPT",20
,,,,"CARD",30
,,,,"C-Case",40
"PO000021","Axelor","Stock","Default Purchase Pricelist","CD",5
,,,,"CPUa8",15

 

About This Community

This platform is for beginners and experts willing to share their Odoo knowledge. It's not a forum to discuss ideas, but a knowledge base of questions and their answers.

Register

Odoo Training Center

Access to our E-learning platform and experience all Odoo Apps through learning videos, exercises and Quizz.

Test it now

Question tools

1 follower(s)

Stats

Asked: 9/10/14, 4:05 PM
Seen: 941 times
Last updated: 3/16/15, 8:10 AM