Hi, I'd like to have custom invoice numbering, like YYMMDDNNN, with NNN being sequence number and it should reset each day.
Thank you
Odoo is the world's easiest all-in-one management software.
It includes hundreds of business apps:
- CRM
- e-Commerce
- Księgowość
- Zapasy
- PoS
- Projekt
- MRP
To pytanie dostało ostrzeżenie
5
Odpowiedzi
2260
Widoki
Hello,
Follow these steps to resequence invoice numbers:
- Activate the developer mode.
- From the Accounting Dashboard, open the Customer Invoices journal.
- Select the invoices that need a new sequence.
- Click the Actions menu and select Resequence.
- 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.
- Set the First New Sequence.
- Preview Modifications and click Confirm.
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
Hi,
Please refer to the following links:
Hope it helps.
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!!
You can achieve the YYMMDDNNN invoice numbering with daily resets in Odoo 18 by:
- Configuring a sequence with prefix %(y)s%(month)s%(day)s and three-digit padding.
- Using an Automated Action for daily resets (simpler, Odoo Online-friendly) or a custom module for full control (Odoo.sh/on-premise).
- Testing thoroughly to ensure compliance and reliability.
Podoba Ci się ta dyskusja? Dołącz do niej!
Stwórz konto dzisiaj, aby cieszyć się ekskluzywnymi funkcjami i wchodzić w interakcje z naszą wspaniałą społecznością!
Zarejestruj się
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.
if you adjust the existing, it is expected to work for new also