Re: Looking for "inactive" parts - Part 2

["Dan Bale" <dbale@xxxxxxxxxxx>]

Randy, thanks for the reply.

>>I would use PMP09 for open purchase orders, which is more of the transaction
file than PMP03.<<
Could I ask you to elaborate on this a bit more?  Why would you use PMP09 vs.
PMP03?  What kind of data selection should I do on this?  Remember that the goal
here is to find inactive items that will be candidates for being scrapped.
(Generally speaking, an item is considered inactive if nothing has been done
with it in the past 18 months.)  We want to look at purchase orders (in addition
to stock movement) in case a customer has requested an item that we have not yet
stocked (therefore, no "movement").

It is interesting to note that there is a transaction type (TRAN95) of 'U'
(Purchase Order) in the Stock Movement (INP95) file.  I only saw one such record
in our database, and it appeared to be an adjustment of some sort.

>>Pay attention to reserved quantities if you have reservations.<<
Eh?  Is this like a blanket P.O.?

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