• 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
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
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
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
Posts: 217
Veteran Member
11/21/2016 2:19 PM
those are in fields f7 and f8
David Williams
Veteran Member
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
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
Posts: 50
Veteran Member
11/21/2016 3:30 PM
It worked. Thanks so much everybody.