|
If you are not running AFI or BFI it is possible to manually clear INP96. Keep INP95, it is what is viewed when you do a stock movement inquiry. SQL or programmatically delete all the records from INP96 for all but the current period. If you need assistance please feel free to email me directly. Scott Grinstead Programmer/Analyst Rocky Shoes & Boots sagrinstead@rockyboots.com -----Original Message----- From: Charles Greene [mailto:greenec@millercurtain.com] Sent: Friday, October 06, 2000 2:47 PM To: JBAUSERS-L@midrange.com Subject: RE: INP95 vs INP96 -- What's the difference? So let me get this straight. Since I do not use AFI and my inp95 and inp96 both have the same number of records (3,000,000+) I should force a 1 or a 0 into GLUP96 in the inp96 file so that the next time my month end runs the records will be available for purging? Charles Greene Miller Curtain Co. Inc. > -----Original Message----- > From: owner-jbausers-l@midrange.com > [mailto:owner-jbausers-l@midrange.com]On Behalf Of Ed Lybrook > Sent: Friday, October 06, 2000 12:55 PM > To: JBAUSERS-L@midrange.com > Subject: RE: INP95 vs INP96 -- What's the difference? > > > Actually, an INP96 record must pass two criteria to be deleted: > > AFI must examine the record (GLUP96 record will be 1 or 0 if AFI has > examined it) > and > The end of month inventory process must be completed > > AFI does not use INP95 because of the amount of records in the > file. INP95 > is more of a history file while INP96 is more of a current transactions > file. > > +--- | This is the JBA Software Users Mailing List! | To submit a new message send your mail to JBAUSERS-L@midrange.com. | To subscribe to this list send email to JBAUSERS-L-SUB@midrange.com. | To unsubscribe from this list send email to JBAUSERS-L-UNSUB@midrange.com. | Questions should be directed to the list owner: doug333@aol.com. +--- +--- | This is the JBA Software Users Mailing List! | To submit a new message send your mail to JBAUSERS-L@midrange.com. | To subscribe to this list send email to JBAUSERS-L-SUB@midrange.com. | To unsubscribe from this list send email to JBAUSERS-L-UNSUB@midrange.com. | Questions should be directed to the list owner: doug333@aol.com. +---
As an Amazon Associate we earn from qualifying purchases.
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.