|
The point being that spreadsheets are limiting. Putting the information on the iSeries - either Mapics or custom files - allows you to record/document/track the serial numbers. The other point is the ability to capture the data at the source of the transaction without rekeying and eliminated the potential for errors. Great to hear the different ways everyone handles a common need. -Greg -----Original Message----- From: DaleGindlesperger@xxxxxxxxxxx [mailto:DaleGindlesperger@xxxxxxxxxxx] Sent: Friday, June 03, 2005 4:12 PM To: MAPICS ERP System Discussion Subject: RE: Serial number Greg, We can't use what MAPICS provides for 2 reasons. 1. Serial number field is only 15 characters. Ours is a government formatted 17 characters. 2. No component serial number tracking. We had to write our own. Dale Gindlesperger IT Manager/Special Projects Leader Fleetwood Folding Trailers, Inc. 258 Beacon Street Somerset, PA 15501 "Greg Novak" <gnovak@xxxxxxxxx m> To Sent by: "'MAPICS ERP System Discussion'" mapics-l-bounces@ <mapics-l@xxxxxxxxxxxx> midrange.com cc Subject 06/03/2005 04:29 RE: Serial number PM Please respond to MAPICS ERP System Discussion <mapics-l@midrang e.com> Jon brings up some good issues. How do you relate your serial number back to the customer order? Is the CO number keyed in? How about customer name? Do you need to relate back to the manufacture of the product? Is the MO number also keyed in? What other information must be (re)keyed into the spreadsheet that already exists in Mapics? Spreadsheets cannot be utilized outside of the spreadsheet (or not easily). The data belongs on the iSeries where it can be managed and tracked. Why not use what Mapics provides? IMHO, -Greg Gregory Novak Manager North American Technical Services Momentum Utilities Pty Ltd (630) 985-1736 gnovak@xxxxxxxxxx www.jacana.com Making Information Work for your Business www.intuator.com -----Original Message----- From: jleroi@xxxxxxxxx [mailto:jleroi@xxxxxxxxx] Sent: Friday, June 03, 2005 11:58 AM To: mapics-l@xxxxxxxxxxxx Subject: RE: Serial number We use serial numbers for a small percentage of but high dollar value items. The parts have different warranty time frames so tracking is easier with the data in MAPICS. Having the data in one place makes life easier for our users when they wish to create adhoc queries. If you are tracking data in a spread sheet, you are rarely doing your organization a favor. At some point, either access to the data or validity of the data becomes an issue. I have been asked too many times to try and cleanup a spreadsheet so that the data entered can be matched to our production data. Luckily, there are a lot of tools available for manipulating cell entries but at some point it takes a manual process to evaluate what is there and force it to match what is in production. It is rarely faster to key the data into a spreadsheet than to enter it into MAPICS and especially since there is a place holder for the data already. Obviously there are a number of issues around things like this. I usually refer to the fact that we are responsible for insuring the availability of accurate data to all users when it is needed. A spreadsheet is not a convienent location for multiple people to access data at the same time for a single record nor does it usually insure accurate data or allow for data protection via things like journalling, change control, etc. Just my 2 cents. Jon Le Roi Director of I.T. Tegal Corporation -----Original Message----- From: sjones@xxxxxxxxxxxxxx [mailto:sjones@xxxxxxxxxxxxxx] Sent: Friday, June 03, 2005 8:57 AM To: MAPICS ERP System Discussion Subject: RE: Serial number We don't use MAPICS to handle the serial numbers, but do have a file on the I-Series to store the info. Convincing users that it would be better can be tough. If you put it on the I-Series, either in MAPICS or your own, people could inquire on the data without contacting others. Are the serial numbers bar-coded, so that someone does not have to manually record the data? You can write some reports based on serial number data that you may not have now. Steve Jones "Teresa Biby" <TBiby@xxxxxxx> Sent by: mapics-l-bounces@xxxxxxxxxxxx 06/03/2005 11:49 AM Please respond to MAPICS ERP System Discussion <mapics-l@xxxxxxxxxxxx> To "MAPICS ERP System Discussion" <mapics-l@xxxxxxxxxxxx> cc Subject RE: Serial number We only serialize about 30% of what goes out the door (line items) and our products have lifetime warranty. Obviously, with that kind of warranty, our return rate is very low due to the high quality of the product. Our quality tech assigns the serial numbers and keys into excel. How can I convince anyone that this info would be better put into mapics? Or, do I even try? -----Original Message----- From: mapics-l-bounces@xxxxxxxxxxxx [mailto:mapics-l-bounces@xxxxxxxxxxxx] On Behalf Of LDegnon@xxxxxxxxx Sent: Friday, June 03, 2005 11:39 AM To: MAPICS ERP System Discussion Subject: Re: Serial number We scan and record the Serial Number of >90% of what goes out of our door. We have a Five year warranty on almost all, then a three year on the rest. This info is picked up from the Item Master at shipping time (also whether or not "Serial Number Required" is checked. I honestly don't know how we would handle this manually... Lloyd H. Degnon I.S. Manager AmPro Computers, Inc. 5215 Hellyer Ave. Building #110 San Jose, CA 95138 (408) 360-4365 ldegnon@xxxxxxxxx www.AmPro.com "Teresa Biby" <TBiby@xxxxxxx> Sent by: mapics-l-bounces@xxxxxxxxxxxx 06/03/2005 08:32 AM Please respond to MAPICS ERP System Discussion <mapics-l@xxxxxxxxxxxx> To <mapics-l@xxxxxxxxxxxx> cc Subject Serial number Is anyone using the Mapics serial number capability? Can anyone give me the benefits of having the serial number in mapics (other than lookup capabilities) rather than an external database? I'm having trouble getting change to occur -our users are quite content to leave this in an excel spreadsheet and have customer service call quality when they need to know what went where. Thanks in advance, Teresa Biby Virginia Panel Corporation _______________________________________________ This is the MAPICS ERP System Discussion (MAPICS-L) mailing list To post a message email: MAPICS-L@xxxxxxxxxxxx To subscribe, unsubscribe, or change list options, visit: http://lists.midrange.com/mailman/listinfo/mapics-l or email: MAPICS-L-request@xxxxxxxxxxxx Before posting, please take a moment to review the archives at http://archive.midrange.com/mapics-l. _______________________________________________ This is the MAPICS ERP System Discussion (MAPICS-L) mailing list To post a message email: MAPICS-L@xxxxxxxxxxxx To subscribe, unsubscribe, or change list options, visit: http://lists.midrange.com/mailman/listinfo/mapics-l or email: MAPICS-L-request@xxxxxxxxxxxx Before posting, please take a moment to review the archives at http://archive.midrange.com/mapics-l. _______________________________________________ This is the MAPICS ERP System Discussion (MAPICS-L) mailing list To post a message email: MAPICS-L@xxxxxxxxxxxx To subscribe, unsubscribe, or change list options, visit: http://lists.midrange.com/mailman/listinfo/mapics-l or email: MAPICS-L-request@xxxxxxxxxxxx Before posting, please take a moment to review the archives at http://archive.midrange.com/mapics-l. _______________________________________________ This is the MAPICS ERP System Discussion (MAPICS-L) mailing list To post a message email: MAPICS-L@xxxxxxxxxxxx To subscribe, unsubscribe, or change list options, visit: http://lists.midrange.com/mailman/listinfo/mapics-l or email: MAPICS-L-request@xxxxxxxxxxxx Before posting, please take a moment to review the archives at http://archive.midrange.com/mapics-l. _______________________________________________ This is the MAPICS ERP System Discussion (MAPICS-L) mailing list To post a message email: MAPICS-L@xxxxxxxxxxxx To subscribe, unsubscribe, or change list options, visit: http://lists.midrange.com/mailman/listinfo/mapics-l or email: MAPICS-L-request@xxxxxxxxxxxx Before posting, please take a moment to review the archives at http://archive.midrange.com/mapics-l.
As an Amazon Associate we earn from qualifying purchases.
This mailing list archive is Copyright 1997-2024 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact [javascript protected email address].
Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.
midrange.com
