Re: Data transfer question
Henrick John <john.henrick-5T14U8HB8hg3nlPAGJ/[email protected]>
| Newsgroups | gmane.comp.systems.as400.mapics |
|---|---|
| Message-ID | <2AD913EAB57A5C4A939AAFC73F1C2A31032007F9@EXCH01KN.KN.GKNAERO.LOCAL> |
Hi We are on release 9 Mapics and use the excellent symtrax forms package which allows any spooled file sent to a printer or outq to be formatted into excel ,access .word emailed saved etc You can rename headings change date formats add columns , in fact do anything you want in excel as macros before emailing The software does this and can be saved as templates This way we have eliminated many printed reports John -----Original Message----- From: mapics-l-bounces-Zwy7GipZuJhWk0Htik3J/[email protected] [mailto:mapics-l-bounces-Zwy7GipZuJhWk0Htik3J/[email protected]] On Behalf Of mapics-l-request-Zwy7GipZuJhWk0Htik3J/[email protected] Sent: 23 June 2011 23:17 To: mapics-l-Zwy7GipZuJhWk0Htik3J/[email protected] Subject: MAPICS-L Digest, Vol 9, Issue 79 GKN Aerospace *** This message has been scanned for viruses by Mimecast *** Send MAPICS-L mailing list submissions to mapics-l-Zwy7GipZuJhWk0Htik3J/[email protected] To subscribe or unsubscribe via the World Wide Web, visit http://lists.midrange.com/mailman/listinfo/mapics-l or, via email, send a message with subject or body 'help' to mapics-l-request-Zwy7GipZuJhWk0Htik3J/[email protected] You can reach the person managing the list at mapics-l-owner-Zwy7GipZuJhWk0Htik3J/[email protected] When replying, please edit your Subject line so it is more specific than "Re: Contents of MAPICS-L digest..." Today's Topics: 1. Headings on Data Transfer (Connie Webb) 2. Re: Data transfer question (Richard Schoen) 3. Integrator question (Weston Wheat) 4. Re: Integrator question (Kevin.Gerard-IaJHbxZe/[email protected]) ---------------------------------------------------------------------- message: 1 date: Thu, 23 Jun 2011 17:11:58 +0000 from: Connie Webb <cwebb-mcPmRQV/[email protected]> subject: [MAPICS-L] Headings on Data Transfer I use the "results" field in QRY to rename the headings. Just be sure to select the renamed field in your report. See this example: STORE T02.LLOCN Location Everytime you run this qry the heading STORE will come down instead of LLOCN. -----Original Message----- From: mapics-l-bounces-Zwy7GipZuJhWk0Htik3J/[email protected] [mailto:mapics-l-bounces-Zwy7GipZuJhWk0Htik3J/[email protected]] On Behalf Of mapics-l-request-Zwy7GipZuJhWk0Htik3J/[email protected] Sent: Thursday, June 23, 2011 1:00 PM To: mapics-l-Zwy7GipZuJhWk0Htik3J/[email protected] Subject: MAPICS-L Digest, Vol 9, Issue 78 Send MAPICS-L mailing list submissions to mapics-l-Zwy7GipZuJhWk0Htik3J/[email protected] To subscribe or unsubscribe via the World Wide Web, visit http://lists.midrange.com/mailman/listinfo/mapics-l or, via email, send a message with subject or body 'help' to mapics-l-request-Zwy7GipZuJhWk0Htik3J/[email protected] You can reach the person managing the list at mapics-l-owner-Zwy7GipZuJhWk0Htik3J/[email protected] When replying, please edit your Subject line so it is more specific than "Re: Contents of MAPICS-L digest..." Today's Topics: 1. Data transfer question (Greg Wenzloff) 2. Re: Data transfer question (Chuck Mick) 3. Re: Data transfer question (Tom E Stieger) 4. Re: Data transfer question (Dale Gindlesperger) 5. Re: Data transfer question ([email protected]) 6. Re: Data transfer question (Tim Rosendahl) 7. Re: Data transfer question ([email protected]) ---------------------------------------------------------------------- message: 1 date: Thu, 23 Jun 2011 10:21:23 -0400 from: "Greg Wenzloff" <[email protected]> subject: [MAPICS-L] Data transfer question I need to transfer the contents of a MAPICS file into an Excel spreadsheet. When I do this I get column headings such as ORDNO. Is there something I can do to get different column headings other than the field name. Perhaps ORDER NUMBER. I want to automate this and not go into Excel to adjust column heading each time this transfer is run. Thanks, Greg ------------------------------ message: 2 date: Thu, 23 Jun 2011 10:28:18 -0400 from: "Chuck Mick" <[email protected]> subject: Re: [MAPICS-L] Data transfer question Greg, This may not be the desired option... We often create a refreshable file with the standard XA names...but we then insert a pivot table that contains the user desired information / report. Within the pivot table, we rename the column headings to be more friendly. Users can then refresh the data and the pivot...retaining the headings. Alternatively, we have several 'reports' that have standard headers and the imported information displays before the headers. We set Excel to not include the field names... Other times (and I know this probably not the most efficient...but is effective for us)...we create logical views and rename the columns as desired. We then refresh using the logical. I would like to see if anybody gives a direct answer...but we have 'worked around' it as above... Chuck Chuck Mick Diversified Machine Inc. (o) 248.277.4315 (m) 517.643.3548 ? Confidential: This electronic message and all contents or attachments contain information from Diversified Machine, Inc. which may be privileged, confidential or otherwise protected from disclosure. The information is intended to be for the addressee only. If you are not the addressee, or have received this message in error, any disclosure, copy, distribution or use of the contents of this message is prohibited. If you have received this electronic message in error, please notify us immediately (248-277-4311) and destroy the original message and all copies.?Thank you for your assistance in this matter. ? ** Please consider the environment before printing this e-mail ** ? -----Original Message----- From: mapics-l-bounces-Zwy7GipZuJhWk0Htik3J/[email protected] [mailto:mapics-l-bounces-Zwy7GipZuJhWk0Htik3J/[email protected]] On Behalf Of Greg Wenzloff Sent: Thursday, June 23, 2011 10:21 AM To: MAPICS ERP System Discussion Subject: [MAPICS-L] Data transfer question I need to transfer the contents of a MAPICS file into an Excel spreadsheet. When I do this I get column headings such as ORDNO. Is there something I can do to get different column headings other than the field name. Perhaps ORDER NUMBER. I want to automate this and not go into Excel to adjust column heading each time this transfer is run. Thanks, Greg _______________________________________________ This is the MAPICS ERP System Discussion (MAPICS-L) mailing list To post a message email: MAPICS-L-Zwy7GipZuJhWk0Htik3J/[email protected] To subscribe, unsubscribe, or change list options, visit: http://lists.midrange.com/mailman/listinfo/mapics-l or email: MAPICS-L-request-Zwy7GipZuJhWk0Htik3J/[email protected] Before posting, please take a moment to review the archives at http://archive.midrange.com/mapics-l. ------------------------------ message: 3 date: Thu, 23 Jun 2011 07:37:49 -0700 (PDT) from: Tom E Stieger <testieger-7y5+ka1ulstWk0Htik3J/[email protected]> subject: Re: [MAPICS-L] Data transfer question Greg- How are you doing the transfer? I've been semi-successful using some properties on a JDBC Connection URL to bring over the column headings. JDBC Driver: com.ibm.as400.access.AS400JDBCDriver JDBC URL: jdbc:as400://myas400.name;translate binary=true; extended metadata = true; This would bring over a column heading looking like this: 'Order Number' I'm not sure if there something similar with ODBC. I think I have also had success using some of Chuck's suggestions. -Tom Stieger IT Manager California Fine Wire -----Original Message----- From: mapics-l-bounces-Zwy7GipZuJhWk0Htik3J/[email protected] [mailto:mapics-l-bounces-Zwy7GipZuJhWk0Htik3J/[email protected]] On Behalf Of Greg Wenzloff Sent: Thursday, June 23, 2011 7:21 AM To: mapics-l-Zwy7GipZuJhWk0Htik3J/[email protected] Subject: [MAPICS-L] Data transfer question I need to transfer the contents of a MAPICS file into an Excel spreadsheet. When I do this I get column headings such as ORDNO. Is there something I can do to get different column headings other than the field name. Perhaps ORDER NUMBER. I want to automate this and not go into Excel to adjust column heading each time this transfer is run. Thanks, Greg _______________________________________________ This is the MAPICS ERP System Discussion (MAPICS-L) mailing list To post a message email: MAPICS-L-Zwy7GipZuJhWk0Htik3J/[email protected] To subscribe, unsubscribe, or change list options, visit: http://lists.midrange.com/mailman/listinfo/mapics-l or email: MAPICS-L-request-Zwy7GipZuJhWk0Htik3J/[email protected] Before posting, please take a moment to review the archives at http://archive.midrange.com/mapics-l. ------------------------------ message: 4 date: Thu, 23 Jun 2011 08:06:01 -0700 (PDT) from: Dale Gindlesperger <dale_gindlesperger-/[email protected]> subject: Re: [MAPICS-L] Data transfer question Greg, I've used three ways regularly, all work OK, but none are "ideal" in my opinion.?? 1)? For repeated extracts of the same data using the Client Access "Access data from iSeries" option, I keep the spreadsheet headings intact, clear the data, and position the cursor to below the headings, then transfer without including the headings from the extract file.? Formatting stays intact, headings are the way the user wants them.?? Manual process, yes, but it's easy and works fine.? BUT.... only practical for repeated downloads of the same data. 2)? Another way to automate the process (similar), is to use a CL, keep a "canned heading" file stored in the folder, copy the canned heading file in, then copy append the data afterwards.? Then I can email the file to the user.? That's how I eliminated a lot of printed reports.? However, like option #1, this only works for repeats. A possible alternative (if Excel is not a carved-in-stone requirement) is: 3)? I also eliminated a number of reports with Browser/PowerLink/NetLink by creating the reports as databases and letting the users access the information on demand.? That way you don't have to worry about headings and such, or emailing.? You can also easily create comment fields that users can populate during the day to pass information.? That was popular with some of the production departments and the sales and marketing people.? Again, only useful for repeats, but I really liked that when I could use it.? You don't need to get copies of Office (and yes, I used OpenOffice extensively - over 80% of the PCs had it), but you STILL have to install and set it up), so it can save you money over time (assuming your users use Browser/PowerLink/NetLink). I'm looking forward to hearing what others have come up with for this!? :) Dale (Cork) Gindlesperger, CPIM Click here for my professional profile on LinkedIn "If I'd asked my customers what they wanted, they'd have said a faster horse." - Henry Ford >________________________________ >From: Greg Wenzloff <[email protected]> >To: MAPICS ERP System Discussion <mapics-l-Zwy7GipZuJhWk0Htik3J/[email protected]> >Sent: Thursday, June 23, 2011 10:21 AM >Subject: [MAPICS-L] Data transfer question > >I need to transfer the contents of a MAPICS file into an Excel >spreadsheet. >When I do this I get column headings such as ORDNO. > >Is there something I can do to get different column headings other than >the field name. >Perhaps ORDER NUMBER. > >I want to automate this and not go into Excel to adjust column heading >each time this transfer is run. > >Thanks, >Greg >_______________________________________________ >This is the MAPICS ERP System Discussion (MAPICS-L) mailing list >To post a message email: MAPICS-L-Zwy7GipZuJhWk0Htik3J/[email protected] >To subscribe, unsubscribe, or change list options, >visit: http://lists.midrange.com/mailman/listinfo/mapics-l >or email: MAPICS-L-request-Zwy7GipZuJhWk0Htik3J/[email protected] >Before posting, please take a moment to review the archives >at http://archive.midrange.com/mapics-l. > > > > ------------------------------ message: 5 date: Thu, 23 Jun 2011 11:16:23 -0400 from: <[email protected]> subject: Re: [MAPICS-L] Data transfer question You can gather all column's field names and inside the Client Access transfer change the name, like below Select area: ORDNO as order_number Jose Rivera -----Original Message----- From: mapics-l-bounces-Zwy7GipZuJhWk0Htik3J/[email protected] [mailto:mapics-l-bounces-Zwy7GipZuJhWk0Htik3J/[email protected]] On Behalf Of Greg Wenzloff Sent: Thursday, June 23, 2011 7:21 AM To: mapics-l-Zwy7GipZuJhWk0Htik3J/[email protected] Subject: [MAPICS-L] Data transfer question I need to transfer the contents of a MAPICS file into an Excel spreadsheet. When I do this I get column headings such as ORDNO. Is there something I can do to get different column headings other than the field name. Perhaps ORDER NUMBER. I want to automate this and not go into Excel to adjust column heading each time this transfer is run. Thanks, Greg _______________________________________________ This is the MAPICS ERP System Discussion (MAPICS-L) mailing list To post a message email: MAPICS-L-Zwy7GipZuJhWk0Htik3J/[email protected] To subscribe, unsubscribe, or change list options, visit: http://lists.midrange.com/mailman/listinfo/mapics-l or email: MAPICS-L-request-Zwy7GipZuJhWk0Htik3J/[email protected] 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-Zwy7GipZuJhWk0Htik3J/[email protected] To subscribe, unsubscribe, or change list options, visit: http://lists.midrange.com/mailman/listinfo/mapics-l or email: MAPICS-L-request-Zwy7GipZuJhWk0Htik3J/[email protected] Before posting, please take a moment to review the archives at http://archive.midrange.com/mapics-l. ------------------------------ message: 6 date: Thu, 23 Jun 2011 09:07:48 -0700 (PDT) from: Tim Rosendahl <rosetj2011-/[email protected]> subject: Re: [MAPICS-L] Data transfer question I jave several of these and I set up a template for each of the transfers. I the transfer request I have unchecked the item wich includes fields headings. ________________________________ From: "[email protected]" <[email protected]> To: mapics-l-Zwy7GipZuJhWk0Htik3J/[email protected] Sent: Thu, June 23, 2011 11:16:23 AM Subject: Re: [MAPICS-L] Data transfer question You can gather all column's field names and inside the Client Access transfer change the name,? like below Select area: ORDNO as? order_number Jose Rivera -----Original Message----- From: mapics-l-bounces-Zwy7GipZuJhWk0Htik3J/[email protected] [mailto:mapics-l-bounces-Zwy7GipZuJhWk0Htik3J/[email protected]] On Behalf Of Greg Wenzloff Sent: Thursday, June 23, 2011 7:21 AM To: mapics-l-Zwy7GipZuJhWk0Htik3J/[email protected] Subject: [MAPICS-L] Data transfer question I need to transfer the contents of a MAPICS file into an Excel spreadsheet. When I do this I get column headings such as ORDNO. Is there something I can do to get different column headings other than the field name. Perhaps ORDER NUMBER. I want to automate this and not go into Excel to adjust column heading each time this transfer is run. Thanks, Greg _______________________________________________ This is the MAPICS ERP System Discussion (MAPICS-L) mailing list To post a message email: MAPICS-L-Zwy7GipZuJhWk0Htik3J/[email protected] To subscribe, unsubscribe, or change list options, visit: http://lists.midrange.com/mailman/listinfo/mapics-l or email: MAPICS-L-request-Zwy7GipZuJhWk0Htik3J/[email protected] 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-Zwy7GipZuJhWk0Htik3J/[email protected] To subscribe, unsubscribe, or change list options, visit: http://lists.midrange.com/mailman/listinfo/mapics-l or email: MAPICS-L-request-Zwy7GipZuJhWk0Htik3J/[email protected] 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-Zwy7GipZuJhWk0Htik3J/[email protected] To subscribe, unsubscribe, or change list options, visit: http://lists.midrange.com/mailman/listinfo/mapics-l or email: MAPICS-L-request-Zwy7GipZuJhWk0Htik3J/[email protected] Before posting, please take a moment to review the archives at http://archive.midrange.com/mapics-l. ------------------------------ message: 7 date: Thu, 23 Jun 2011 09:24:03 -0700 from: [email protected] subject: Re: [MAPICS-L] Data transfer question Hi Greg, We use Sequel Viewpoint from Help Systems and works perfect for us when downloading data to Excel including the column names, other benefits are: - Conversion of the Date from CYYMMDD to MMDDYY or any other format - You can change the value of the output field.. .for example instead of showing ITTYP = 1, your query can convert this to column 'Item Type', and the value to be : "1 - Finished Good' We also have Linoma software for this. Regards Antonio. From: Tim Rosendahl <rosetj2011-/[email protected]> To: MAPICS ERP System Discussion <mapics-l-Zwy7GipZuJhWk0Htik3J/[email protected]> Date: 06/23/2011 09:08 AM Subject: Re: [MAPICS-L] Data transfer question Sent by: mapics-l-bounces-Zwy7GipZuJhWk0Htik3J/[email protected] I jave several of these and I set up a template for each of the transfers. I the transfer request I have unchecked the item wich includes fields headings. ________________________________ From: "[email protected]" <[email protected]> To: mapics-l-Zwy7GipZuJhWk0Htik3J/[email protected] Sent: Thu, June 23, 2011 11:16:23 AM Subject: Re: [MAPICS-L] Data transfer question You can gather all column's field names and inside the Client Access transfer change the name,? like below Select area: ORDNO as? order_number Jose Rivera -----Original Message----- From: mapics-l-bounces-Zwy7GipZuJhWk0Htik3J/[email protected] [mailto:mapics-l-bounces-Zwy7GipZuJhWk0Htik3J/[email protected]] On Behalf Of Greg Wenzloff Sent: Thursday, June 23, 2011 7:21 AM To: mapics-l-Zwy7GipZuJhWk0Htik3J/[email protected] Subject: [MAPICS-L] Data transfer question I need to transfer the contents of a MAPICS file into an Excel spreadsheet. When I do this I get column headings such as ORDNO. Is there something I can do to get different column headings other than the field name. Perhaps ORDER NUMBER. I want to automate this and not go into Excel to adjust column heading each time this transfer is run. Thanks, Greg _______________________________________________ This is the MAPICS ERP System Discussion (MAPICS-L) mailing list To post a message email: MAPICS-L-Zwy7GipZuJhWk0Htik3J/[email protected] To subscribe, unsubscribe, or change list options, visit: http://lists.midrange.com/mailman/listinfo/mapics-l or email: MAPICS-L-request-Zwy7GipZuJhWk0Htik3J/[email protected] 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-Zwy7GipZuJhWk0Htik3J/[email protected] To subscribe, unsubscribe, or change list options, visit: http://lists.midrange.com/mailman/listinfo/mapics-l or email: MAPICS-L-request-Zwy7GipZuJhWk0Htik3J/[email protected] 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-Zwy7GipZuJhWk0Htik3J/[email protected] To subscribe, unsubscribe, or change list options, visit: http://lists.midrange.com/mailman/listinfo/mapics-l or email: MAPICS-L-request-Zwy7GipZuJhWk0Htik3J/[email protected] 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-Zwy7GipZuJhWk0Htik3J/[email protected] To subscribe, unsubscribe, or change list options, visit: http://lists.midrange.com/mailman/listinfo/mapics-l or email: MAPICS-L-request-Zwy7GipZuJhWk0Htik3J/[email protected] 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) digest list To post a message email: MAPICS-L-Zwy7GipZuJhWk0Htik3J/[email protected] To subscribe, unsubscribe, or change list options, visit: http://lists.midrange.com/mailman/listinfo/mapics-l or email: MAPICS-L-request-Zwy7GipZuJhWk0Htik3J/[email protected] Before posting, please take a moment to review the archives at http://archive.midrange.com/mapics-l. End of MAPICS-L Digest, Vol 9, Issue 78 *************************************** This email and any files transmitted with it are confidential and intended solely for the use of the individual to whom they are addressed. If you are not the intended recipient, be aware that disclosing, copying, distributing, or taking any action in reliance on the contents of this information is strictly prohibited. Please notify the sender immediately by email if you have received this email in error and delete this email from your system. ------------------------------ message: 2 date: Thu, 23 Jun 2011 13:06:48 -0500 from: Richard Schoen <[email protected]> subject: Re: [MAPICS-L] Data transfer question Try using SQL for this: Example: select lstnam as "Last Name" from qiws/qcustcdt -or- select lstnam as LastName from qiws/qcustcdt Regards, Richard Schoen RJS Software Systems Inc. Where Information Meets Innovation Document Management, Workflow, Report Delivery, Forms and Business Intelligence Email: [email protected] Web Site: http://www.rjssoftware.com Tel: (952) 736-5800 Fax: (952) 736-5801 Toll Free: (888) RJSSOFT -----Original Message----- message: 1 date: Thu, 23 Jun 2011 10:21:23 -0400 from: "Greg Wenzloff" <[email protected]> subject: [MAPICS-L] Data transfer question I need to transfer the contents of a MAPICS file into an Excel spreadsheet. When I do this I get column headings such as ORDNO. Is there something I can do to get different column headings other than the field name. Perhaps ORDER NUMBER. I want to automate this and not go into Excel to adjust column heading each time this transfer is run. Thanks, Greg ------------------------------ ------------------------------ message: 3 date: Thu, 23 Jun 2011 16:02:59 -0600 from: "Weston Wheat" <[email protected]> subject: [MAPICS-L] Integrator question Hello All. Currently we are at R7.8 , with Enterprise Integrator. I been working on a little integrator project of building a QA database for our Quality department. I want to create a RMA number from the Customer Complaint number. Example the Customer Complaint is in the form of CCXXXX and we would like the RMA number to be in the form of RMAXXX. Where XXXX is the same value for the Customer Complaint and the RMA number. I can have the system generate the Customer Complaint number no problem. But I am a little struck on the getting the RMA to generate from the Customer Complaint number. Ideally we would like a little button by the RMA field that would generate the RMA number. Since not all Customer Complaints will have RMA number. Any suggestions? Thanks Weston Wheat. ------------------------------ message: 4 date: Thu, 23 Jun 2011 17:13:09 -0500 from: Kevin.Gerard-IaJHbxZe/[email protected] subject: Re: [MAPICS-L] Integrator question You can do this. First turn on "custom default" for the key/attribute. Then in the default buffer you will get a place to put your own logic. Also on the Action tab over the attribute turn on the "tool bar" button so you get a little button to generate a key manually (request one). Now in the default buffer user exit you can perform your logic to assign the key. An alternate thing to try is to create a logical attribute that would be the generated RMA# using a constant and then concatenated part of the complaint. Then in the template to create RMA you could use "default from related" object and it would then populate based on fact you have relationship from complaint to the RMA database. Hope this makes sense. But your request is not uncommon (to be able to generate a variable key based on business rules) Kevin ------------------------------------------- Kevin Gerard | Senior Technical Consultant | TriMin Systems, Inc | Infor Channel Partner | "Over 25 Years of Dedicated Service to our Customers" | Office 309-932-3103 | Mobile 309-883-1689 | For latest information please visit the System i microsite [1]www.infor.com/systemi SAVE THE DATE | System i User Conference 2011 Gaylord Opryland | Nashville, TN | October 2-5 -----mapics-l-bounces-Zwy7GipZuJhWk0Htik3J/[email protected] wrote: ----- To: <mapics-l-Zwy7GipZuJhWk0Htik3J/[email protected]> From: "Weston Wheat" <[email protected]> Sent by: mapics-l-bounces-Zwy7GipZuJhWk0Htik3J/[email protected] Date: 06/23/2011 05:02PM Subject: [MAPICS-L] Integrator question Hello All. Currently we are at R7.8 , with Enterprise Integrator. I been working on a little integrator project of building a QA database for our Quality department. I want to create a RMA number from the Customer Complaint number. Example the Customer Complaint is in the form of CCXXXX and we would like the RMA number to be in the form of RMAXXX. Where XXXX is the same value for the Customer Complaint and the RMA number. I can have the system generate the Customer Complaint number no problem. But I am a little struck on the getting the RMA to generate from the Customer Complaint number. Ideally we would like a little button by the RMA field that would generate the RMA number. Since not all Customer Complaints will have RMA number. Any suggestions? Thanks Weston Wheat. _______________________________________________ This is the MAPICS ERP System Discussion (MAPICS-L) mailing list To post a message email: MAPICS-L-Zwy7GipZuJhWk0Htik3J/[email protected] To subscribe, unsubscribe, or change list options, visit: [2]http://lists.midrange.com/mailman/listinfo/mapics-l or email: MAPICS-L-request-Zwy7GipZuJhWk0Htik3J/[email protected] Before posting, please take a moment to review the archives at [3]http://archive.midrange.com/mapics-l. References Visible links 1. http://www.infor.com/systemi 2. http://lists.midrange.com/mailman/listinfo/mapics-l 3. http://archive.midrange.com/mapics-l ------------------------------ _______________________________________________ This is the MAPICS ERP System Discussion (MAPICS-L) digest list To post a message email: MAPICS-L-Zwy7GipZuJhWk0Htik3J/[email protected] To subscribe, unsubscribe, or change list options, visit: http://lists.midrange.com/mailman/listinfo/mapics-l or email: MAPICS-L-request-Zwy7GipZuJhWk0Htik3J/[email protected] Before posting, please take a moment to review the archives at http://archive.midrange.com/mapics-l. End of MAPICS-L Digest, Vol 9, Issue 79 *************************************** GKN Aerospace Services This e-mail and any attachments transmitted with it contain information which is confidential, intended solely for the addressee(s) and which may also be privileged or exempt from disclosure under applicable law. If you are not the addressee(s), or have received this e-mail in error, please notify the sender immediately, delete it from your system and do not copy, print, disclose or use any part of it or its attachments. Internet communications are not guaranteed to be secure or free of any virus. The GKN Group does not accept liability for any loss or damage arising in any way from changes to this e-mail or its attachments which may occur in transmission due to network, machine or software failure or manufacturer or operator error, or from unauthorised access or interference with internet communications by any third party or from the transmission of any viruses. Any opinion or other information in this e-mail or its attachments that does not relate to the business of the GKN Group or any part of it is personal to the sender and is not given or in any way endorsed by the GKN Group or any part of it. GKN Aerospace Services Limited is registered in England No. 355922 Registered office: Ferry Road, East Cowes, Isle of Wight, PO32 6RA, EnglandReviewed 21st February 2007 ----------------------------------------------------------------------------------------------------------------------------------------- This email message has been scanned & delivered safely by Mimecast, for more information please visit http://www.mimecast.co.uk ----------------------------------------------------------------------------------------------------------------------------------------- _______________________________________________ This is the MAPICS ERP System Discussion (MAPICS-L) mailing list To post a message email: MAPICS-L-Zwy7GipZuJhWk0Htik3J/[email protected] To subscribe, unsubscribe, or change list options, visit: http://lists.midrange.com/mailman/listinfo/mapics-l or email: MAPICS-L-request-Zwy7GipZuJhWk0Htik3J/[email protected] Before posting, please take a moment to review the archives at http://archive.midrange.com/mapics-l.