It all depends on the number that you have changed the value to and if
there are any transactions that meet the criteria.
For example if you have changed the parameter value to 10000 and there
aren't any transactions that are over 10,000 days old then the system
will not purge data.
Depending upon your companies archiving and purging policies, when most
of my clients are setting purge criteria in SYS800 the most common value
that I have seen I in my experience is about 2 years worth if
transactions or 730 days.
If I can be of any further assistance please contact me directly.
Thanks
-----Original Message-----
From: bpcs-l-bounces+dsweeney=phoenixbcinc.com@xxxxxxxxxxxx
[mailto:bpcs-l-bounces+dsweeney=phoenixbcinc.com@xxxxxxxxxxxx] On Behalf
Of Bonus Matt
Sent: Friday, February 06, 2009 10:55 AM
To: bpcs-l@xxxxxxxxxxxx
Subject: Re: [BPCS-L] Sequence Number
Dan:
I have changed the Parameters in the System Parameters to not all 9's
but the system never purged the data from ITH. Do you know why? I am
on 4.05CD.
Matthew Bonus
Truarc Company LLC
----------------------------------------------------------------------
message: 1
date: Fri, 6 Feb 2009 14:03:14 +0000
from: colin clement <colin.clement@xxxxxxxxxxx>
subject: Re: [BPCS-L] Sequence Number
In our system we have many items that do not beging with 1 and we see no
problem in inv300 although we are running version 3.1.
Do you know the BPCS program to reset the sequence numbers, it may be
worth us running it.
Colin C> To: bpcs-l@xxxxxxxxxxxx> From: Phil.Catlin@xxxxxxxxxxx> Date:
Fri, 6 Feb 2009 08:34:55 -0500> Subject: Re: [BPCS-L] Sequence Number> >
Also...> > If the sequence number for an item doesn't start with 1 and
run > sequentially, the results in INV300 (History) will be
unpredictable, and > probably incomplete.> **CAUTION**> Purging the ITH
is not a trivial exercise that can be done with an SQL > delete
statement! Use the BPCS supplied program, or find someone who has >
worked with this file before!> > Phil C> > > > >
Norman.Boyd@xxxxxxxxxxxxxxxxx > Sent by:
bpcs-l-bounces+phil.catlin=formica.com@xxxxxxxxxxxx> 02/06/2009 08:28
AM> Please respond to> BPCS ERP System <bpcs-l@xxxxxxxxxxxx>> > > To>
BPCS ERP System <bpcs-l@xxxxxxxxxxxx>> cc> > Subject> Re: [BPCS-L]
Sequence Number> > > > > > > The last sequence number is also tracked in
the item master file (iim). > I'm not too familiar with the function
differences between the versions of > > BPCS but, if your ITH file is g!
etting too large, are you not running the > Month End Close in the
inventory module, INV903 on the screen, INV900 > batch program? This
will move records from the ITH to the YTH file, > keeping ITH smaller
and all of your inventory transactions intact. If you > > have any sort
of auditing procedures, internal or external, you probably > don't want
to delete inventory transaction records. You'll also want to > check
your system setup(SYS800, Transaction History System Parameters - >
SYS824) before running the INV900 as it may be running for quite some >
time, especially if you haven't run it in the past.> > Norman K. Boyd>
MIS Administrator> Showa Aluminum Corp. of America> Phone: (740)
869-5007> Cell: (740) 572-7876> Fax: (740) 869-3309> > CONFIDENTIALITY
NOTICE: This e-mail message is intended only for the > person or entity
to which it is addressed and may contain confidential > and/or
privileged material. Any unauthorized review, use, disclosure or >
distribution is proh!
ibited. If you are not the intended recipient, please > contact the
sender by reply e-mail and destroy all copies of the original > message.
If you are the intended recipient but do not wish to receive >
communications via email, please advise the sender immediately.> > > >
"Molyneux, Tom" <Tom.Molyneux@xxxxxxx> > Sent by:
bpcs-l-bounces+norman.boyd=showaaluminum.com@xxxxxxxxxxxx> 02/06/2009
05:24 AM> Please respond to> BPCS ERP System <bpcs-l@xxxxxxxxxxxx>> > >
To> BPCS ERP System <bpcs-l@xxxxxxxxxxxx>> cc> > Subject> Re: [BPCS-L]
Sequence Number> > > > > > > It is also used in Cycle Counting. If you
select a part for cycle > counting, BPCS will stamp the ILI record for
the part/location with the > ITH transaction sequence at the time the
record was selected. When you > post the count it uses this transaction
number to work out if it needs to > make any adjustments for any
transactions since the cycle count selection. > > So you need to be very
careful if deleting any ITH r
ecords.> > Tom Molyneux> > National Oilwell Varco> Mono Pumps Limited>!
MIS Department> > Tel. 0161 214 2142> Fax. 0161 214 2344> E:mail
Tom.Molyneux@xxxxxxx> > -----Original Message-----> From:
bpcs-l-bounces+tom.molyneux=nov.com@xxxxxxxxxxxx [>
mailto:bpcs-l-bounces+tom.molyneux=nov.com@xxxxxxxxxxxx] On Behalf Of >
Sandipan Sengupta> Sent: 06 February 2009 10:05> To: BPCS ERP System>
Subject: Re: [BPCS-L] Sequence Number> > The Sequence Number in ITH is a
count of the number of transactions > happening for a particular item.>
On 2/6/09, colin clement <colin.clement@xxxxxxxxxxx> wrote:> >> >> >
Can I just there ask is this the only place that it is used and> >
therefore it does not matter if you delete records from ITH as long as>
they are from the front of the sequence numbers.> >> > Thanks> >> >
Colin Clement> To: bpcs-l@xxxxxxxxxxxx> From: tay@xxxxxxxxxxxxx> Date:>
Fri, 6 Feb 2009 17:42:34 +0800> Subject: Re: [BPCS-L] Sequence
Number>> > > > To control display transaction history sequence !> > -- >
This is> > the BPCS ERP System (BPC!
S-L) mailing list> To post a message email:> > BPCS-L@xxxxxxxxxxxx> To
subscribe, unsubscribe, or change list> > options,>> > visit:
http://lists.midrange.com/mailman/listinfo/bpcs-l> or email:> >
BPCS-L-request@xxxxxxxxxxxx> Before posting, please take a moment to> >
review the archives> at
message: 2
date: Fri, 6 Feb 2009 09:05:36 -0500
from: "Dan Sweeney" <dsweeney@xxxxxxxxxxxxxxxx>
subject: Re: [BPCS-L] Sequence Number
The ITH sequence doesn't have to start with one (1). The most important
thing to check is that the last sequence number in ITH is the same as
the sequence number for the respective item in the item master file.
INV300 starts with that sequence number in the ITH and reads the file
backwards for the displaying of historical transactions regardless of
the date of the transaction.
The only reset program is in the suite of inventory period close
programs.
If within the system parameters the number of days to purge data is set
to all 9's the system will never purge data from the ITH file.
If you have any further questions or concerns or need further assistance
please contact me directly.
dsweeney@xxxxxxxxxxxxxxxx
-----Original Message-----
From: bpcs-l-bounces+dsweeney=phoenixbcinc.com@xxxxxxxxxxxx
[mailto:bpcs-l-bounces+dsweeney=phoenixbcinc.com@xxxxxxxxxxxx] On Behalf
Of colin clement
Sent: Friday, February 06, 2009 9:03 AM
To: bpcs-l@xxxxxxxxxxxx
Subject: Re: [BPCS-L] Sequence Number
In our system we have many items that do not beging with 1 and we see no
problem in inv300 although we are running version 3.1.
Do you know the BPCS program to reset the sequence numbers, it may be
worth us running it.
Colin C> To: bpcs-l@xxxxxxxxxxxx> From: Phil.Catlin@xxxxxxxxxxx> Date:
Fri, 6 Feb 2009 08:34:55 -0500> Subject: Re: [BPCS-L] Sequence Number> >
Also...> > If the sequence number for an item doesn't start with 1 and
run > sequentially, the results in INV300 (History) will be
unpredictable, and > probably incomplete.> **CAUTION**> Purging the ITH
is not a trivial exercise that can be done with an SQL > delete
statement! Use the BPCS supplied program, or find someone who has >
worked with this file before!> > Phil C> > > > >
Norman.Boyd@xxxxxxxxxxxxxxxxx > Sent by:
bpcs-l-bounces+phil.catlin=formica.com@xxxxxxxxxxxx> 02/06/2009 08:28
AM> Please respond to> BPCS ERP System <bpcs-l@xxxxxxxxxxxx>> > > To>
BPCS ERP System <bpcs-l@xxxxxxxxxxxx>> cc> > Subject> Re: [BPCS-L]
Sequence Number> > > > > > > The last sequence number is also tracked in
the item master file (iim). > I'm not too familiar with the function
differences between the versions of > > BPCS but, if your ITH file is g!
etting too large, are you not running the > Month End Close in the
inventory module, INV903 on the screen, INV900 > batch program? This
will move records from the ITH to the YTH file, > keeping ITH smaller
and all of your inventory transactions intact. If you > > have any sort
of auditing procedures, internal or external, you probably > don't want
to delete inventory transaction records. You'll also want to > check
your system setup(SYS800, Transaction History System Parameters - >
SYS824) before running the INV900 as it may be running for quite some >
time, especially if you haven't run it in the past.> > Norman K. Boyd>
MIS Administrator> Showa Aluminum Corp. of America> Phone: (740)
869-5007> Cell: (740) 572-7876> Fax: (740) 869-3309> > CONFIDENTIALITY
NOTICE: This e-mail message is intended only for the > person or entity
to which it is addressed and may contain confidential > and/or
privileged material. Any unauthorized review, use, disclosure or >
distribution is proh!
ibited. If you are not the intended recipient, please > contact the
sender by reply e-mail and destroy all copies of the original > message.
If you are the intended recipient but do not wish to receive >
communications via email, please advise the sender immediately.> > > >
"Molyneux, Tom" <Tom.Molyneux@xxxxxxx> > Sent by:
bpcs-l-bounces+norman.boyd=showaaluminum.com@xxxxxxxxxxxx> 02/06/2009
05:24 AM> Please respond to> BPCS ERP System <bpcs-l@xxxxxxxxxxxx>> > >
To> BPCS ERP System <bpcs-l@xxxxxxxxxxxx>> cc> > Subject> Re: [BPCS-L]
Sequence Number> > > > > > > It is also used in Cycle Counting. If you
select a part for cycle > counting, BPCS will stamp the ILI record for
the part/location with the > ITH transaction sequence at the time the
record was selected. When you > post the count it uses this transaction
number to work out if it needs to > make any adjustments for any
transactions since the cycle count selection. > > So you need to be very
careful if deleting any ITH records.> > Tom Molyneux> > National Oilwell
Varco> Mono Pumps Limited>!
MIS Department> > Tel. 0161 214 2142> Fax. 0161 214 2344> E:mail
Tom.Molyneux@xxxxxxx> > -----Original Message-----> From:
bpcs-l-bounces+tom.molyneux=nov.com@xxxxxxxxxxxx [>
mailto:bpcs-l-bounces+tom.molyneux=nov.com@xxxxxxxxxxxx] On Behalf Of >
Sandipan Sengupta> Sent: 06 February 2009 10:05> To: BPCS ERP System>
Subject: Re: [BPCS-L] Sequence Number> > The Sequence Number in ITH is a
count of the number of transactions > happening for a particular item.>
On 2/6/09, colin clement <colin.clement@xxxxxxxxxxx> wrote:> >> >> >
Can I just there ask is this the only place that it is used and> >
therefore it does not matter if you delete records from ITH as long as>
they are from the front of the sequence numbers.> >> > Thanks> >> >
Colin Clement> To: bpcs-l@xxxxxxxxxxxx> From: tay@xxxxxxxxxxxxx> Date:>
Fri, 6 Feb 2009 17:42:34 +0800> Subject: Re: [BPCS-L] Sequence
Number>> > > > To control display transaction history sequence !> > -- >
This is> > the BPCS ERP System (BPC!
S-L) mailing list> To post a message email:> > BPCS-L@xxxxxxxxxxxx> To
subscribe, unsubscribe, or change list> > options,>> > visit:
http://lists.midrange.com/mailman/listinfo/bpcs-l> or email:> >
BPCS-L-request@xxxxxxxxxxxx> Before posting, please take a moment to> >
review the archives> at
http://archive.midrange.com/bpcs-l.> >> >
Delivered-To: colin.clement@xxxxxxxxxxx> >
_________________________________________________________________> >
Check out the new and improved services from Windows Live. Learn more!>
http://clk.atdmt.com/UKM/go/132630768/direct/01/> > --> > This is the
BPCS ERP System (BPCS-L) mailing list To post a message> > email:
BPCS-L@xxxxxxxxxxxx To subscribe, unsubscribe, or change list> >
options,> > visit:
http://lists.midrange.com/mailman/listinfo/bpcs-l> >
or email: BPCS-L-request@xxxxxxxxxxxx> > Before posting, please take a
moment to review the archives at> >
http://archive.midrange.com/bpcs-l.>
Delivered-To: sandysg@xxxxxxxxx> >> --> This is the BPCS ERP System
(BPCS-L) mailing list To post a message email: >!
> BPCS-L@xxxxxxxxxxxx To subscribe, unsubscribe, or change list
options,> visit:
http://lists.midrange.com/mailman/listinfo/bpcs-l> or
email: BPCS-L-request@xxxxxxxxxxxx> Before posting, please take a moment
to review the archives at >
http://archive.midrange.com/bpcs-l.> >
Delivered-To: Tom.Molyneux@xxxxxxx> > > Mono Pumps Limited> Registered
in England No. 300721.> Registered Office : Martin Street, Audenshaw,
Manchester. M34 5JA> -- > This is the BPCS ERP System (BPCS-L) mailing
list> To post a message email: BPCS-L@xxxxxxxxxxxx> To subscribe,
unsubscribe, or change list options,> visit:
http://lists.midrange.com/mailman/listinfo/bpcs-l> or email:
BPCS-L-request@xxxxxxxxxxxx> Before posting, please take a moment to
review the archives> at
http://archive.midrange.com/bpcs-l.> >
Delivered-To: norman.boyd@xxxxxxxxxxxxxxxxx> > -- > This is the BPCS ERP
System (BPCS-L) mailing list> To post a message email:
BPCS-L@xxxxxxxxxxxx> To subscribe, unsubscribe, or change list optio!
ns,> visit:
http://lists.midrange.com/mailman/listinfo/bpcs-l> or
email: BPCS-L-request@xxxxxxxxxxxx> Before posting, please take a moment
to review the archives> at
http://archive.midrange.com/bpcs-l.> >
Delivered-To: phil.catlin@xxxxxxxxxxx> > -- > This is the BPCS ERP
System (BPCS-L) mailing list> To post a message email:
BPCS-L@xxxxxxxxxxxx> To subscribe, unsubscribe, or change list options,>
visit:
http://lists.midrange.com/mailman/listinfo/bpcs-l> or email:
BPCS-L-request@xxxxxxxxxxxx> Before posting, please take a moment to
review the archives> at
http://archive.midrange.com/bpcs-l.> >
Delivered-To: colin.clement@xxxxxxxxxxx
_________________________________________________________________
Check out the new and improved services from Windows Live. Learn more!
http://clk.atdmt.com/UKM/go/132630768/direct/01/
midrange.com
