Re: Sequence Number -- BPCS-L

Another good answer.

Thanks guys for all your help

Colin> Date: Fri, 6 Feb 2009 09:05:36 -0500> From: dsweeney@xxxxxxxxxxxxxxxx> To: bpcs-l@xxxxxxxxxxxx> 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/> -- > 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: dsweeney@xxxxxxxxxxxxxxxx> -- > 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
_________________________________________________________________

Hotmail, Messenger, Photos and more - all with the new Windows Live. Get started!
http://www.download.live.com/