Brian: If I understand your model correctly, it's something like this:
hd_ticket--1:1-->purchase_request--1:n-->line_ltem--1:n-->po_number (note this is intended to be a data relationship diagram, not a chronological diagram) As a developer, rather than focusing on making sure the hd_ticket gets the final state of all the related data, I would focus on making sure the data foreign to each table is consistent at all times. Then it doesn't matter if/when they change a foreign data element from a (grand)child record. In this case, applying this idea results in several tasks: 1. any time po_number data is changed, make sure any summary (foreign) data on the line_item parent is accurately reflected 2. any time a line_item changes, make sure any summary data on the purchase_request parent is accurately reflected 3. any time a purchase_request changes, make sure any summary data on the hd_ticket parent is accurately reflected At execution time, you'll have to make sure that 1 (above) completes before 2, and that 2 completes before 3. Implementing this is fairly straightforward except for when concurrent updates from different users can occur. BMC uses tricks like forcing a save on a child record before allowing the manual creation/update of a parent record. To summarize: I'm suggesting re-engineering the workflow to avoid the data sync errors. After all, you have plenty of spare time during your work day, right? :-^ --Phil ________________________________ From: "Sokol, Brian" <bso...@scholastic.com> To: arslist@ARSLIST.ORG Sent: Friday, March 20, 2009 10:45:36 AM Subject: Re: Workflow Order Question ** Workflow Order Question 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:arsl...@arslist.org] On Behalf Of Rick Cook Sent: Friday, March 20, 2009 9:55 AM To: arslist@ARSLIST.ORG 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: <arslist@ARSLIST.ORG> 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:arsl...@arslist.org] On Behalf Of Begosh, Kevin Sent: Thursday, March 19, 2009 6:07 PM To: arslist@ARSLIST.ORG 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 kevin.beg...@lmco.com From:Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Sokol, Brian Sent: Thursday, March 19, 2009 1:30 PM To: arslist@ARSLIST.ORG 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 __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___ __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"
