This is a regex that can include all the following capture groups: prefix1, year, prefix2, month, prefix3, seq, suffix. The prefix* groups are the separators between the year, month and the actual increasing sequence number (seq). e.g: Starting Sequence : INV2301001 Refund Starting Sequence : RINV2301001 Sequence Override Regex : (?P[A-Z]{1,})(?P\d{2})(?P\d{2})(?P\d{3,}) This expressions defines the following invoice numbering scheme : INVYYMMSSS whereby SSS will restart at 001 on a monthly basi

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

All apps

Wszystkie posty Osoby Odznaki

Tagi (Zobacz wszystko)

odoo accounting v14 pos v15

O tym forum

Pomoc

ODOO15 CE : REGEX - Customise Journal Entry Numbering

journal regex v15

1 Odpowiedz

2994 Widoki

Boujraf Youssef

This is a regex that can include all the following capture groups: prefix1, year, prefix2, month, prefix3, seq, suffix.

The prefix* groups are the separators between the year, month and the actual increasing sequence number (seq).

e.g:

Starting Sequence : INV2301001
Refund Starting Sequence : RINV2301001
Sequence Override Regex : (?P[A-Z]{1,})(?P\d{2})(?P\d{2})(?P\d{3,})

This expressions defines the following invoice numbering scheme : INVYYMMSSS whereby SSS will restart at 001 on a monthly basis.

This will result in the following invoice number for e.g. the third invoice of Februari 2023 : INV2302003

Now, I 'd like to modify my REGEX with this rule :

The expression defines the following invoice numbering scheme : INVYYYYSSS whereby SSS will restart at 001 the 1 april of the next year AND from the 1 january 2024 including 31 march 2024 the YYYY needs to be YYYY-1.

Start Sequence : 1 april 2023
End Sequence : 31 march 2024

The result is :

1 april 2023 - INV2023001 - YYYY = 2023 and SSS = 001
20 december 2023 - INV2023158 - YYYY = 2023 and SSS = 158
5 january 2024 - INV2023159 - YYYY = 2023 and SSS = 159
31 march 2024 - INV2023230 - YYYY = 2023 and SSS = 230
1 april 2024 - INV2024001 - YYYY = 2024 and SSS = 001
...

?? Sequence Override Regex : ?

Best Regards, Youssef

shubham shiroya

To modify the regular expression (regex) to include the rule for the invoice numbering scheme you described, you can use the following expression in Python:

import re

sequence_override_regex = r"(?P[A-Z]{1,})(?P20(?:2[3-9]|3[0-9])|(?:20)?24)(?P\d{2})(?P(?:(?:0[1-9])|(?:1[0-2])))(?P\d{3})(?P)"

# Test the regex with the example inputs
sequence = "INV2301001"
matches = re.match(sequence_override_regex, sequence)
if matches:
    prefix1 = matches.group("prefix1")
    year = matches.group("year")
    prefix2 = matches.group("prefix2")
    month = matches.group("month")
    prefix3 = matches.group("prefix3")
    seq = matches.group("seq")
    suffix = matches.group("suffix")
 
    # Modify the year value according to the rule
    if int(month) >= 4:
        year = str(int(year) - 1)

    # Print the modified values
    print(f"Modified Year: {year}")
    print(f"Prefix1: {prefix1}")
    print(f"Prefix2: {prefix2}")
    print(f"Month: {month}")
    print(f"Prefix3: {prefix3}")
    print(f"Sequence: {seq}")
    print(f"Suffix: {suffix}")
else:
    print("No match found for the sequence.")

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ę

Powiązane posty	Odpowiedzi	Widoki
Journal change after post Rozwiązane journal enterprise change v15	3 gru 24	12117
Odoo15 how to update credit and debit of journal entry on multi currency accounting journal journal_entry v15	1 lis 23	3651
Cant install Accounting - No journal could be found in company for any of those types: general accounting journal v15 Apps	1 sty 24	10595
Closing POS session - Odoo 15 accounting pos journal v15	1 mar 22	6129
Prevent navigation if records are not save v15	2 paź 25	3520

To pytanie dostało ostrzeżenie

Podoba Ci się ta dyskusja? Dołącz do niej!