PO Auto Numbering

We have been using auto numbering for our purchase orders. But we have found when we create a PO base on sales for a supplier we get (example PO #

0000431) and when we create a Blank PO we get (example PO # 9999587). When the RMS Manager informs us that the PO number is RMS will create one for you. How can we reset the auto numbering for PO's to a lower number for blank POs? I tried making a dummy PO with a lower number, but the auto numbering just continues with the much higher number.
Reply to
Jasoncleme
Loading thread data ...

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

Reply to
Matt Hurst

BeanSmart website is not affiliated with any of the manufacturers or service providers discussed here. All logos and trade names are the property of their respective owners.