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
[email protected] <mailto:[email protected]> 

-----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: [email protected]
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 
****************************************
_______________________________________________
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.