Prev
Next
Forums Integration / Customization IPA/ProcessFlow

Update the subform of its main form

 5 Replies
 0 Subscribed to this topic
 52 Subscribed to this forum
Sort:
Author
Messages
wintergreen
Veteran Member
Posts: 93
Veteran Member
8/24/2009 5:52 PM

    How to make a transaction call to update a child form (subform) which depends on the update of its parent form? 

    For example:
                  For service PO, when users change the QTY from 2 to 1 on PO20.1, and service code  from Q (quantity and cost) to A ( Amount). The PO20.1 will jump to PO20.3 and ask you to change the “Exclude from AOC’ from N to Y.  In the process flow,  we can change the QTY and Service code on PO20.1 but don’t know how to make an update on its childform which is PO20.3 as well? This PO was unable to update sucessfully if we didn't update the field on PO20.3.  

    Any help will be much appreciated. Thanks!

    David Williams
    Veteran Member
    Posts: 1127
    Veteran Member
    8/24/2009 8:47 PM
      You can just add the field reference from the sub-form to your Transaction (AGS) call like:
      &PLI-EXCL-AOC-SPRD=Y
      David Williams
      wintergreen
      Veteran Member
      Posts: 93
      Veteran Member
      8/25/2009 12:31 PM
        David, thanks for the great help. The PO was able to update sucessfully through process flow but the PLI-EXCL-AOC-SPRD is actually not updated in the database. It seems that when we put the PLI-EXCL-AOC-SPRD=Y in the Transaction call on PO20.1 form, it will skip the validation of PO20.3 but it actually was not updated the PLI-EXCL-APC-SPRD in the PO20.3. Lawson Amount type service items are always excluded from AOC, so the PLI-EXCL-AOC-SPRD should be updated to Y in the database. I'm thinking the only way to update the field on PO20.3 is through table update because there is no change function on PO20.3 form. I don't know how people deal with the situation when changing something on the main form, it also involves its subform which doesn't have any change, delete, or add function on the form. No method we can use but change the field through table, I guess. Is there anyone who ever encounters this issue?

        Any input will be much appreciated. Thanks!!
        Gary Davies
        Veteran Member
        Posts: 248
        Veteran Member
        8/25/2009 12:49 PM
          The PO20.3 screen has hidden fields that need to be populated,  probably PCY-PROCEDURE-GROUP and definitely PLI-LINE-NBR,  when you are on PO20.1 and get passed to the form PO20.1 is doing this automatically so you have to manually simulate this when doing an AGS call to PO20.3 on its own, remember to populate the other key fields as well.
          wintergreen
          Veteran Member
          Posts: 93
          Veteran Member
          8/25/2009 1:53 PM
            Lawson instructor replied me, "the form includes the DTO or detail line options, you must simulate with a FC call for the lines requiring an adding"... I don't know how to add DTO into a PF string into a single transaction. Any idea?

            Thanks!
            Vanessa
            wintergreen
            Veteran Member
            Posts: 93
            Veteran Member
            8/25/2009 5:36 PM
              The problem was resolved. I didn't define an occours for PLI-EXCL-AOC-SPRD=Y correctly. It should PLI-EXCL-AOC-SPRDr0=Y. So the process flow didn't take the value... Thanks for you guys. Have a good day!!