RE: INV620 by Cust - Doable?

You can join the IIM to the ILI file with the IIM file being primary so you 
can sequence on the drawing number field (if this is a permanent join). 
 Joining on the fly (ie through Query/400 does not restrict primary file 
only sequencing).  In Query/400 you would join with a type 2 so you would 
receive all of the item masters whether or not an ILI record exists.  This 
same thing can be done with a permanent join using DDS or SQL.  Good luck.

Dwight Slessman
National Electrical Carbon Products, Inc.


-----Original Message-----
From:   MacWheel99@aol.com [SMTP:MacWheel99@aol.com]
Sent:   Thursday, June 24, 1999 12:32 PM
To:     BPCS Users Mailing List
Subject:        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
+---
+---
| 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
+---