Securing AP 90 by Acct Unit

 6 Replies
 0 Subscribed to this topic
 15 Subscribed to this forum
Sort:
Author
Messages
Carla Ferrari
Posts: 5
    We are trying to secure AP90 by users' accounting units, using the RM attribut AccountingUnitControl.  Tried writing a rule against APDISTRIB, DIS-ACCT-UNIT file using
    getDBfield, with no luck.  Has anyone else tried to secure this form?  
    EricS
    Veteran Member
    Posts: 80
    Veteran Member
      Carla, I was asked to secure AP95, not AP90. I ended up using the code below on GLNAMES. If there's a better way, I'd love to hear about it. You may be able to adapt it to AP90?

      if(user.attributeContains('AccountingUnitControl',table.ACCT_UNIT))
      'I'
      else
      'NO_ACCESS'
      Carla Ferrari
      Posts: 5
        Thanks, Eric!  I'll try adapting this to AP90. 
        EricS
        Veteran Member
        Posts: 80
        Veteran Member
          If you can adapt it, would you mind posting the solution back here? I'm guessing that someone is going to want me to do the same thing eventually. Ha!
          Carla Ferrari
          Posts: 5
            HI Eric, I was not able to adapt your scenario to AP90, however I have not given up.  I will continue to reach out to my contacts and find the solution.  When I do, I will share.  Thanks again for your input!
            Karen Beyer Goode
            Basic Member
            Posts: 4
            Basic Member

              Create an index on the table APDSET1

               

              user.attributeContains('AccountingUnitControl',getDBFieldByIdx('APDISTRIB','DIS-ACCT-UNIT','APDSET1',form.DIST-COMPANY,form.DIS-ACCT-UNIT))

              Karen Beyer Goode
              Basic Member
              Posts: 4
              Basic Member

                Create an index on the table APDSET1

                 

                user.attributeContains('AccountingUnitControl',getDBFieldByIdx('APDISTRIB','DIS-ACCT-UNIT','APDSET1',form.DIST-COMPANY,form.DIS-ACCT-UNIT))