Prev
Next
Forums Integration / Customization IPA/ProcessFlow

Processflow AGS Node

 10 Replies
 0 Subscribed to this topic
 52 Subscribed to this forum
Sort:
Author
Messages
klippe
Basic Member
Posts: 14
Basic Member
2/13/2008 4:53 PM

    I am attempting to execute an AP16 (Vendor Bank) AGS call when the Vendor Bank Identification changes and it is failing.  I determined the AP16 has logic built in that requires an Inquiry first, before the Change can be saved.  How would I do this in Processflow using the AGS Node?

    Any help would be appreciated!  Thanks.

    Here is the AGS call:

     

    AGS Call:

    _PDL=DEV&_TKN=AP16.1&_EVT=CHG&_RTN=DATA&_LFN=ALL&_TDS=IGNORE&FC=Change&VEN-VENDOR-GROUP=1&VEN-VENDOR=4995&VEN-BANK-ENTITY=053000111&VEN-VBANK-IDENT= &VEN-VBANK-ACCT-NO=5114306111&VEN-ACH-PRENOT=A&VEN-VBANK-ACCT-TP=C&VEN-BANK-CURRENCY=USD&CBE-BANK-NAME=My Bank NA&CBE-BRANCH-NAME= &CBE-ADDR1=PO Box 12345&CBE-ADDR2= &CBE-ADDR3= &CBE-ADDR4= &CBE-CITY-ADDR5=Raleigh&CBE-STATE-PROV=NC&CBE-POSTAL-CODE=27611-7886&CBE-COUNTY= &CBE-COUNTRY-CODE= &_DELIM=%09&_OUT=TEXT&_EOT=TRUE

    John Henley
    Posts: 3353
    2/13/2008 6:30 PM
      Inquire is done automatically by AGS when &_EVT=CHG.

      Try setting the _HK hidden field to include the vendor group & vendor number, e.g. &_HK=1%20%20%20%20%20%20%20%204995
      Thanks for using the LawsonGuru.com forums!
      John
      klippe
      Basic Member
      Posts: 14
      Basic Member
      2/13/2008 6:50 PM
        Tried as you suggested...didn't fix the issue. How does the AGS call know what is represented in the _HK value? Is that defined somewhere?
        John Henley
        Posts: 3353
        2/13/2008 6:57 PM
          The _HK is the concatenation of all "key" fields on the form.
          Thanks for using the LawsonGuru.com forums!
          John
          John Henley
          Posts: 3353
          2/13/2008 7:05 PM
            Make sure you are padding the vendor number with spaces (%20) in both VEN-VENDOR and _HK so that it is right-justified. I just tried it and was able to change one.
            Thanks for using the LawsonGuru.com forums!
            John
            klippe
            Basic Member
            Posts: 14
            Basic Member
            2/13/2008 8:18 PM
              Are you sure you are attempting a change with a different Vendor Bank Entity? The different Vendor Bank Entity seems to be the problem...if a change in this field is detected, an Inquire must occur before the Change action.
              John Henley
              Posts: 3353
              2/13/2008 8:27 PM
                Yes, it's working OK. LSF9 / Apps 9.0.
                Thanks for using the LawsonGuru.com forums!
                John
                klippe
                Basic Member
                Posts: 14
                Basic Member
                2/13/2008 8:46 PM
                  I'm working in Processflow 8 / Apps 8. I've put a call into Lawson to see if they have any good solution. It seems to me that the AP16 form is functioning in a way that would never allow an AGS Change to work if the Vendor Bank Entity is different than what was on the database. Not sure why an inquiry is required, since it is pulling data from the CB00.1 screen to display on AP16. The only important piece of info stored in the APVENMAST is the Vendor Bank Entity...so do the change and leave the display of CB00.1 until it's time to refresh the form.

                  Anyway...I appreciate your assistance. Just for good measure, can you post your AGS call out here for me?
                  Khuli
                  New Member
                  Posts: 2
                  New Member
                  6/3/2013 3:49 PM
                    Posted By klippe on 02/13/2008 03:46 PM
                    Just for good measure, can you post your AGS call out here for me?


                    Aplogies for resurrecting a very old thread, but was there a working example of an AGS call? 
                    5 years on and still getting the same issue... either it's rare or I'm a bit dim

                    Only VLO-BANK-ENTITY has changed, and my AGS is:

                    _PDL=AAA&_TKN=AP16.2&_EVT=CHG&FC=C&VLO-VENDOR-GROUP=AAA&VLO-VENDOR=140787&VLO-LOCATION-CODE=PL01&VLO-BANK-ENTITY=INGBPLPW&_HK=AAA    140787PL01&_RTN=DATA&_LFN=ALL&_TDS=IGNORE&_DELIM=%09&_OUT=TEXT&_EOT=TRUE

                    which returns
                    ...
                    <_HK>AAA    140787PL01
                    *** Vender Bank Change, hit change to update
                    105
                    001
                    TC

                    or occasionally

                    <_HK>AAA    140787PL01
                    *** Vendor Bank has changed, must first Inquire
                    102
                    001
                    VLO-BANK-ENTITY
                    Kyle Jorgensen
                    Veteran Member
                    Posts: 122
                    Veteran Member
                    6/3/2013 4:30 PM
                      Here's the AGS we use for AP16.2. We've never experienced a problem (knock on wood)... 

                       _PDL=&_TKN=AP16.2&_RTN=DATA&_LFN=ALL&_TDS=IGNORE&FC=C&VLO-VENDOR-GROUP=&VLO-VENDOR=&VLO-LOCATION-CODE=&VLO-BANK-ENTITY=&VLO-VBANK-ACCT-NO=&VLO-ACH-PRENOT=&VLO-VBANK-ACCT-TP=&_DELIM=%09&_OUT=XML&_EOT=TRUE
                      Khuli
                      New Member
                      Posts: 2
                      New Member
                      6/4/2013 11:36 AM
                        Thank's for that Kyle. It worked on all but one of my recoords (although it actually deleted all the other VLO fields) but I can work around that.
                        The only difference in the code is that yours does not include the _EVT option.