- Al Macintyre BPCS/400 Computer Janitor at http://www.globalwiretechnologies.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
As an Amazon Associate we earn from qualifying purchases.
Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.