This has been already dicussed many times. You may find information using
MarMail or Nable, some threads are even very detailled
Good luck
Jacques
From: "Deyan Tsvetanov" <[email protected]>
Exactly, I knew I've seen it somewhere :)
"Enforced Sequence (no gaps, per organization)"
Thanks guys,
I'll have a look at it.
Another question: do you have any idea how this enforced sequence might
behave in case of two ofbiz servers - in a cluster or sharing a
database ?
My goal is to generate IDs without absolutely any gaps.
Another very important requirement is that the order of the record's
CREATED_DATE should match the order of the IDs. It is not possible to go
back and fill a gap.
Example:
A good example:
ID | CREATED_DATE
---------------------------------------------
1 | 1 June 9:00 AM
2 | 1 June 10:00 AM
A bad example:
ID | CREATED_DATE
---------------------------------------------
1 | 1 June 10:00 AM
2 | 1 June 9:00 AM
I already have an idea of a workaround,
but I'll investigate the enforced sequence first.
Thanks again,
Deyan
On Sat, 2009-06-13 at 05:42 -0700, BJ Freeman wrote:
Organization GL Settings >Available Internal
Organizations>Company>Setup>Accounting Preferences
David E Jones sent the following on 6/13/2009 5:15 AM:
>
> Take a look at the party/organization accounting preferences in the
> Accounting Manager. If you're looking for this sort of sequencing for
> invoices, orders, etc then it is already supported.
>
> -David
>
>
> On Jun 13, 2009, at 5:44 AM, Deyan Tsvetanov wrote:
>
>> Hi list,
>>
>> I'd like to use a custom ID generator - for instance rather to start
>> from 10000 and increment by 10 I'd like to start from 0, increment by 1
>> leaving no empty values and probably append some other rules - like to
>> reset to 0 in the beginning of each year and prefix the returned ID by
>> the current year.
>>
>> Example:
>>
>> 200900001
>> 200900002
>> ....
>> 200932110
>> ....
>> 201000001 <--- a new year starts.
>>
>> I know it may sound pretty dumb, but the law makers in some countries
>> are not so smart.
>>
>> So - could somebody give me some hints - is it possible to specify a
>> custom ID generator per field typed "id-ne" in the entitymodel.xml ?
>>
>> Thanks in advance,
>> Deyan
>>
>
>
