Re: How to link production items

David,

Why don't you create production routes and then use a query to print the
parent item with it's components?
You can have multiple routes for the same parent item.
Files are MSP20 for Route Header, MSP28 for Route Details and you can
link on company code, parent item, and route#.


Thanks

Barbara Byrne

IT Manager
Greatex Mills Inc.


-----Original Message-----
From: system21-bounces@xxxxxxxxxxxx
[mailto:system21-bounces@xxxxxxxxxxxx] On Behalf Of David Dewick
Sent: Wednesday, November 07, 2007 6:50 AM
To: system21@xxxxxxxxxxxx
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: david.dewick@xxxxxxxxxxxxx
Website: www.darcast.com




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

This message contains confidential information and is intended only for
system21@xxxxxxxxxxxxx If you are not system21@xxxxxxxxxxxx you should
not disseminate, distribute or copy this e-mail. Please notify
david.dewick@xxxxxxxxxxxxx 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.