Re: How to link production items

David,
There is a file INP36 (Attributes) where additional info can be stored.
But darn if I know how to get to it through System21.
One quick way is to attach some text to it. You can setup a text type just
for what you're looking for and this allows for lots of detail.
Have you looked at the INP60 and MSP04 files?

Mex Davis
Senior Systems Analyst
Business Systems Group
____________________________________________________________________________
_____________________
Due to regional differences, the above email may contain words or phrases
that may not be familiar to the reader. Some words may not be used in the
right context or the author just got it wrong. Never-the-less the message
can be understood if some effort and imagination is used. Your understanding
is appreciated.


-----Original Message-----
From: system21-bounces-Zwy7GipZuJhWk0Htik3J/[email protected]
[mailto:system21-bounces-Zwy7GipZuJhWk0Htik3J/[email protected]]On Behalf Of David Dewick
Sent: Wednesday, November 07, 2007 6:50 AM
To: system21-Zwy7GipZuJhWk0Htik3J/[email protected]
Subject: [SYSTEM21] How to link production items


IMPORTANT: This message is private and confidential. If you have received
this message in error, please notify the sender and remove the message and
all attachments from your system.


I have an "interesting" problem that I hope someone can help with. I'm
using standard System 21 v3.5.2.b. I know it's old, but it's what I have
to work with!

I make parts from a mould, and each mould might produce 2 or more parts,
the same or different, depending on a number of factors (part
size/weight/configuration, etc). I want to hold the part and the mould
as separate items on S21, but I would also like to be able to identify
the mould part number from the product item record so that I can link
part/mould records from an external query. Just to complicate matters,
we can possibly have more than one mould to make a part, and each mould
has impression numbers for each part that the mould can produce. For
example, part number 123 is made from moulds m1 and m2, and each mould
makes three parts. Mould m1 has impressions 1, 2, and 3, and mould m2
has impressions 4, 5, and 6. Each part produced will have the impression
number moulded onto it, as well as a date code.

I thought I could use the feature code FTCD35 on inp35 to hold the mould
number currently being used, but I can't see anywhere that I can
maintain this field using the standard software. I'm not an RPG
programmer, so I can't bespoke the item maintenance program. We already
use the three user-defined specification fields in INP35 for other data.

Any ideas?

Darcast Crankshafts Limited
David Dewick
Information Technology and Production Manager
Cornwall Road
Smethwick
West Midlands
B66 2JR
Tel: 0121 565 7250
Mobile: 07796 155045
Email: [email protected]
Website: www.darcast.com




--------------------------------------------------------

This message contains confidential information and is intended only for
[email protected] If you are not system21-Zwy7GipZuJhWk0Htik3J/[email protected] you should not
disseminate, distribute or copy this e-mail. Please notify
[email protected] immediately by e-mail if you have received this
e-mail by mistake and delete this e-mail and any attachments from your
system. E-mail transmission cannot be guaranteed to be secure or error-free
as information could be intercepted, corrupted, lost, destroyed, arrive late
or incomplete, or contain viruses. David Dewick therefore does not accept
liability for any errors or omissions in the contents of this message, which
arise as a result of e-mail transmission. If verification is required please
request a hard-copy version. Any views or opinions presented are solely
those of David Dewick and do not necessarily represent those of the company.
--------------------------------------------------------




Darcast Crankshafts Limited is a limited company registered in England and
Wales.
Registered number: 4992386.
Registered office: Cornwall Road, Smethwick, West Midlands, B66 2JR, United
Kingdom

Darcast Crankshafts Limited is a wholly-owned subsidiary of Cornwall
Holdings Limited


Please note that Darcast Crankshafts Limited may monitor email traffic data
and also the content of email for the purposes of security and staff
training.

_______________________________________________
This is the System 21 Users (SYSTEM21) mailing list
To post a message email: SYSTEM21-Zwy7GipZuJhWk0Htik3J/[email protected]
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/system21
or email: SYSTEM21-request-Zwy7GipZuJhWk0Htik3J/[email protected]
Before posting, please take a moment to review the archives
at http://archive.midrange.com/system21.