PO Auto Numbering

the auto-numbering does not continue from the last entry, it queries the current maximum numeric entry of your existing po's and increments from there, so the only way to 'reset' the count is to remove, renumber, or rename the old series.

see my previous post on that subject:

the interface uses a function that increments from the max numeric ponumber in the table with something like this: select max(ponumber)+1 from purchaseorder where isnumeric(ponumber)=1

One way you could fix this is to renumber the accidental series with a query like: update purchaseorder set ponumber=ponumber-20000 where isnumeric(ponumber)=1 and ponumber>20000

Or you could change that series to non-numeric by adding an alpha character: update purchaseorder set ponumber=ponumber+'a' where isnumeric(ponumber)=1 and ponumber>20000

Or you could just live with the new higher ponumbers.

disclaimer: modifying your table like this is a bit drastic, so you should take precautions to avoid unwanted results: backup your database, use select query statements before the update to make sure this will change it to what you want, if you are not familiar with directly modifying your tables you should get help, etc.

"Jas> We have been using auto numbering for our purchase orders. But we have found