Odoo Help


Create a relation between project and sale

Francesco OpenCode
on 2/19/13, 2:15 PM 4,145 views

There is a module that create a relation between project and sale orders?

What do you want to do with your relation?

Bonnet Denis
on 3/20/13, 1:06 PM

What is the nature of relation you wish to build with your tables, although there are three types of relations we can create in openerp with any two tables

Abhishek H Menon
on 9/11/13, 9:43 AM
On 9/10/13, 8:24 AM

You can connect may sales order to one analytic account wich is a contract for a project. See this https://accounts.openerp.com/forum/Help-1/question/24081


Ray Carnes

--Ray Carnes--
| 9 7 9
Keyport, United States
--Ray Carnes--

Senior ERP Analyst

OpenERP 6.1, 7.0; Odoo 8.0, 9.0, 10.0 and 11.0.

Completed Odoo Functional and Technical Training.

Functional Areas:

  • CRM/Sales

  • Inventory

  • Manufacturing

  • Accounting

  • Purchasing

Major Skills:

  • Business Process Reengineering

  • Efficiency Consulting

  • User Needs and GAP Analysis;

  • Functional and Technical Design;

  • Prototyping and Proof of Concepts;

  • Requirements Specifications;

  • Agile Implementation;

  • Data Migration;

  • Configuration & Customization (UI and code);

  • Integration - Odoo and non Odoo Applications and Services;

  • Training and Knowledge Transfer;

  • Go Live Support;

  • Helpdesk;

  • Version Upgrades and Migration.

  • Accounting Expert.

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. 

I am a skilled Communicator and I only take the serious things seriously!

Ray Carnes
On 2/19/13, 10:29 PM

The project_mrp module creates tasks on a project for a Sales Order with a compatible contract assigned to it.

"This module is used to automatically create tasks based on different procurements: sales order, manufacturing order, etc. It is mainly used to invoices services based on tasks automatically created by sales orders."

This is also available with version 7.0.

It can be found in the list of modules to install (ie: already comes with the software).

This module it's not for my problem. I need just a relaton field (like o2m) to connect a project to various sale order.

Francesco OpenCode
on 2/20/13, 4:14 AM
Abhishek H Menon
On 9/11/13, 9:59 AM
    from osv import fields,osv
class first_model(osv.osv):

class second_model(osv.osv):
    _columns= {

for creating a one2many field you have to create a many2one inverse relationship, thats why there in the second_model, a many2onefield is defined. And you should follow the order of definitions of both tables and you will get the result

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.


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)


Asked: 2/19/13, 2:15 PM
Seen: 4145 times
Last updated: 3/16/15, 8:10 AM