İçereği Atla
Bu soru işaretlendi
5 Cevaplar
1930 Görünümler
Avatar
Dritero Mehmetaj

Hi, I'd like to have custom invoice numbering, like YYMMDDNNN, with NNN being sequence number and it should reset each day.


Thank you

Avatar
Vazgeç
Dritero Mehmetaj
Üretici

Dear Niyas,

thank you for your answer. Re-sequencing works for already existing invoices and i need to change the logic for future ones as well, based on the principle I've shared.

Niyas Raphy (Walnut Software Solutions)

if you adjust the existing, it is expected to work for new also

Avatar
JB
En İyi Yanıt

Hello,


Follow these steps to resequence invoice numbers:

  1. Activate the developer mode.
  2. From the Accounting Dashboard, open the Customer Invoices journal.
  3. Select the invoices that need a new sequence.
  4. Click the  Actions menu and select Resequence.
  5. In the Ordering field, choose to
    • Keep current order: The order of the numbers remains the same.
    • Reorder by accounting date: The number is reordered by accounting date.
  6. Set the First New Sequence.
  7. Preview Modifications and click Confirm.
Avatar
Vazgeç
Avatar
Niyas Raphy (Walnut Software Solutions)
En İyi Yanıt

Hi,
Using re-sequence option in the action menu of invoice in debug mode, you can re-sequence the entries, before applying in the live, ensure in staging/test.

Thanks

Avatar
Vazgeç
Avatar
Cybrosys Techno Solutions Pvt.Ltd
En İyi Yanıt

Hi,

Please refer to the following links:

1. https://www.odoo.com/documentation/18.0/applications/finance/accounting/customer_invoices/sequence.html


Hope it helps.

Avatar
Vazgeç
Avatar
Pavithra
En İyi Yanıt

If you want to update the sequence for the future records alone, you can follow below steps:

1. In the recently created invoice, click "reset to draft" (for eg: i have clicked "reset to draft" button in INV/2025/00015)

2. Then the generated sequence will become editable, you can enter the sequence no. there, as you want (eg: changed INV/2025/00015 as INV/2025/00050) and confirm the invoice

3. In the further creating invoice, it will generate the invoice no. as (INV/2025/00051)


Hope it is helpful!!

Avatar
Vazgeç
Avatar
otis5842
En İyi Yanıt

You can achieve the YYMMDDNNN invoice numbering with daily resets in Odoo 18 by:

  1. Configuring a sequence with prefix %(y)s%(month)s%(day)s and three-digit padding.
  2. Using an Automated Action for daily resets (simpler, Odoo Online-friendly) or a custom module for full control (Odoo.sh/on-premise).
  3. Testing thoroughly to ensure compliance and reliability.

Avatar
Vazgeç