× The internal search function is temporarily non-functional. The current search engine is no longer viable and we are researching alternatives.
As a stop gap measure, we are using Google's custom search engine service.
If you know of an easy to use, open source, search engine ... please contact support@midrange.com.


  1.  Home
  2. BPCS-L
  3. February 2009

Re: 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 getting 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 prohibited. 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 (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: 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 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: 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/

As an Amazon Associate we earn from qualifying purchases.

This thread ...
Follow-Ups:
Replies:
Follow On AppleNews
Return to Archive home page | Return to MIDRANGE.COM home page

This mailing list archive is Copyright 1997-2024 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact [javascript protected email address].

Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.