RE: INP95 vs INP96 -- What's the difference?

The negative stock report is also driven (in a two step process) from the
INP96 file...  So if you're using that report you will want to run the
monthend report to prime the records for the negative stock report, prior
to clearing INP96...  We run this report every night in the night job in
Machine Manager...  We've also written a month end routine that clears
several files data that is thirteen months old or older...  And for those
files we have also set them to reuse deleted records so file reorgs are no
longer required to free up deleted records...

INP96 is daily movements...  It is intended to have prior period records
purged after every monthend...  Read the Redbook on this topic, it is very
informative...  As others have correctly stated, INP95 is intended to keep
the history records for much longer and is the file used from 4/INE - Stock
Movements Inquiry...

If you're not using AFI or the 31/INR Stock Movements report or the 34/INR
Negative Stock report then you don't really need the INP96 records at all,
and in any event you don't need anything more than the current periods
records in the file...

Good luck...




"Grinstead, Scott" <SAGrinstead@Rockyboots.com> on 10/06/2000 03:21:02 PM

Please respond to JBAUSERS-L@midrange.com
                                                              
                                                              
                                                              
 To:      "'JBAUSERS-L@midrange.com'"                         
          <JBAUSERS-L@midrange.com>                           
                                                              
 cc:      (bcc: Jeff Klipa/Harvard)                           
                                                              
                                                              
                                                              
 Subject: RE: INP95 vs INP96 -- What's the difference?        
                                                              






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



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