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