We have been using auto numbering for our purchase orders. One data inputter accidently put in the supplier invoice number instead. Now the auto numbering is about 20,000 higher as all new PO's are auto numbered after this higher number. How can we reset the auto numbering for PO's to a lower number? I tried making a dummy PO with a lower number, but the auto numbering just continues with the much higher number.
Thanks for you help! Jane
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: modify> We have been using auto numbering for our purchase orders. One data inputter
Matt,
Thanks for your reply. The RMS staff gave me the SQL commands to renumber and I renumbered the 50+ that had been done incorrectly.
Jane
"Matt Hurst" wrote:
Have something to add? Share your thoughts — no account required.
Ask the community — no account required