• Search Forums
    Advanced Search Topics Posts
Prev
Next
Forums Integration / Customization IPA/ProcessFlow

IPA and GL20 Automate Posting account

 6 Replies
 2 Subscribed to this topic
 52 Subscribed to this forum
Sort:
Author
Messages
Randy
Veteran Member Send Private Message
Posts: 50
Veteran Member
11/21/2016 1:18 PM

Can I use IPA to automate adding an account in GL20? I have COMPANY,ACCT_UNIT,ACCOUNT & SUB_ACCOUNT coming from budget System. I use IPA to load (FB165), but sometimes the accounts are not turned on for a given Company/Acct Unit. I could do a test to see what accounts are not in the GLMASTER, but how can I add them, as the GL20 does?

 

 

David Williams
Veteran Member Send Private Message
Posts: 1127
Veteran Member
11/21/2016 1:29 PM
You can from GL20.2 by passing in the Company and Accounting Unit and using the position to (PT-GDT-ACCOUNT) field and an Add on LINE-FCr0
David Williams
Randy
Veteran Member Send Private Message
Posts: 50
Veteran Member
11/21/2016 2:11 PM
I tried this, using the Lawson Transaction Node and choosing IF & GL20.2 form. I see the Account , Sub Account and Fcr0  fields, but where is COMPANY and ACCT UNIT?
Bob Canham
Veteran Member Send Private Message
Posts: 217
Veteran Member
11/21/2016 2:19 PM
those are in fields f7 and f8
David Williams
Veteran Member Send Private Message
Posts: 1127
Veteran Member
11/21/2016 2:23 PM
You can determine the fields from GL20.1 - company is GLN-COMPANY and AU is GLN-ACCT-UNIT - but you will have to edit your AGS call to include these values since the GL20.2 form accepts these from the GL20.1 form. This isn't a well known solution but any sub-form that receives header data from the primary form should be able to accept these values when you include them in the AGS call.
David Williams
Randy
Veteran Member Send Private Message
Posts: 50
Veteran Member
11/21/2016 2:47 PM

Thanks. Thought I was going crazy and not finding them as part of the GL20.2. I'll have a go at it and see what I can do. Stay tuned.

 

Randy
Veteran Member Send Private Message
Posts: 50
Veteran Member
11/21/2016 3:30 PM
It worked. Thanks so much everybody.