its block duplicate ref number ,but if i edit voucher its block how can edit earlier voucher created any one correct the code [#Field : VCH Ref] Control : IsTitle : @@ChkVal [Collection : VchrefColl] Type : Voucher Fetch : VoucherNumber , Reference Filter : FltVal [System : Formulas] IsTitle : "ERROR !!"+$$NewLine+$$NewLine+"Duplicate Reference No" ChkVal : NOT $$ISEMPTY:$Reference AND $$NumItems:VchrefColl > 0 FltVal : $Reference = #VchRef
In the ChkVal formula...u can add ........ AND NOT $$InEditMode But then the whole purpose will be defeated....as it will allow you duplicates.