Purchase Order automatic number sequence

Posted by blueindian on October 28, 2009, 5:17 pm

Please log in for more thread options

Somehow one of my employees has inadvertantly change the sequence of the
automated purchase order numbers. The sequence matches too closely with
another locations number sequence. How can I alter or set a new number
sequence to stop this.
--
blueindian

Posted by Jeff @ Check Point Software on October 30, 2009, 3:22 pm

Please log in for more thread options

: quoted-printable

Blueindian,

You will have to change it with a SQL script.

Make a note of the PO number you wish to change.

Make a backup!

Instructions for a Single store operation;

Go into SO Administrator | File | Connect | put in your password | Query =
| New and type the following;

UPDATE PurchaseOrder SET PONumber =3D xxx WHERE PONumber =3D yyy AND =
POType =3D 0=20
xxx is the new number yyy is the old one

--=20

Jeff=20
Check Point Software

Search this newsgroup -- http://tinyurl.com/2lmk4w (Stolen from DRS)
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D

You must be using Outlook Express/Windows Mail or some other type of =
newsgroup reader to
see and download the file attachment(s). If you are not using a reader, =
follow
the link below to setup Outlook Express. Click on "Open with =
newsreader"
under the MS Retail Management System on the right.

http://tinyurl.com/75bgz
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D

Somehow one of my employees has inadvertantly change the sequence of =
the=20
automated purchase order numbers. The sequence matches too closely =
with=20
another locations number sequence. How can I alter or set a new =
number=20
sequence to stop this. =20
--=20
blueindian
------=_NextPart_000_0198_01CA595B.A8CB1D20
Content-Type: text/html;
charset="utf-8"
Content-Transfer-Encoding: quoted-printable

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META content=3Dtext/html;charset=3Dutf-8 http-equiv=3DContent-Type>
<META name=3DGENERATOR content=3D"MSHTML 8.00.6001.18828"></HEAD>
<BODY style=3D"PADDING-LEFT: 10px; PADDING-RIGHT: 10px; PADDING-TOP: =
15px"=20
id=3DMailContainerBody leftMargin=3D0 topMargin=3D0 =
CanvasTabStop=3D"true"=20
name=3D"Compose message area">
<DIV><FONT color=3D#008000>Blueindian,</FONT></DIV>
<DIV><FONT color=3D#008000></FONT> </DIV>
<DIV><FONT color=3D#008000>You will have to change it with a SQL=20
script.</FONT></DIV>
<DIV><FONT color=3D#008000></FONT> </DIV>
<DIV><FONT color=3D#008000>Make a note of the PO number you wish to=20
change.</FONT></DIV>
<DIV><FONT color=3D#008000></FONT> </DIV>
<DIV><FONT color=3D#008000>Make a backup!</FONT></DIV>
<DIV><FONT color=3D#008000></FONT> </DIV>
<DIV><FONT color=3D#008000>Instructions for a Single store =
operation;</FONT></DIV>
<DIV><FONT color=3D#008000></FONT> </DIV>
<DIV><FONT color=3D#008000>Go into SO Administrator | File | Connect | =
put in your=20
password | Query | New and type the following;</FONT></DIV>
<DIV><FONT color=3D#008000></FONT> </DIV>
<DIV><FONT color=3D#008000>UPDATE PurchaseOrder SET PONumber =3D xxx =
WHERE PONumber=20
=3D yyy AND POType =3D 0 </FONT></DIV>
<DIV><FONT color=3D#008000>xxx is the new number yyy is the old =
one</FONT></DIV>
<DIV><BR>-- <BR><BR>Jeff <BR>Check Point Software</DIV>
<DIV> </DIV>
<DIV>Search this newsgroup -- <A=20
title=3D"http://tinyurl.com/2lmk4w
CTRL + Click to follow link"=20
href=3D"http://tinyurl.com/2lmk4w">http://tinyurl.com/2lmk4w</A>  =
(Stolen=20
from =
DRS)<BR>=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D=3D=3D=3D</DIV>
<DIV> </DIV>
<DIV>You must be using Outlook Express/Windows Mail or some other type =
of=20
newsgroup reader to<BR>see and download the file attachment(s).  If =
you are=20
not using a reader, follow<BR>the link below to setup Outlook =
Express. =20
Click on "Open with newsreader"<BR>under the MS Retail Management System =
on the=20
right.</DIV>
<DIV><FONT color=3D#008000></FONT> </DIV>
<DIV><A=20
href=3D"http://tinyurl.com/75bgz">http://tinyurl.com/75bgz</A><BR>=3D=3D=3D=
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
</DIV>
<DIV> </DIV>
<DIV> </DIV>
<BLOCKQUOTE=20
style=3D"BORDER-LEFT: #008000 2px solid; PADDING-LEFT: 5px; =
PADDING-RIGHT: 0px; MARGIN-LEFT: 5px; MARGIN-RIGHT: 0px">
<DIV>"blueindian" <<A=20
=
ns.microsoft.com</A>>=20
wrote in message <A=20
=
E1371-BF2F-4355-A5E5-172D58EBE639@microsoft.com</A>...</DIV>Somehow=20
one of my employees has inadvertantly change the sequence of the =
<BR>automated=20
purchase order numbers.  The sequence matches too closely with=20
<BR>another locations number sequence.  How can I alter or set a =
new=20
number <BR>sequence to stop this.  <BR>--=20
<BR>blueindian</BLOCKQUOTE></BODY></HTML>

------=