Processflow AGS Node

 10 Replies
 0 Subscribed to this topic
 52 Subscribed to this forum
Sort:
Author
Messages
klippe
Basic Member Send Private Message
Posts: 14
Basic Member

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
Send Private Message
Posts: 3351
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 Send Private Message
Posts: 14
Basic Member
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
Send Private Message
Posts: 3351
The _HK is the concatenation of all "key" fields on the form.
Thanks for using the LawsonGuru.com forums!
John
John Henley
Send Private Message
Posts: 3351
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 Send Private Message
Posts: 14
Basic Member
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
Send Private Message
Posts: 3351
Yes, it's working OK. LSF9 / Apps 9.0.
Thanks for using the LawsonGuru.com forums!
John
klippe
Basic Member Send Private Message
Posts: 14
Basic Member
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 Send Private Message
Posts: 2
New Member
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 Send Private Message
Posts: 122
Veteran Member
Here's the AGS we use for AP16.2. We've never experienced a problem (knock on wood)...

[code] _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 [/code]
Khuli
New Member Send Private Message
Posts: 2
New Member
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.