1. CLICK HERE TO JOIN WHATSAPP CHANNEL FOR TDL PROGRAMS

How to Stop Duplicate Voucher Reference Number

Discussion in 'Tally Developer' started by pradeep kumar dewangan, Dec 29, 2014.

    
  1. pradeep kumar dewangan

    pradeep kumar dewangan Member


    How to Stop Duplicate Voucher Reference Number

    Like Voucher Number
     
    pradeep kumar dewangan, Dec 29, 2014
    #1


  2. Sangam

    Sangam New Member


    Use below 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
     
    Sangam, Jan 28, 2015
    #2


  3. pradeep kumar dewangan

    pradeep kumar dewangan Member


    ;Use below 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

    Very Very Thank u & nice code sir,
    ONCE idea share to u, Control in
    In [#Field: VCH Particulars], when Equal Voucher Number = LedgerName then use control "Duplicate Reference No"
    Please apply and new code send us
    again thank to u
     
    pradeep kumar dewangan, Jan 29, 2015
    #3


Share This Page