Odoo Help

1

How can I change sequence prefix between quotation and sale order?

By
Bonnet Denis
on 6/24/13, 8:31 AM 5,185 views

Is it possible to change prefix of sequence number according to the state field?

I use a DV prefix for quotation ("Devis") and a BDC prefix for sale order("Bon de Commande") with EBP.

But how can I do the same with OpenERP? When the state is changed into "manual" how can I create a sale order with the right prefix?

4

Francesco OpenCode

--Francesco OpenCode--
3638
| 5 7 9
Grottaglie, Italy
--Francesco OpenCode--

Italian Odoo (OpenERP) Modules Developer LINKEDIN: http://www.linkedin.com/in/francescoapruzzese

Francesco OpenCode
On 6/24/13, 8:46 AM

Actually this isn't possibile. If you want do this, you must create a module that override the functin trigged when the order change status and write the number yourself.

2
PT SIVI
On 12/27/13, 4:05 AM

Go to Setting->Technical->Sequence and Identifiers->Sequences

Find Sales Order

0

Ray Carnes

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

Senior Odoo Analyst

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

Completed Odoo Functional and Technical Training.

Major Skills:

  • 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 12/30/13, 4:53 AM

See "Sale Quotation Numeration" at https://www.openerp.com/apps/7.0/sale_quotation_number/

Sale Quotation: Sale process in draft stage just informing prices and element of communication. Sale Order: Sale process confirmed, the customer already have a compromise with us in terms of pay an invoice and receive our product or service.

Originally OpenERP manage only 1 sequence for this 2 documents, then the sales order won and lost manage the same sequence losting almost all lost quotations in terms of sequences, making so difficult understand qith a quick view if we are good or bad in terms of logistic and sale process already confirmed.

Technical Explanation:

When you create a quotation, it is numbered using the 'sale.quotation' sequence. When you confirm a quotation, its orginal number is saved in the 'origin' field and the sale order gets a new number, retrieving it from 'sale.order' sequence.

With Openerp Base.

Sale Quotation 1 Number = SO001 Sale Quotation 2 Number = SO002 Sale Quotation 3 Number = SO003 Sale Quotation 4 Number = SO004

Sale Quotation 2 Confirmed = Number for Sale Order SO004

With Openerp + This Module.

Sale Quotation 1 Number = SQ001 Sale Quotation 2 Number = SQ002 Sale Quotation 3 Number = SQ003 Sale Quotation 4 Number = SQ004

Sale Quotation 2 Confirmed = Number for Sale Order SO001 from Sale Quotation SQ002

Sale Quotation 1 Confirmed = Number for Sale Order SO002 from Sale Quotation SQ001

Sale Quotation 4 Confirmed = Number for Sale Order SO003 from Sale Quotation SQ004

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

0 follower(s)

Stats

Asked: 6/24/13, 8:31 AM
Seen: 5185 times
Last updated: 9/22/15, 4:41 AM