Who's On?

	Membership:
	Latest: Raju
	Past 24 Hours: 1
	Prev. 24 Hours: 2
	Overall: 5205

	People Online:
	Visitors: 374
	Members: 0
	Total: 374

Name	Points
Greg Moeller	4184
David Williams	3349
JonA	3291
Kat V	2984
Woozy	1973
Jimmy Chiu	1883
Kwane McNeal	1437
Ragu Raghavan	1369
Roger French	1315
mark.cook	1244

AGS call to GL00.4

1 Replies

0 Subscribed to this topic

52 Subscribed to this forum

Sort:

Author

Messages

ryan

Veteran Member

Posts: 51

12/15/2008 3:18 PM

I need to send a notification email whenever a new account is setup on GL00.1. I'm able to find what i need using this query since it is marked on curr-control field by accounting when it is setup.

PROD=&FILE=GLCHARTDTL&INDEX=GDTSET1&KEY=ABC;DEF&FIELD=ACCOUNT;SUB-ACCOUNT;ACCOUNT-DESC;CHART-NAME;SUMRY-ACCOUNT.ACCOUNT-DESC&SELECT=CURR-CONTROL=1&OUT=CSV&DELIM=~

The problem i run into is updating the field CURR-CONTROL back to NO with an AGS call since GL00.4 does not let me choose a method to access the CURR-CONTROL field. I'm using PF PRO 9.0.0.3

Any ideas?

John Henley

Posts: 3353

12/15/2008 3:53 PM

You can try using &FC=C (FC is hidden on that form, but should work)

Frankly, though I don't really like this "solution". If you have Design Studio, you can trigger a ProcessFlow to send an email when an account is added. Remember, however, that when you introduce changes via Design Studio you don't leverage those "enhancements" if you upload via Addins, AGS calls, or use LID. The only option to cover all of those UIs is to create user exits for the affected forms. I am working with a client on a similar project now, to create a more generic audit trail for key forms.