Re: How to link production items

If you don't already use the "Alternative Item Reference" (F17 from item maintenance) might work.
This might cause issues elsewhere but could be researched.
In the Item Master there are also the three fields that are user defined, Specification 1,2,3 (only issue might be that they are all numeric).
These are defined in the company profile and if not already used are another option.

Hudson McVay
Stanley Steemer



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