Re: Integrator question
Kevin.Gerard-IaJHbxZe/[email protected]
| Newsgroups | gmane.comp.systems.as400.mapics |
|---|---|
| Message-ID | <OFA9205713.1C60B9DF-ON862578B8.007A0E03-862578B8.007A0E03@triminsystems.com> |
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) 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.