|
During my Good Old Consulting days this is what we did for a company that wanted 30 character Part Number. We used the Item description field as the part number and suitably modified the Item search to search by part description and mask all Screens to show Descriptions instead of part number. The actual part number was set as an auto generated reference number. All the forms and report should be ok as they print the descriptions anyway and the actual descriptions were entered in the External text. We settled for this because this was only way to get away from making any database changes and we were using only the Distribution part of JBA so it was less complicated. Bottom line it was not an easy mod. Hope this helps Ram S. Hari Information Services Wasserstrom ramhari@xxxxxxxxxxxxxxx Voice 614.737.8542 -----Original Message----- From: Brunk, Kevin [mailto:KBrunk@xxxxxxxxxxxx] Sent: Monday, June 02, 2003 12:19 PM To: System 21 Users Subject: RE: [SYSTEM21] Expand characters in part/item field Geez Alan, You obviously don't have enough to do! Are you folks seriously considering this? The obvious ramifications of this are overwhelming. After the file changes, consider all the reports and screens that you're going to affect. And, it's not like adding a couple of characters... these will be MAJOR report/screen re-designs. I don't envy you! ==Kevin -----Original Message----- From: Alan Kincer [mailto:w2kprofessional@xxxxxxxxx] Sent: Monday, June 02, 2003 12:18 PM To: jbausers-l@xxxxxxxxxxxx Subject: [SYSTEM21] Expand characters in part/item field Currently we are limited to 15 characters in the part field. We have a need to expand this to 30 characters. Can anyone tell me the issues and pitfalls associated with this? Thank you! Alan _______________________________________________ This is the System 21 Users (SYSTEM21) mailing list To post a message email: SYSTEM21@xxxxxxxxxxxx To subscribe, unsubscribe, or change list options, visit: http://lists.midrange.com/mailman/listinfo/system21 or email: SYSTEM21-request@xxxxxxxxxxxx Before posting, please take a moment to review the archives at http://archive.midrange.com/system21. ********************************************************************** CONFIDENTIALITY NOTICE: The information transmitted in this message is intended only for the person or entity to which it is addressed and may contain confidential and/or privileged material. Any review, retransmission, dissemination or other use of this information by persons or entities other than the intended recipient is prohibited. If you received this in error, please contact the sender and destroy all copies of this document. Thank you. The Butler Company ********************************************************************** _______________________________________________ This is the System 21 Users (SYSTEM21) mailing list To post a message email: SYSTEM21@xxxxxxxxxxxx To subscribe, unsubscribe, or change list options, visit: http://lists.midrange.com/mailman/listinfo/system21 or email: SYSTEM21-request@xxxxxxxxxxxx Before posting, please take a moment to review the archives at http://archive.midrange.com/system21.
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.