Making Items Inactive

Posted by jocelynp on October 18, 2006, 2:27 pm

Please log in for more thread options

v1.3

I would like to create a script that will turn store created items inactive,
however, I do not know the script numbers (if that is even proper
terminology...?) = inactive. Is there one?

I would like to do something to set all location's items to inactive where
the hqid = 0.
--
Jocelyn

Posted by cod on October 18, 2006, 2:58 pm

Please log in for more thread options

jocelynp wrote:

> v1.3

> I would like to create a script that will turn store created items inactive,

> however, I do not know the script numbers (if that is even proper

> terminology...?) = inactive. Is there one?

> I would like to do something to set all location's items to inactive where

> the hqid = 0.

/* The field Inactive is disabled or Inactive?? */

UPDATE Item SET [FIELD] = 1 WHERE HQID = 0

and with trigger..

CREATE TRIGGER tr_Item ON ITEM AFTER INSERT, UPDATE
AS

UPDATE Item SET [FIELD] = 1 WHERE ID IN (SELECT ID FROM inserted)

cod

Posted by Nashat on October 19, 2006, 5:58 am

Please log in for more thread options

cod,

your trigger will make all items inactive ever they were created in HQ, u
mist check the HQID in your trigger

> jocelynp wrote:

>> v1.3

>> I would like to create a script that will turn store created items

>> inactive, however, I do not know the script numbers (if that is even

>> proper terminology...?) = inactive. Is there one? I would like to do

>> something to set all location's items to inactive where the hqid = 0.

> /* The field Inactive is disabled or Inactive?? */

> UPDATE Item SET [FIELD] = 1 WHERE HQID = 0

> and with trigger..

> CREATE TRIGGER tr_Item ON ITEM AFTER INSERT, UPDATE

> AS

> UPDATE Item SET [FIELD] = 1 WHERE ID IN (SELECT ID FROM inserted)

> cod

Posted by jocelynp on October 19, 2006, 11:02 am

Please log in for more thread options

Nashat,
Can you clearly explain this to me? We need to issue a statement to make all
items that were created locally at the stores inactive. We will be pumping
them up with a new database from HQ. These locations got a little out of hand
and began creating their own items, now we need to bring them back to being
run solely from HQ. I get the SQL and the Ids, but; triggers, no idea.
--
Jocelyn

"Nashat" wrote:

> cod,

> your trigger will make all items inactive ever they were created in HQ, u

> mist check the HQID in your trigger

> > jocelynp wrote:

> >> v1.3

> >>

> >> I would like to create a script that will turn store created items

> >> inactive, however, I do not know the script numbers (if that is even

> >> proper terminology...?) = inactive. Is there one? I would like to do

> >> something to set all location's items to inactive where the hqid = 0.

> >

> > /* The field Inactive is disabled or Inactive?? */

> >

> > UPDATE Item SET [FIELD] = 1 WHERE HQID = 0

> >

> > and with trigger..

> >

> > CREATE TRIGGER tr_Item ON ITEM AFTER INSERT, UPDATE

> > AS

> >

> > UPDATE Item SET [FIELD] = 1 WHERE ID IN (SELECT ID FROM inserted)

> >

> > cod

> >

Posted by Jeff on October 19, 2006, 5:09 pm

Please log in for more thread options

: quoted-printable

Jocelyn,

You probably don't want to use the trigger, just run this in a 51 or =
manually;

UPDATE Item SET Inactive =3D 1, DoNotOrder =3D 1 WHERE HQID =3D 0

This will set ALL items that do not have an HQ ID number to Inactive and =
cannot be placed on a PO.

As always, BACKUP FIRST!!

Next, you should set security so that the stores cannot add items if you =
want to control this, otherwise keep this script handy! ;-)

--=20
*
Get Secure! - www.microsoft.com/security

You must be using Outlook Express or some other type of newsgroup reader =
to
see and download the file attachment. 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

**********

Nashat,=20
Can you clearly explain this to me? We need to issue a statement to =
make all=20
items that were created locally at the stores inactive. We will be =
pumping=20
them up with a new database from HQ. These locations got a little out =
of hand=20
and began creating their own items, now we need to bring them back to =
being=20
run solely from HQ. I get the SQL and the Ids, but; triggers, no idea. =

--=20
Jocelyn

"Nashat" wrote:

> cod,
>=20
> your trigger will make all items inactive ever they were created in =
HQ, u=20
> mist check the HQID in your trigger
>=20
> > jocelynp wrote:
> >> v1.3
> >>
> >> I would like to create a script that will turn store created =
items=20
> >> inactive, however, I do not know the script numbers (if that is =
even=20
> >> proper terminology...?) =3D inactive. Is there one? I would like =
to do=20
> >> something to set all location's items to inactive where the hqid =
=3D 0.
> >
> > /* The field Inactive is disabled or Inactive?? */
> >
> > UPDATE Item SET [FIELD] =3D 1 WHERE HQID =3D 0
> >
> > and with trigger..
> >
> > CREATE TRIGGER tr_Item ON ITEM AFTER INSERT, UPDATE
> > AS
> >
> > UPDATE Item SET [FIELD] =3D 1 WHERE ID IN (SELECT ID FROM =
inserted)
> >
> > cod
> >
> >=20
>=20
>=20
>
------=_NextPart_000_03D7_01C6F388.2CF31DB0
Content-Type: text/html;
charset="utf-8"
Content-Transfer-Encoding: quoted-printable

