Receipt Form Personalization
Hi,
I done personalization in receipts form at Oracle Receivables Responsibility.
My personalization goal is receipt number filed will not allow duplicates for that I did like :
Trigger Event : WHEN-VALIDATE-RECORD
Trigger Object : RGW_FOLDER
Condition : 0<>(select count(*) from ar_cash_receipts_all a where a.RECEIPT_NUMBER=:RGW_FOLDER.M_RECEIPT_NUMBER) and :system.record_status='INSERT'
Seq : 10
Type : Message
Message Type : Error
Message Text : Please enter unique Teller Number
Its 100% working fine.
but when they are going reverse existing receipt, it's giving error. pls help me on this.
Thanks & Regards
Naveen.
1