How to delete all Vouchers from Tally Using TDL

Discussion in 'Tally Integration' started by Vinothkumar S, Sep 13, 2012.

         
  1. Vinothkumar S

    Vinothkumar S New Member


    Hello,
    i need to delete all the vouchers in tally using tdl program. can you please help me to get this one.


    Thanks in advance
     



  2. admin

    admin Administrator Staff Member


    Why do you need TDL Code.

    In Day book, Give full date range and Select all Vouchers and Delete
     



  3. Vinothkumar S

    Vinothkumar S New Member


    Hello sir,
    Thanks for you reply. I need to delete all vouchers by checking a Logical UDF value.
    This logical field is used identify vouchers created by external application.
    I need to delete all the vouchers created by external application.
    so please help me achieve this one.

    Thanks in advance
     



  4. admin

    admin Administrator Staff Member


    It is very simple.
    In the day book, write a filter in the collection to fetch the records which has that UDF value

    Then delete all those vouchers

    EX: [#Collection : Daybook Vouchers of Company]
    FIlter: My FIlter

    [System : Formula]
    My Filter : Not $$IsEmpty:$UDFValue

    This is just example to give an idea
     
    Vinothkumar S likes this.



  5. Vinothkumar S

    Vinothkumar S New Member


    Thanks for your reply.

    Is there any way to delete vouchers using tdl? how to delete vouchers through tdl?

    Thank you
     



  6. admin

    admin Administrator Staff Member


    What ever it is , you need to delete using manual only?
     



  7. Mahesh kundla

    Mahesh kundla New Member


    I want to delete specfic vouchers through Excel sheet, i will mention voucherno,vouchertypename in excel sheet.
    now , my doubt is how i make to delete vouchers using masterid through TDL Code...if Any body know ...give me solution in tdl programming level
     





  8. Its possible...
     



  9. Mahesh kundla

    Mahesh kundla New Member


    just suggest process ....please....now i am finding masterid ....through in function ,what i need to use to delete specfic voucher in function
     



  10. admin

    admin Administrator Staff Member


    This can be done from release 5.0 onwards. Tally introducted direct object deletion facility. The sample code is available in Sample TDLs. You can directly refer
     



  11. Joharfchhil

    Joharfchhil Member


    VinodtKumar,

    Here is TDL for deleting vouchers from Tally, You have to select the voucher by pressing <Space Bar> then Delete Button it will deleted selected voucher:

    [#Key: BottomToolBarBtn3]

    Option : VoucherDeleter : Yes

    [#Key: Delete Line Object]

    Option : VoucherDeleter : Yes

    [#Key: Delete Line ObjectEx]

    Option : VoucherDeleter : Yes

    [!Key : VoucherDeleter]

    Key : Alt + D
    Action List : key2


    [Key : key2]

    Title : "Delete"
    Key : Alt + D
    Action : Delete Object
     






  12. admin

    admin Administrator Staff Member


    Release 5.0, introduces the function action 'Delete Target' with which, we can easily delete the primary objects.
    'Masters can be deleted only if it is not used. For example, if there is a Master under which, no transaction has been passed, then it can be deleted. If a transaction has been passed for the same Master, then it cannot be deleted.'
    To illustrate the same, take a case where all the unused ledgers with zero opening balance needs to be deleted. Here, 'Delete Target' can easily remove the ledgers with the code snippet as shown below.
    [​IMG]
     

    Attached Files:




  13. MIttal Sharma

    MIttal Sharma New Member


    Hi Vinoth Kumar ,

    Use XML Schema for Deleting Voucher through Excel to Tally
    fist put the Voucher no and Date in Excel file and covert the XML format after than import the xml file.
    Automatic deleted vouchers.
    XML Schema
    ;;;;;
    <?xml version="1.0" encoding="UTF-8" standalone="yes"?>
    <ENVELOPE xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance">
    <BODY>
    <DATA>
    <TALLYMESSAGE>
    <VOUCHER DATE="1-Apr-2014" TAGNAME="Voucher Number" TAGVALUE="INB00063" VCHTYPE="Payment" ACTION="Delete">
    <NARRATION>Being cancelled due to XYZ Reasons</NARRATION>
    </VOUCHER>
    <VOUCHER DATE="1-Apr-2014" TAGNAME="Voucher Number" TAGVALUE="INB00064" VCHTYPE="Payment" ACTION="Delete">
    <NARRATION>Being cancelled due to XYZ Reasons</NARRATION>
    </VOUCHER>
    </TALLYMESSAGE>
    </DATA>
    </BODY>
    </ENVELOPE>
     



  14. Mahesh kundla

    Mahesh kundla New Member


    Hello sir if it possible to update forex currency rate in vouchers ,without opening the vouchers, how we can update in tally with tdl program
     



  15. aliasgar khanrahim

    aliasgar khanrahim New Member


    TAGNAME and TAGVALUE do work but VCHTYPE doesn't. It deletes the 1st voucher if there are 2 vouchers with same number in the given date. No Effect of VCHTYPE="Sales"
     



  16. mythilimythu

    mythilimythu New Member


    hai.. i want to delete voucher using function. pls help me
     



Share This Page