Re: Looking for "inactive" parts

If you have lot control on these parts you can find manufacturing and
expiration date information in INP84.  We use this to determine when
particular batches of material are going to go out of shelf life.  You could
also use this to determine the last manufacture date for an item and
generate a report that would show you products that haven't been made in a
long time.

Open orders for items can easily be found using OEP55 by looking for
products (CATN55) where STAT55 and QTNO55 are both blank.  This gives you
open order lines that are not quotes.

The DTTR70 field in OEP70 is a transaction date.  It is the date that was
noted when the confirm shipment transaction was performed.  It may or may
not be the date the invoice was printed, if that matters as a separate
issue. We use the DTTR70 as the invoice date to be consistent with the ship
date.

Hope this helps.  If you want more information either post back to the group
or email me directly.

Bruce Stern
sternb@erols.com

-----Original Message-----
From: Dan Bale <dbale@genfast.com>
To: JBAUSERS-L@midrange.com <JBAUSERS-L@midrange.com>
Date: Wednesday, August 04, 1999 4:07 PM
Subject: Looking for "inactive" parts


>
>
>Got a project today to convert an existing application on our old system to
the
>new JBA system.
>
>This app looks for "inactive" parts for the purpose of scrapping material.
In
>the old application, a part is considered inactive if it has not been
shipped,
>received, or ordered in the past 18 months.  Not so coincidentally, the old
>system's Item Balance file had the Last Date Shipped, Last Date Received,
and
>Last Date Ordered values.
>
>Is there something similar in JBA?
>
>I've found INP60 (Stock Balances), which has Last Dates of Issue, Receipt,
and
>Stocktake(?).  Is the Date Last Issue synonymous with a shipping date?  We
don't
>seem to have many dates in the Date Last Stocktake.
>
>I'm told that if I find a part on OEP55 (Order Lines), which doesn't have
useful
>dates for this project, that part can be considered active because these
are
>order lines for parts that customers have ordered but we may not have
stocked or
>received yet.
>
>How about the OEP70 (Invoice Lines)?  It has a "transaction date" (DTTR70).
Is
>this supposed to be an invoice date?  Or was there a logical reason for
calling
>it a "transaction" date?
>
>Or is there something else in JBA that I've missed completely?
>
>TIA,
>Dan Bale
>
>
>
>
>
>+---
>| 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.
+---