GL45 conditional rule for HOLD_CODE

Sort:
You are not authorized to post a reply.
Author
Messages
Alex Shklovsky
Basic Member
Posts: 11
Basic Member

     Hello everyone

    I'm trying to write a conditional rule for GL45 to allow user change one hold code, but no change if attempts to change other hold codes.

    Getting a security violation message on a hold code that should be accessible based on my rule. Would you guys advise on what am I doing wrong? 

    trim(getDBField('GLCONTROL','HOLD_CODE',form.GLC_COMPANY,form.GLC_FISCAL_YEAR,form.GLC_ACCT_PERIOD,form.AB_GLC_SYSTEM,form.AB_GLC_JE_TYPE,form.AB_GLC_CONTROL_GROUP,form.AB_GLC_JE_SEQUENCE))=='SCMH'||trim(form.SEL_HOLD_CODE)=='SCMH'||trim(getDBField('GLCONTROL','HOLD_CODE',form.GLC_COMPANY,form.GLC_FISCAL_YEAR,form.GLC_ACCT_PERIOD,form.AB_GLC_SYSTEM,form.AB_GLC_JE_TYPE,form.AB_GLC_CONTROL_GROUP,form.AB_GLC_JE_SEQUENCE))=='    '||trim(form.SEL_HOLD_CODE)=='   ' then ALL_ACCESS else +,-,I,F,B

    Thanks for your advise

    Alex

    Alex Shklovsky
    Basic Member
    Posts: 11
    Basic Member
      This one is resolved. My problem was in writing it against GL45.1 token directly, should be DTO group of fields on FC line that makes all GLC_ prefixed fields available to get proper values
      You are not authorized to post a reply.