Siirry sisältöön
Sinun on rekisteröidyttävä, jotta voit olla vuorovaikutuksessa yhteisön kanssa.
Kaikki kirjoitukset Ihmiset Merkit
Tunnisteet (Näytä kaikki)
odoo accounting v14 pos v15
Tietoa tästä foorumista
Tämä kysymys on merkitty
sale.ordersequencenumberodoo11
2 Vastaukset
7443 Näkymät
Avatar
Robert Crowe

Odoo v11 Community

Sale Order Sequence Prefix: SO/%(range_y)s%(month)s

Sequence Size: 4

Use subsequences per date_range: True

Current Date: 04/08/2018

 When creating a new Sales Order and setting the order date (to say 07/6/17) I would expect the Order Reference Number to be "SO/17070001" but instead it's "SO/18040001" . Is there a way to change this or line of code to edit?

Looking back at Quotation section the Order Date set became the Quotation Date and the actual Order Date listed in Sales section shows the current date and time the Sales Order was created.

Avatar
Hylkää
Avatar
Robert Crowe
Tekijä Paras vastaus

The easiest work around I found is change the system date/time and make Odoo think it's the date wanted.

Avatar
Hylkää
Avatar
Avinash Nk
Paras vastaus

Hi, 

You can't make that by changing the sequence prefix from the UI. You need some customization here.

First  Make the Sale Order Sequence Prefix back to 'SO' (By Default by Odoo).

Then try this code in your custom module.

class SaleOrder(models.Model):
    _inherit = 'sale.order'

    @api.model
    def create(self, vals):
        res = super(SaleOrder, self).create(vals)
        order_date = res.date_order
        sequence = res.name
        res.name = 'SO' + '/' + order_date[2:4] + order_date[5:7] + sequence[2:]
        return res

Thank you.

Avatar
Hylkää
Aiheeseen liittyviä artikkeleita Vastaukset Näkymät Toimenpide
How to increment sequence number with respect to month and year - Odoo 11 Ratkaistu
sequencenumber odoo11
Avatar
Avatar
Avatar
2
toukok. 24
9291
how to increment year in sequence number with respect to financial year - Odoo 11
year sequencenumber odoo11
Avatar
Avatar
1
huhtik. 22
8684
How to set different sequence number in sale order according to branches in a company in Odoo 11 Ratkaistu
sequencenumber odoo11 odoo11community
Avatar
Avatar
1
syysk. 20
7176
Odoo API (Pass Sale Order Values Through API)
api sale.order odoo11
Avatar
0
maalisk. 19
3753
How does vals.get('xxx','yyy') work? Ratkaistu
sequence sale.order sequencenumber
Avatar
Avatar
Avatar
2
syysk. 17
22441