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

Besides SQL, Another way of setting the GLUP96 to '1' is to use AFI.

Use option 1/FIU (AFI Utilities) and select the IN Application.

Use F8 to change the link status from Inactive to BFI to Active and then
Inactive again (so F8 four times).

This will update the GLUP96 to be all '1'.

You may need to add you company into the Application and create a dummy
journal definition, but this works.

I know because I had a client do it in live and it took a week to unravel.
(I hope they aren't listening).

DO NOT CHANGE THE LINK STATUS IF YOU ARE LIVE!!!!

Good luck

Michael


-----Original Message-----
From: Grinstead, Scott [mailto:SAGrinstead@Rockyboots.com]
Sent: Saturday, October 07, 2000 5:21 AM
To: 'JBAUSERS-L@midrange.com'
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.
+---