In checking the ITH file, we have a new item that processes 32,000 transactions a month. We are in trouble this month when we went over the 99999 limit. What I am planning on doing is creating a new item number "X", changing the item number for old item in the ith file to the "X" number for Jan-Mar. Then using a re-sequence program to re-sequence the old number for the April records so we can close and buy some time. Long range, I can only think of expanding the sequence field. Has anyone done this? Or any better suggestions? -----Original Message----- From: bpcs-l-bounces@xxxxxxxxxxxx [mailto:bpcs-l-bounces@xxxxxxxxxxxx] On Behalf Of Sally Bosman Sent: Thursday, April 17, 2003 3:26 AM To: SSA's BPCS ERP System Subject: Re: ITH Seq# > 99,999 Hi, You have had some very good advice regarding this but please remember, if you are going to write a program to resequence your ITH file (Tom Sult's reply), you also need to consider updating the IIM file. We have software that will archive the ITH (not to YTH) and will resequence records. Please contact me offline if you are interested. Best regards, Sally ------------------------------------- Sally Bosman Director - Small Blue Ltd Tel: +44 1737 824246 Fax: +44 1737 824247 Mob: +44 7767 447107 www.smallblue.co.uk ----- Original Message ----- From: "Syed Arif Inam" <arifinam@xxxxxxxxx> To: "SSA's BPCS ERP System" <bpcs-l@xxxxxxxxxxxx> Sent: Wednesday, April 16, 2003 7:28 PM Subject: ITH Seq# > 99,999 > Hi, > > We are facing a problem with ITH Seq# field. Some of high > transaction items' ITH seq# value has reached greater than > 99,999 and the system is creating transactions with zero > seq#. We have to keep 3 years of history and these items > have reached the limit in less than 3 years. > > Has anybody came across this problem? > > > Thanks > > Ver 4.05CD > > Syed Arif Inam > Dey, L.P. > Napa, California > > __________________________________________________ > Do you Yahoo!? > The New Yahoo! Search - Faster. Easier. Bingo > http://search.yahoo.com > _______________________________________________ > This is the SSA's 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.cgi/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. > _______________________________________________ This is the SSA's 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.cgi/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.