PrevPrev Go to previous topic
NextNext Go to next topic
Last Post 05/08/2015 3:39 PM by  Alex Shklovsky
GL45 conditional rule for HOLD_CODE
 1 Replies
Sort:
You are not authorized to post a reply.
Author Messages
Alex Shklovsky
Lawson System Administrator
Cook County Hospital
Basic Member
(25 points)
Basic Member
Posts:11


Send Message:

--
04/24/2015 3:19 PM

     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
    Lawson System Administrator
    Cook County Hospital
    Basic Member
    (25 points)
    Basic Member
    Posts:11


    Send Message:

    --
    05/08/2015 3:39 PM
    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.