This question has been flagged

I would like to make the invoices and by sequences under year AND month, just by setting up at the sequences under Settings => Sequences & Identifiers.

Can you please teach me how to set the sequences as expected?

== Example ==

Invoice Date: Dec 2016: INV-201612-001, INV-201612-002, etc

Invoice Date: Jan 2017: INV-201701-001, INV-201701-002, INV-201701-003, etc

== Setting 1 ==

Prefix: INV-%(range_year)s%(range_month)s-

Sequence Size = 3

Use subsequences per date_range = TRUE 

== Result 1 ==

Created an invoice dated on Dec 30, 2016, the Invoice number generated as "INV/201601/001", and the table of subsequences created a line between 1/1/2016 to 12/31/2016, and next number as 2

== Setting 2 ==

Prefix: INV-%(year)s%(range_month)s-

Sequence Size = 3

Use subsequences per date_range = TRUE

== Result 2 ==

Created an invoice dated on Mar 3, 2017, the Invoice number generated as "INV/201701/001", and the table of subsequences created a line between 1/1/2017 to 12/31/2017, and next number as 2

Many Thanks!

Avatar
Discard
Author

Unable to edit! 403 – Forbidden!

The page you were looking for could not be authorized.

Maybe you were looking for one of these popular pages ?

I am on V9, and the Sequences in Feb 2017 is expected to be INV-201702-001, INV-201702-002, INV-201702-003

If it is used in between jan to dec.Then how can I implement in april to march

Best Answer

INV-%(year)s%(month)s-

Avatar
Discard
Best Answer

It is because You are using 'range_' prefix. 

It always use begining of range.

Avatar
Discard
Best Answer


Try to write like this INV-%(year)s%(month)s- or INV-%(range_year)s%(month)s- don't put range_ at the ''month''

It should work, it was the case with me !!


Avatar
Discard