Skip to Content
Menu
This question has been flagged
6 Replies
28991 Rodiniai

I want change Invoice Sequence number in ver14,  How can access it in version 14. in ver13 I can access via technical>sequences but in ver14 I don't invoice option in list. where can I locate it?

Portretas
Atmesti
Best Answer

Hi,

By default in odoo14, if you need to change the sequence of the invoice, you can go to the invoice tree view and select all the records(if you need to re-sequence all the records).



Once you click on the Re-sequence, you will get the below wizard,




If you need same as in odoo13, see this module in the odoo app store: https://apps.odoo.com/apps/modules/14.0/od_journal_sequence/


Thanks

Portretas
Atmesti
Autorius

Thanks, that's really helpful.

Hello, May I ask, how to change the sequence for date? I want to change with this format INV/%(range_year)s/%(month)s/%(day)s/. But in Odoo 14 with feature "Resequence" can only changes the last number? How to change Year/Month/Day?

Best Answer

Hi,

There is no sequence record for invoice is present in Odoo V14.Some custom modules are available for the same.

Eg:

https://apps.odoo.com/apps/modules/14.0/journal_sequence/

Regards

Portretas
Atmesti

Hey ! Where in the Odoo14 documentation - and link if possible - did you find the answer? I am new around here and trying to figure out where to find the whole documentation about modules. Thanks !

Hello, I need help with something specific for sequence numbers of invoices. By default, when I create a regular invoice from sales order it gives me the sequence : INV/0001 (for example). What I need is when creating an invoice from sales order and choosing the option (Down payment), I need the sequence number to be different such as: DWN/0001. Is there a module that can help me achieve that or a piece of code? Thanks

Best Answer

The invoice sequence is missing on the menu Technical/Sequences. When you create the first invoice, odoo shows an editable default sequence "INV/YEAR/0001", so you can custom the format and the next invoices you make will keep your format. It worked to me.

Portretas
Atmesti
Best Answer

So, in Odoo 14 Community I just found that a "-SQ" was being added to the end of my Invoices.  That was not desired or intended.

After looking for an Invoice Sequencing control and not finding the way I have found to set in Sales Order..  I read the above posts but did not see a solution.

I tried then the following and found it solved the issue.
Arguably a new issue but related:

1:  Create a Test Invoice (test customer)

2:  Confirm the invoice

​the "-SQ" was added again.
3:  Revert the Invoice to Draft

4: Edit the Invoice number, removing the "-SQ"

5:  Confirm the invoice again

6:  Create a new (2nd) Draft Invoice

7:  Confirm the 2nd Draft Invoice
​I found that the "-SQ" was no longer in the invoice number and it was based upon date (INV/YEAR/MO/SERIES)

This can likely still be controlled somewhere.  For instance, putting a Day code in there before the series, for example.

Anyway, my problem went away by "revert to draft", "edit", then "confirm" on a test invoice, and testing on a second test invoice as stated above.

Portretas
Atmesti
Best Answer

The invoice sequence from version 14 onwards is dynamic.

You can modify it directly in a draft invoice. Odoo detects directly the dynamic fields "Year" "Month".



 


Portretas
Atmesti
Best Answer

I try to use re sequence and put E001-0001 and the system set E020-0001, why??

Portretas
Atmesti
Related Posts Replies Rodiniai Veikla
2
bal. 23
8552
0
rugs. 24
1189
1
bal. 24
1536
2
kov. 24
2681
3
spal. 23
7844