Odoo Help

Welcome!

This community 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.

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 753 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

--Ray Carnes--
15687
| 9 7 9
Greater Los Angeles, United States
--Ray Carnes--

Senior Odoo Analyst

OpenERP 6.1, 7.0 and Odoo 8.0, 9.0 (Since 2012)

Completed Functional and Technical Training.

Major Skills:

  • Needs Discovery and Requirements Analysis;

  • Function and Technical Specifications;

  • Project Planning;

  • Prototyping and Proof of concepts;

  • Data migration;

  • Configuration & Customization (UI and modules);

  • Integration - data, business logic and service levels;

  • Training and Knowledge transfer;

  • Go Live support;

  • Help desk;

  • Version Migration.

I have over 20 years of experience empowering and enabling users with enterprise information systems that make a real and measurable difference in their ability to proactively manage their businesses and organizations. 

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

 

Your Answer

Please try to give a substantial answer. If you wanted to comment on the question or answer, just use the commenting tool. Please remember that you can always revise your answers - no need to answer the same question twice. Also, please don't forget to vote - it really helps to select the best questions and answers!

About This Community

This community is for professionals and enthusiasts of our products and services. Read Guidelines

Question tools

1 follower(s)

Stats

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