× 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.



We process many "B" transactions for the same customer / product / date. We
have been dealing with this sequence number problem for some time for our
fastest moving items. I am thinking about writing a program that would
replace all ITH "B" transaction records older that a set number of days with
summary records where one record represents all such transactions for the
same customer, product, date. For anything older than 60 or 90 days we
really don't need detail information -- just the ability to identify when
some abnormal movement took place. 
once the unconsolidated records are replaced by the summary records it is
easy to resequence the file and update the sequence number field in the IIM.
(In fact, we do that part already as part of our purge routine.)

Mark Bazer
Director, Information Systems
Dyno Merchandise
Pompano Beach, FL


-----Original Message-----
From: Robert Write [mailto:robertwrite@xxxxxxxxxxx]
Sent: Friday, April 18, 2003 2:06 PM
To: 'SSA's BPCS ERP System'
Subject: RE: ITH Seq# > 99,999


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.


_______________________________________________
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.

As an Amazon Associate we earn from qualifying purchases.

This thread ...

Follow-Ups:

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 copyright@midrange.com.

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