Re: How to link production items
"Jack Welch" <[email protected]>
| Newsgroups | gmane.comp.systems.as400.jbausers |
|---|---|
| Message-ID | <[email protected]> |
David, I have use the Text files, (ie MSTEXT) to store additional data for Items, etc. You can add a specific text type for Moulds and store data there. -Jack _________________________________________________ > 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. > > > Hello Randy > > Thanks for your suggestions. I've taken a look at our system, and we use > that field already to hold the customer part/drawing number. I'll have a > check to see if there's anything else on the product description screens > we can use, however. > > David Dewick > > > > 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. > -------------------------------------------------------- > > -----Original Message----- > > From: system21-bounces-Zwy7GipZuJhWk0Htik3J/[email protected] > [mailto:system21-bounces-Zwy7GipZuJhWk0Htik3J/[email protected]] On Behalf Of Randy Rosebrock > Sent: 13 November 2007 21:57 > To: system21-Zwy7GipZuJhWk0Htik3J/[email protected] > Subject: Re: [SYSTEM21] 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. > > 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. > > > -----Original Message----- > From: system21-bounces-Zwy7GipZuJhWk0Htik3J/[email protected] > [mailto:system21-bounces-Zwy7GipZuJhWk0Htik3J/[email protected]] On Behalf Of Randy Rosebrock > Sent: 13 November 2007 21:57 > To: system21-Zwy7GipZuJhWk0Htik3J/[email protected] > Subject: Re: [SYSTEM21] 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. > > _______________________________________________ > 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. > > _______________________________________________ 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.