=EF=BB=BF<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META http-equiv=3DContent-Type content=3D"text/html; charset=3Dutf-8">
<META content=3D"MSHTML 6.00.2900.2963" name=3DGENERATOR>
<STYLE></STYLE>
</HEAD>
<BODY bgColor=3D#ffffff>
<DIV><FONT color=3D#008000>Jocelyn,</FONT></DIV>
<DIV><FONT color=3D#008000></FONT> </DIV>
<DIV><FONT color=3D#008000>You probably don't want to use the trigger, =
just run=20
this in a 51 or manually;</FONT></DIV>
<DIV><FONT color=3D#008000></FONT> </DIV>
<DIV> UPDATE Item SET Inactive =3D 1, DoNotOrder =3D =
1 WHERE HQID =3D=20
0<BR></DIV>
<DIV><FONT color=3D#008000>This will set ALL items that do not have an =
HQ ID=20
number to Inactive and cannot be placed on a PO.</FONT></DIV>
<DIV><FONT color=3D#008000></FONT> </DIV>
<DIV><FONT color=3D#008000>As always, BACKUP FIRST!!</FONT></DIV>
<DIV><FONT color=3D#008000></FONT> </DIV>
<DIV><FONT color=3D#008000>Next, you should set security so that =
the stores=20
cannot add items if you want to control this, otherwise keep this script =
handy!=20
;-)</FONT></DIV>
<DIV><BR>-- <BR>*<BR>Get Secure! - <A=20
href=3D"http://www.microsoft.com/security">www.microsoft.com/security</A>=
</DIV>
<DIV> </DIV>
<DIV>You must be using Outlook Express or some other type of newsgroup =
reader=20
to<BR>see and download the file attachment.  If you are not using a =
reader,=20
follow<BR>the link below to setup Outlook Express.  Click on "Open =
with=20
newsreader"<BR>under the MS Retail Management System on the right.</DIV>
<DIV> </DIV>
<DIV><A =
href=3D"http://tinyurl.com/75bgz">http://tinyurl.com/75bgz</A></DIV>
<DIV> </DIV>
<DIV>**********<BR></DIV>
<BLOCKQUOTE=20
style=3D"PADDING-RIGHT: 0px; PADDING-LEFT: 5px; MARGIN-LEFT: 5px; =
BORDER-LEFT: #008000 2px solid; MARGIN-RIGHT: 0px">
<DIV>"jocelynp" <<A=20
=
icrosoft.com</A>>=20
wrote in message <A=20
=
5961A-8A91-4D08-B1D1-9E808A2AA99D@microsoft.com</A>...</DIV>Nashat,=20
<BR>Can you clearly explain this to me? We need to issue a statement =
to make=20
all <BR>items that were created locally at the stores inactive. We =
will be=20
pumping <BR>them up with a new database from HQ. These locations got a =
little=20
out of hand <BR>and began creating their own items, now we need to =
bring them=20
back to being <BR>run solely from HQ. I get the SQL and the Ids, but;=20
triggers, no idea. <BR>-- <BR>Jocelyn<BR><BR><BR>"Nashat" =
wrote:<BR><BR>>=20
cod,<BR>> <BR>> your trigger will make all items inactive ever =
they were=20
created in HQ, u <BR>> mist check the HQID in your trigger<BR>> =
<BR>>=20
"cod" <<A =
in message <BR>> <A=20
=
K2MSFTNGP05.phx.gbl</A>...<BR>>=20
> jocelynp wrote:<BR>> >> v1.3<BR>> >><BR>> =
>> I=20
would like to create a script that will turn store created items =
<BR>>=20
>> inactive, however, I do not know the script numbers (if that =
is even=20
<BR>> >> proper terminology...?) =3D inactive. Is there one? =
I would=20
like to do <BR>> >> something to set all location's items to =
inactive=20
where the hqid =3D 0.<BR>> ><BR>> > /* The field Inactive =
is=20
disabled or Inactive?? */<BR>> ><BR>> > UPDATE Item SET =
[FIELD] =3D=20
1 WHERE HQID =3D 0<BR>> ><BR>> > and with =
trigger..<BR>>=20
><BR>> > CREATE TRIGGER tr_Item ON ITEM AFTER INSERT, =
UPDATE<BR>>=20
> AS<BR>> ><BR>> > UPDATE Item SET [FIELD] =3D 1 WHERE =
ID IN=20
(SELECT ID FROM inserted)<BR>> ><BR>> > cod<BR>> =
><BR>>=20
> <BR>> <BR>> <BR>></BLOCKQUOTE></BODY></HTML>

------=