Hi, I am not sure what cud be the reason but one behaviour of number sequences i know is that when ever a number sequences is freed or cleaned it is sent to Number sequence list (can be viewed from Basic -> setup -> Number sequences -> Number sequences -> List button) and next time when you create a new record this number sequence is picked up instead of the next that is expected. i guess this feature was brought in to re-use the freed number sequences.
So you cannot totally say that number sequences should be sorted based on the dates. Regards, Sumit On Fri, Sep 5, 2008 at 1:14 PM, Syner P <[EMAIL PROTECTED]> wrote: > Hi, > > We have a strange problem which occurs rarely. It happens when people key > in sales orders and send to production. > > We expect to have the production numbers should be in order with created > date in ProdTable. But as mentioned sometimes the system mixes them. Example > : > > > ProdNum Created Date > pr-567 03.09.2008 > pr-568 03.09.2008 > pr-569 03.09.2008 > pr-570 04.09.2008 *** > pr-571 03.09.2008 > pr-572 03.09.2008 > pr-573 03.09.2008 > > As seen the number sequence order according to date is not correct. And I > check the date setup of workstations and there is no problem. > > Any explanation will be appreciated. > > > Regards, > Syner > > >