1. CLICK HERE TO JOIN WHATSAPP CHANNEL FOR TDL PROGRAMS

duplicate ref number blocker

Discussion in 'Tally Developer' started by rke, Jul 3, 2020.

    
  1. rke

    rke Member


    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
     
    rke, Jul 3, 2020
    #1


  2. Amit Kamdar

    Amit Kamdar Administrator Staff Member


    In the ChkVal formula...u can add ........ AND NOT $$InEditMode

    But then the whole purpose will be defeated....as it will allow you duplicates.
     
    Amit Kamdar, Jul 3, 2020
    #2


  3. rke

    rke Member


    ok thank u for help ,any other way to block
     
    rke, Jul 3, 2020
    #3


  4. Amit Kamdar

    Amit Kamdar Administrator Staff Member


    Delete the Voucher and enter it again........
     
    Amit Kamdar, Jul 3, 2020
    #4


Share This Page