Version 6 purging of data and next numbers

According to the data dictionary viewer in V8, The order number field
is up to a 9 digit number....

--- In vantage@yahoogroups.com, "turnerco1960" <jeffturner06@...>
wrote:
>
> We are on version 6, planning to upgrade to version 8 next year.
>
> Right now, our highest sales order number is 870126. The max value
> is 999999. Based on the rate of new orders, we will reach the max
> value of 999999 sometime next year.
>
> Talking to vantage support, it seems there is no data purge
> functionality in version 6 and the support person said she would
have
> to see if there was any way to purge data in version 8. Obviously,
> one would purge old data to free up next numbers.
>
> Otherwise, the only thing she offered was having them do custom
> programming to purge data in order to avoid duplicate key issues
when
> the sales order number reaches it maximum.
>
> What have other companies done to purge data, without damaging
> database key integrity, or to resolve the assignment of maximum
next
> number values?
>
> Thanks in advance for any help in this matter.
>
> Jeff Turner
> jturner@...
>
We are on version 6, planning to upgrade to version 8 next year.

Right now, our highest sales order number is 870126. The max value
is 999999. Based on the rate of new orders, we will reach the max
value of 999999 sometime next year.

Talking to vantage support, it seems there is no data purge
functionality in version 6 and the support person said she would have
to see if there was any way to purge data in version 8. Obviously,
one would purge old data to free up next numbers.

Otherwise, the only thing she offered was having them do custom
programming to purge data in order to avoid duplicate key issues when
the sales order number reaches it maximum.

What have other companies done to purge data, without damaging
database key integrity, or to resolve the assignment of maximum next
number values?

Thanks in advance for any help in this matter.

Jeff Turner
jturner@...