INV620 by Cust - Doable?

from Al Macintyre on BPCS 405 CD

My users want BPCS inventory tags to print within location by customer & I am 
telling them that if it is even doable, it is at the fringes of my AS/400 
programming know-how.  Can we just settle for printing the customer identity 
on the tag?

And I know how to do a query which prints $ value of the inventory by 
customer it is for - would that be helpful?  No, the problem is that with 
employee turn-over & customer parts turn-over, knowing what customer this is 
for is a big help, but we also have some big locations with parts grouped by 
customer that the parts are being made for, so having the tags pre-sorted 
that way would streamline the physical process.

So what they want is sequence Warehouse-Location-Customer-Item

There are common items for which no one customer is relevant.

We recently started printing on our shop ticket packets a reference list of 
all the parts, with current customer orders, that this common in production 
goes into, to help expedite reuniting & programming that was at the frontiers 
of my know-how so far.  It is nice that they have this great confidence in my 
abilities, stretching my mind beyond what I could do before.

Right now our phusical tags they are sequenced off ILIL07 which is 
Warehouse-Location-Item & during the printing flow, INV620 accesses the item 
master for the item involved.

Our end items have the customer number keyed into the begininning of the 
drawing field of item master & in my last IBM class, on DB/400 I learned that 
we can create a joined logical of more than one file, so if I did a join of 
ILI with IIM, is there a way to do it so I still get all the ILI files data I 
need as there are many ILI records for each IIM record? --- I would be 
sequencing by the total drawing field, even though the customer number is 
only in the first few positions & the folks who keyed it in did not believe 
in registration.

I can handle the sub-stringing to extract valid customer # for RCM alpha 
representation, but if I get groupings, by what was keyed, I will consider 
this mission a success.  Is this even doable?

I guess I will have to read the manual on joining.

Al
+---
| This is the BPCS Users Mailing List!
| To submit a new message, send your mail to BPCS-L@midrange.com.
| To subscribe to this list send email to BPCS-L-SUB@midrange.com.
| To unsubscribe from this list send email to BPCS-L-UNSUB@midrange.com.
| Questions should be directed to the list owner: dasmussen@aol.com
+---