Re: How to link production items

David,
Sorry this is long, but it's my first response.
We also handle single and multiple part molds with multiple cavities. What
we did was to use specification reference field EDNO04 in OSLPDF3.MSITEMAS
to store the mould number. We also store it's co-product information using
the F21=Text key. We only store the "co-product(s) on the primary part. In
other words, the co-product part will not use the F21 TEXT fields. This
part's mold produces 4 parts.
DB034 26 - Plastech - Romulus USER RROSEBRO 11/
16:
Item .................: GMC006468 LH 6 CYL SPLSH SHLD 10318 .
Revision Level........: (1 o
Item Type.............: M Manufactured
Control policy .......: 1 Audit Only
Specification Ref.....: 10318/19 GT Family...........:
Low Level Code......:
Primary Stockroom.....: 26 PLASTECH - ROMULUS
Planner...............:

Costing Route.........: S Cost Route Designate: 1
Planning Type.........: 0 Planning Route......: 1
Production Lead Time..: 5.00 Cumulative Lead Time: .00

Demand Policy.........: 6 Forecast + Actual Demand
Independent Demand....:
Forecast Comparison...:
Smoothing Policy......: 0 No Smoothing
Forecast Time Fence...: (Days)
Seasonal Profile......:

F3=Exit F12=Re-select Item F18=Additional Parameters F21=Text F22=Cos


The f21 key option stores the info in OSLPDF3.MSP02. We created a logical
over it to just show records where TTYP02 = ITEM AND the TEXT02 that starts
with "COPRO*". To reduce the read time.
PD007 26 - Plastech - Romulus USER RROSEBRO 11/
Text Inquiry 16:
No of lines to Roll: 14 Last Change Date: 8/16/06 No. of Lines
Key: GMC006468 Type: ITEM - IC1 - MINOR : Item
1 10 20 30 40 50 60
Line |........|.........|.........|.........|.........|.........|.....
1 COPRD*GMC006465,GMC006464,GMC006467

Here is what the MSTEXT looks like.

CONO02 TTYP02 TSTP02 TKEY02 TXLN02 TXDT02 TEXT02
TXLL02 TXSP02 RSTS02
26 ITEM IC1 GMC006037 1 1060714 COPRD*GMC006039
1
26 ITEM IC1 GMC006468 1 1060816
COPRD*GMC006465,GMC006464,GMC006467 1

Thanks,
Randy Rosebrock
Plastech
Bryan, OH
419-636-4211 Ext 386
rrosebro@xxxxxxxxxxxxxxx <mailto:rrosebro@xxxxxxxxxxxxxxx>

-----Original Message-----


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

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




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