Odoo Help


Static sales order address

Craig Pearson
on 7/16/13, 8:39 PM 1,278 views

Hey erpeople,

In OpenERP 7.0 I have a requirement in that I need the address on the sales order to not change even if the company or customer address changes over time.

For example, we create a sales order for customer A they have an address Aa, his address might get updated to Ab and now all sales orders, invoices, delivery orders etc linking that customer to the invoices are set to the customer address Ab. I need them to still be Aa.

Is there anyway to achieve this in the system, or should I start coding? I am pretty doubtful but thought I'd ask here anyways.


Did you want different company address or customer address?

on 7/17/13, 2:51 AM

What I really need is the orders and invoices linked to a static set of contact details. We are probably going to give Ray's suggestion below a go.

Craig Pearson
on 7/17/13, 3:16 AM

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 7/16/13, 9:16 PM

I haven't tried this, but one possible idea is:

For each company, create a contact called 'Company' which represents the current address.

Sales orders, etc would be for this 'contact' - showing up as 'OpenERP, Company' although OpenERP is still responsible for the purchases.

When you get a change of address for the company, rename 'Company' to 'Until July 2013' and mark it 'Inactive' so it only shows up on those historic documents as 'OpenERP, Until July 2013'. Create a new contact called 'Company' with the new address.

For each customer, just keep creating new addresses, making each old one 'Inactive' so these too only show up on historic documents.

This idea renders meaningless the address on a company, and requires you always sell to 'contacts'.

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

0 follower(s)


Asked: 7/16/13, 8:39 PM
Seen: 1278 times
Last updated: 3/16/15, 8:10 AM