Odoo is the world's easiest all-in-one management software.
It includes hundreds of business apps:

CRM
e-Commerce
Contabilitate
Inventar
PoS
Proiect
MRP

All apps

All Posts Oameni Insigne

Etichete (View all)

odoo accounting v14 pos v15

Despre acest forum

Suport

How to modify existing sequence parameters?

sequence account.invoice numbering

2 Răspunsuri

18096 Vizualizări

Anabela Damas

Hi,

I'm trying to change the sequences from delivery orders, invoices, refunds . It's easy by the interface, but I need this changes in code for all my installations to have all the same sequence, and to avoid to configure everything in each installation and have the risk to forget of something.

For the example of account.invoice, I need to change the padding, and the prefix from :

            <field name="prefix">SAJ/%(year)s/</field>
            <field name="padding">4</field>

to :

            <field name="prefix">SAJ/%(year)s</field>
            <field name="padding">6</field>

The prefix without the last "/" and instead of "4" in padding have "6".

I want to do this configurations in my new module but I don't know how to change this to parameters from existing sequences?

Thanks in advance!

Simplify it!

On this case if you want to overwrite it you have to follow the following steps:

add account to dependencies on your module (__openerp__.py)
Look for the original code, in this case: (/account/data/account_data.xml)
Copy the entire record that you want to change and paste it on your module
Add the module name of the module account on your module (change sequence_sale_journal -> account.sequence_sale_journal)
Modify what you need to modify
Install your module

Account module

 <record id="sequence_sale_journal"
 model="ir.sequence">
             <field name="name">Account Default Sales Journal</field>
             <field eval="3" name="padding"/>
             <field name="prefix">SAJ/%(year)s/</field>
         </record>

Your module

<record id="account.sequence_sale_journal" model="ir.sequence">
            <field name="name">Account Default Sales Journal</field>
            <field eval="6" name="padding"/>
            <field name="prefix">SAJ/%(year)s/</field>
        </record>

Anabela Damas

Autor

Doesn't work! I did everything that you say but the first invoice has this : SAJ/2013/0001.

Simplify it!

Did you create the invoice before installing my code?

Anabela Damas

Autor

No! First I install the module then create the invoice, but sequences are still the same way.

Alessandro Ruffolo

It works when the module is first installed, not if I update it later on

PT SIVI

Just simply

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

Find Sales Order

Anabela Damas

Autor

I want by programing...

Enjoying the discussion? Don't just read, join in!

Create an account today to enjoy exclusive features and engage with our awesome community!

Înscrie-te

Related Posts	Răspunsuri	Vizualizări
How to initialize the invoice sequence number every month ? v7 sequence account.invoice	3 dec. 23	8169
How to change the behavior of bank statement line numbering? sequence bank_statement numbering	0 iun. 15	6137
Manufactoring order sequence? mrp sequence numbering	3 mar. 15	8914
v 10: numbering sequence of invoices interrupted sequence invoicing numbering jumps	0 iun. 21	2335
Related fields from sales orders in accounting invoices account.invoice	0 mar. 25	1698

Această întrebare a fost marcată

Enjoying the discussion? Don't just read, join in!