Přejít na obsah
Menu
You need to be registered to interact with the community.
This question has been flagged
2 Odpovědi
7316 Zobrazení

I create this sequence:

sequence.py

    def create(self, cr, uid, vals, context={}):
        vals['code'] = self.pool.get('ir.sequence').get(cr, uid, 'res.partner')
        res = super(client_sequence, self).create(cr, uid, vals, context)
        return res

    _columns = {
        'code': fields.char('Code client', size=64, readonly=True),
}
    _defaults = {
        'code': lambda obj, cr, uid, context: '/',
    }

sequence.xml

<record model="ir.sequence.type" id="seqe_type_res_partner">
    <field name="name">Client code</field>
    <field name="code">res.partner</field>
</record>
<record model="ir.sequence" id="seqe_res_partner">
    <field name="name">client code</field>
    <field name="code">res.partner</field>
    <field name="prefix">CLT</field>
    <field name="padding">5</field>
    <field name="number_increment">1</field>
</record>

But the code is incremented by 3 instead of 1?? any help?

Avatar
Zrušit
Nejlepší odpověď

The sequence is loaded with 001 by using _defaults and then when you use ORM create method, the sequence goes to 002 and then for your super client sequence the sequence is incremented once again so 003.

If you remove the 'code' in _defaults, the n number of times the window refreshes the value is not incremented by sequence.

In my case, I was trying to auto-generate account number using sequence and i tried using create and _defaults, so whenever the page is loaded it provides 70000001 and when the save button is clicked it goes to 70000002. so my records of account number generated were only even numbers.

Avatar
Zrušit
Nejlepší odpověď

Your

<field name="number_increment">1</field>

Must be

<field name="number_increment">3</field>

Or try this code:

def create(self, cr, uid, vals, context={}):
        vals['code'] = self.pool.get('ir.sequence').next_by_code(cr, uid, 'seqe_res_partner', context=None)
        res = super(client_sequence, self).create(cr, uid, vals, context)
        return res
Avatar
Zrušit
Autor

No Francesco, I want to increment the code by 1 but I have this result : CLT/00001, CLT00003, CLT/00006...I don't no why??

Are you sure you are calling the right sequence?

Autor

Here the code in front of you.. did I call the right sequence?

I've updated my answer...try the new code.

Autor

have this erreur :

    AttributeError: 'ir.sequence' object has no attribute 'next_by_code'
Autor

I dont understand your modification, I think if I'm missing calling the right sequence I would not have the correct prefix and padding...

If you go in the settings menu and select the sequence can you see the increment value setted with 1?

Autor

yes the increment value = 1

Autor

I modify this value to 2 but still have the increment by 3 ?!!!!!

Related Posts Odpovědi Zobrazení Aktivita
3
čvc 23
67966
0
úno 23
5074
0
led 23
94
1
říj 22
4341
0
dub 22
2881