Please can anyone share code regarding stop duplicate purchase voucher entry through purchase invoice number not for other vouchers like sales, Debit notes, credit notes.
#Field : VCH Ref] Control : IsTitle : @@ChkVal [Collection : VchrefColl] Type : Voucher Fetch : VoucherNumber , Reference Filter : FltVal [System : Formulas] IsTitle : "ERROR !!"+$$NewLine+$$NewLine+"Duplicate Reference No."+$$NewLine+$$NewLine+"Please Check Invoice No." ChkVal : NOT $$ISEMPTY:$Reference AND $$NumItems:VchrefColl > 0 FltVal : $Reference = #VchRef
This code takes a long time to check the duplicate value. I made the following change, it is working very very fast [#Field : VCH Ref] Control : IsTitle : $$IsDuplicateNumber:$$Value:##VARVchDate