journal sequences by fiscal year

18 views
Skip to first unread message

Richard PALO

unread,
Apr 2, 2018, 12:43:38 PM4/2/18
to tryton
How to set sequences created for general journals to reset every fiscal year?
It appears even the Default Account Journal sequence is shared...

It is true that the posted move sequence and invoicing sequences are reset, but
any journal that touches the GL should be as well.
--

Richard PALO

Cédric Krier

unread,
Apr 2, 2018, 4:00:07 PM4/2/18
to tryton
On 2018-04-02 18:43, Richard PALO wrote:
> How to set sequences created for general journals to reset every fiscal year?

It is not possible.

> It is true that the posted move sequence and invoicing sequences are reset, but
> any journal that touches the GL should be as well.

Why?

--
Cédric Krier - B2CK SPRL
Email/Jabber: cedric...@b2ck.com
Tel: +32 472 54 46 59
Website: http://www.b2ck.com/

Richard PALO

unread,
Apr 3, 2018, 12:44:40 PM4/3/18
to try...@googlegroups.com
Le 02/04/2018 à 21:58, Cédric Krier a écrit :
> On 2018-04-02 18:43, Richard PALO wrote:
>> How to set sequences created for general journals to reset every fiscal year?
>
> It is not possible.
>
'not possible' is probably missing the adverb 'currently'

>> It is true that the posted move sequence and invoicing sequences are reset, but
>> any journal that touches the GL should be as well.
>
> Why?
>

Well, first off, history shows that many accounting systems permit such, and some
even do so automatically.

Secondly, it more closely respects the independence of fiscal years where currently
internal numbering of journal entries does not.

Finally, organisations have their internal procedures for verification/validation.

Example: journal 'OD' is a general journal for miscellaneous operations working on
finishing up 2017 while 2018 is rolling right along, the mixed numbering and/or holes may
make certain actors uneasy (namely the direction, public accountants and auditors).

Naturally, an organisation often frowns/balks on limitations migrating to a new system
in absence of very good and motivated reasoning.

Interestingly, article III.C.4 Avis CNC 174-1 - Les principes d'une comptabilité régulière
found in the site of the Belgian CNC http://www.cnc-cbn.be/files/advice/link/FR_174-01.htm
is quite similar to usages in France:
> Dans chaque journal, les écritures doivent être identifiées par un numéro séquentiel
> formant, le cas échéant par période comptable ou par exercice, une série continue.
Which quickly translated says that 'In each journal, the entries must be identified by a
sequential number forming a continuous series, either by accounting period or by fiscal year.'

--

Richard PALO

Cédric Krier

unread,
Apr 3, 2018, 12:55:06 PM4/3/18
to try...@googlegroups.com
On 2018-04-03 18:44, Richard PALO wrote:
> Interestingly, article III.C.4 Avis CNC 174-1 - Les principes d'une comptabilité régulière
> found in the site of the Belgian CNC http://www.cnc-cbn.be/files/advice/link/FR_174-01.htm
> is quite similar to usages in France:
> > Dans chaque journal, les écritures doivent être identifiées par un numéro séquentiel
> > formant, le cas échéant par période comptable ou par exercice, une série continue.
> Which quickly translated says that 'In each journal, the entries must be identified by a
> sequential number forming a continuous series, either by accounting period or by fiscal year.'

This ensured by the *Post Number* field.

Dominique Chabord

unread,
Apr 3, 2018, 1:05:10 PM4/3/18
to tryton
2018-04-03 18:44 GMT+02:00 Richard PALO <richar...@free.fr>:

>> Dans chaque journal, les écritures doivent être identifiées par un numéro
>> séquentiel
>> formant, le cas échéant par période comptable ou par exercice, une série
>> continue.
>
> Which quickly translated says that 'In each journal, the entries must be
> identified by a
> sequential number forming a continuous series, either by accounting period
> or by fiscal year.'
>

Personnaly, my translation of "le cas échéant", would be "optionaly"
and not "either".

Richard PALO

unread,
Apr 3, 2018, 1:18:20 PM4/3/18
to try...@googlegroups.com
Le 03/04/2018 à 18:54, Cédric Krier a écrit :
> On 2018-04-03 18:44, Richard PALO wrote:
>> Interestingly, article III.C.4 Avis CNC 174-1 - Les principes d'une comptabilité régulière
>> found in the site of the Belgian CNC http://www.cnc-cbn.be/files/advice/link/FR_174-01.htm
>> is quite similar to usages in France:
>>> Dans chaque journal, les écritures doivent être identifiées par un numéro séquentiel
>>> formant, le cas échéant par période comptable ou par exercice, une série continue.
>> Which quickly translated says that 'In each journal, the entries must be identified by a
>> sequential number forming a continuous series, either by accounting period or by fiscal year.'
>
> This ensured by the *Post Number* field.
>

Perhaps I missed something, since when is the *post number* journal-specific?

Until now I understood it to be cross-journal by fiscal year (as it is configured on the FY).

But the point is, at least in France, in mode 'brouillard', the number is consecutive upon initial entry.
Post number is consecutive upon validation(posting) which may be somewhat an arbitrary order.

--

Richard PALO

Richard PALO

unread,
Apr 3, 2018, 1:32:39 PM4/3/18
to try...@googlegroups.com
Hmm, I guess I simply used 'either' to mean 'where appropriate' or 'if need be':-)

--

Richard PALO

Cédric Krier

unread,
Apr 3, 2018, 5:50:07 PM4/3/18
to try...@googlegroups.com
On 2018-04-03 19:18, Richard PALO wrote:
> Le 03/04/2018 à 18:54, Cédric Krier a écrit :
> > On 2018-04-03 18:44, Richard PALO wrote:
> >> Interestingly, article III.C.4 Avis CNC 174-1 - Les principes d'une comptabilité régulière
> >> found in the site of the Belgian CNC http://www.cnc-cbn.be/files/advice/link/FR_174-01.htm
> >> is quite similar to usages in France:
> >>> Dans chaque journal, les écritures doivent être identifiées par un numéro séquentiel
> >>> formant, le cas échéant par période comptable ou par exercice, une série continue.
> >> Which quickly translated says that 'In each journal, the entries must be identified by a
> >> sequential number forming a continuous series, either by accounting period or by fiscal year.'
> >
> > This ensured by the *Post Number* field.
> >
>
> Perhaps I missed something, since when is the *post number* journal-specific?

It is not. I just point you that how this article is implemented.

> But the point is, at least in France, in mode 'brouillard', the number is consecutive upon initial entry.

I never see any where such requirement for draft accounting. And it is
quite logical because it would make loosing its meaning to draft
accounting.

> Post number is consecutive upon validation(posting) which may be somewhat an arbitrary order.

It is not arbitrary, it is chronological.
Reply all
Reply to author
Forward
0 new messages