scheme – REGEX : Customise Journal Entry Numbering

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

Read more here: Source link