Search code examples
tally

How to export all deleted data from tally using XML

I want to export all deleted masters and vouchers from tally using XML. I got deleted data when download directly from tally. Structure of deleted data portion looks like

</BODY>
 <ELDELETEDLEDNAME>Test Ledger</ELDELETEDLEDNAME>
 <ELDELETEDFLAG>(Deleted)</ELDELETEDFLAG>
 <ELDELETEDLEDNAME>Testing</ELDELETEDLEDNAME>
 <ELDELETEDFLAG>(Deleted)</ELDELETEDFLAG>
</ENVELOPE>
Solution

  • To get all vouchers use below XML

    <ENVELOPE>
    <HEADER>
        <VERSION>1</VERSION>
        <TALLYREQUEST>Export</TALLYREQUEST>
        <TYPE>Collection</TYPE>
        <ID>CusVouchers</ID>
    </HEADER>
    <BODY>
        <DESC>
            <STATICVARIABLES>
                <SVEXPORTFORMAT>$$SysName:XML</SVEXPORTFORMAT>
                <!-- * Supports only xml format -->
                <SVViewName>Accounting Voucher View</SVViewName>
                <SVFROMDATE TYPE="Date">01-Apr-2021</SVFROMDATE>
                <SVTODATE TYPE="Date">31-Mar-2022</SVTODATE>
            </STATICVARIABLES>
            <TDL>
                <TDLMESSAGE>
                    <COLLECTION ISMODIFY="No" ISFIXED="No" ISINITIALIZE="Yes" ISOPTION="No" ISINTERNAL="No" NAME="CusVouchers">
                        <TYPE>Voucher</TYPE>
                        <FETCH> *</FETCH>
                        <IncludeDeleted>Yes</IncludeDeleted>
                        <FILTER>DeleteFilter</FILTER>
                    </COLLECTION>
                    <SYSTEM TYPE="Formulae" NAME="DeleteFilter">$ISDELETED = Yes</SYSTEM>
    
                </TDLMESSAGE>
            </TDL>
        </DESC>
    </BODY>
</ENVELOPE>

    Use want to get deletes Masters then replace the type with mastertype

    Ex: if you want deleted Ledgers then <TYPE>Ledgers</TYPE> enter image description here This is what used in TDL