Personalization

Hi,

Trying to form personalization at ap invoice distribution level, (Want to restrict an account  as  not to enter manually), applied the below condition, could not get the expected result.

Triiger Event : WHEN-VALIDATE-RECORD

Trigger Object : INV_SUM_ACTIONS

Condition :

(SELECT COUNT (*)

  FROM gl_code_combinations gcc,

       ap_invoice_distributions_all aida

WHERE gcc.code_combination_id = aida.dist_code_combination_id

   AND aida.invoice_id = :INV_SUM_FOLDER.INVOICE_ID

   AND aida.DIST_MATCH_TYPE='NOT_MATCHED'

   AND gcc.segment4 = '1613002')>=1

and :INV_SUM_ACTIONS.APPROVE = 'N'

Processing Mode ; Not in Enter-Query Mod

Actions

Seq.  Type            Lang          Enabled

1.        Message    ALL             yes                         Message Type : Error:  Message Text  "You Cannot process this account"