Rick here is what I am doing. I have a purchase request form which has a table linked to a subform. The subform contains the items purchased on the purchase request. Our purchasing department goes in and adds the JD Edwards PO number to each line item at the time of purchase. Some purchase requests have more then one PO number. When the purchasing department has placed the order they click on a button to generate a HD ticket. Here is the order of the workflow: AL sets a flag on each line item for that purchase request Filter fires on modify for the line item table and pushes the PO number to a temp field on the purchase request form Filter fires on modify on the purchase request form on modify and copies the temp Po info to the PO field (PO = PO + PO Temp) AL fires and does a Push to create the HD tkt I know I could copy the PO numbers at the time they are set but I am afraid that the purchasing dept will make a mistake and then change a PO number. Then I would have both the old and new PO number. By doing it at the time of HD tkt creation I know I have the final numbers. The workflow log shows the PO numbers being set on the purchase request form: PO Number (536870952) = 12345 98765 and then the HD tkt being created but the PO number is not copied: <ACTL> (240000007) = PR0000000001333 Placed. The PO #(s) for this order are That is why I questioned if the log timings were accurate. Brian
________________________________ From: Action Request System discussion list(ARSList) [mailto:[email protected]] On Behalf Of Rick Cook Sent: Friday, March 20, 2009 9:55 AM To: [email protected] Subject: Re: Workflow Order Question ** Actually, people use LastId for that exact purpose all the time. Rick Sent from my Verizon Wireless BlackBerry ________________________________ From: "Sokol, Brian" Date: Fri, 20 Mar 2009 09:13:02 -0400 To: <[email protected]> Subject: Re: Workflow Order Question Hi Kevin, No I can not use that. I need this at the time the tkt is created so that it is part of the email that is sent out at tkt creation. My original question is about workflow timing and the log file. Do the events occur in the same order as they appear in the log? The logs show the PO numbers getting populated before the HD tkt creation but they are not being pushed to the HD tkt at creation. ________________________________ From: Action Request System discussion list(ARSList) [mailto:[email protected]] On Behalf Of Begosh, Kevin Sent: Thursday, March 19, 2009 6:07 PM To: [email protected] Subject: Re: Workflow Order Question ** I am sure someone will tell me if I am wrong but I think you might be able to use the last ID keyword.. I think Kevin Begosh, RSP Tech Ops Enterprise Business Services 301-791-3540 Phone 410-422-3623 Cell [email protected] From: Action Request System discussion list(ARSList) [mailto:[email protected]] On Behalf Of Sokol, Brian Sent: Thursday, March 19, 2009 1:30 PM To: [email protected] Subject: Workflow Order Question ** We have a custom purchasing application in Remedy. At the end of the purchasing process a Help Desk ticket (HD 5.6) is created. I am trying to populate the description field with our back end purchase order number. The Remedy purchase request may have more then 1 PO#. At the time that the HD tkt is created I am populating a field on the purchasing form with the PO numbers (they are on a sub form). The description field is not getting the PO number. I thought this was might be caused by the HD tkt being created before I populate the field with the PO numbers. I turned on AL and Filter logging and according to the logs the PO field is being populated and then the HD tkt is being created. So is the timing in the logs accurate? If so any idea why this is happening? Brian Sokol Manager, Desktop Services Scholastic Inc. 557 Broadway NY, NY 10012 (212) 343-6494 http://www.Scholastic.com <http://www.Scholastic.com> __Platinum Sponsor: RMI Solutions ARSlist: "Where the Answers Are" html___ __Platinum Sponsor: RMI Solutions ARSlist: "Where the Answers Are" html___ __Platinum Sponsor: RMI Solutions ARSlist: "Where the Answers Are" html___ _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: RMI Solutions ARSlist: "Where the Answers Are"
