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.