Re: How to link production items
"David Dewick" <[email protected]>
| Newsgroups | gmane.comp.systems.as400.jbausers |
|---|---|
| Message-ID | <8A8543B885A3944293329CAAB0FC409B37833D@bhl04.tka-dar.thyssenkrupp.com> |
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 so lely 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.