DUPLICATE PURCHASE TDL

Discussion in 'Free Source Codes' started by Rohitmeharia, Oct 9, 2019.

    
  1. Rohitmeharia

    Rohitmeharia New Member


    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.
     


  2. sandeep76out

    sandeep76out New Member


    #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
     


  3. Rohitmeharia

    Rohitmeharia New Member



  4. Hari Malhotra

    Hari Malhotra New Member


    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
     


  5. Mac

    Mac Member




    if i want to check if gstinnumber duplication , then what should i do ?
     


Share This Page