Export deleted voucher's masterId using XML from tally

Discussion in 'Tally & TDL Learning HUB' started by Rutal Jadav, Mar 3, 2023.

    
  1. Rutal Jadav

    Rutal Jadav Member


    I am using the below-mentioned XML to export deleted vouchers' masterId's. Not getting desired response from the tally.

    <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">11-Nov-2022</SVFROMDATE>
    <SVTODATE TYPE="Date">11-Nov-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>

    Current Output :
    <ENVELOPE>
    <HEADER>
    <VERSION>1</VERSION>
    <STATUS>1</STATUS>
    </HEADER>
    <BODY>
    <DESC>
    <CMPINFO>
    <COMPANY>0</COMPANY>
    <GROUP>0</GROUP>
    <LEDGER>3</LEDGER>
    <COSTCATEGORY>0</COSTCATEGORY>
    <COSTCENTRE>0</COSTCENTRE>
    <GODOWN>2</GODOWN>
    <STOCKGROUP>0</STOCKGROUP>
    <STOCKCATEGORY>0</STOCKCATEGORY>
    <STOCKITEM>1</STOCKITEM>
    <VOUCHERTYPE>1</VOUCHERTYPE>
    <CURRENCY>1</CURRENCY>
    <UNIT>0</UNIT>
    <BUDGET>0</BUDGET>
    <CLIENTRULE>0</CLIENTRULE>
    <SERVERRULE>0</SERVERRULE>
    <STATE>0</STATE>
    <TDSRATE>0</TDSRATE>
    <TAXCLASSIFICATION>0</TAXCLASSIFICATION>
    <STCATEGORY>0</STCATEGORY>
    <DEDUCTEETYPE>0</DEDUCTEETYPE>
    <ATTENDANCETYPE>0</ATTENDANCETYPE>
    <FBTCATEGORY>0</FBTCATEGORY>
    <FBTASSESSEETYPE>0</FBTASSESSEETYPE>
    <TARIFFCLASSIFICATION>0</TARIFFCLASSIFICATION>
    <EXCISEDUTYCLASSIFICATION>0</EXCISEDUTYCLASSIFICATION>
    <SERIALNUMBER>0</SERIALNUMBER>
    <ADJUSTMENTCLASSIFICATION>0</ADJUSTMENTCLASSIFICATION>
    <INCOMETAXSLAB>0</INCOMETAXSLAB>
    <INCOMETAXCLASSIFICATION>0</INCOMETAXCLASSIFICATION>
    <LBTCLASSIFICATION>0</LBTCLASSIFICATION>
    <TAXUNIT>0</TAXUNIT>
    <RETURNMASTER>0</RETURNMASTER>
    <VOUCHER>1</VOUCHER>
    </CMPINFO>
    </DESC>
    <DATA>
    <COLLECTION ISCMPDEPTYPE="Yes" CMPLOCUS="4" CMPDEPTYPE="64"> </COLLECTION>
    </DATA>
    </BODY>
    </ENVELOPE>


    Required Output:

    <ENVELOPE>
    <HEADER>
    <VERSION>1</VERSION>
    <STATUS>1</STATUS>
    </HEADER>
    <BODY>
    <DESC>
    <CMPINFO>
    <COMPANY>0</COMPANY>
    <GROUP>0</GROUP>
    <LEDGER>3</LEDGER>
    <COSTCATEGORY>0</COSTCATEGORY>
    <COSTCENTRE>0</COSTCENTRE>
    <GODOWN>2</GODOWN>
    <STOCKGROUP>0</STOCKGROUP>
    <STOCKCATEGORY>0</STOCKCATEGORY>
    <STOCKITEM>1</STOCKITEM>
    <VOUCHERTYPE>1</VOUCHERTYPE>
    <CURRENCY>1</CURRENCY>
    <UNIT>0</UNIT>
    <BUDGET>0</BUDGET>
    <CLIENTRULE>0</CLIENTRULE>
    <SERVERRULE>0</SERVERRULE>
    <STATE>0</STATE>
    <TDSRATE>0</TDSRATE>
    <TAXCLASSIFICATION>0</TAXCLASSIFICATION>
    <STCATEGORY>0</STCATEGORY>
    <DEDUCTEETYPE>0</DEDUCTEETYPE>
    <ATTENDANCETYPE>0</ATTENDANCETYPE>
    <FBTCATEGORY>0</FBTCATEGORY>
    <FBTASSESSEETYPE>0</FBTASSESSEETYPE>
    <TARIFFCLASSIFICATION>0</TARIFFCLASSIFICATION>
    <EXCISEDUTYCLASSIFICATION>0</EXCISEDUTYCLASSIFICATION>
    <SERIALNUMBER>0</SERIALNUMBER>
    <ADJUSTMENTCLASSIFICATION>0</ADJUSTMENTCLASSIFICATION>
    <INCOMETAXSLAB>0</INCOMETAXSLAB>
    <INCOMETAXCLASSIFICATION>0</INCOMETAXCLASSIFICATION>
    <LBTCLASSIFICATION>0</LBTCLASSIFICATION>
    <TAXUNIT>0</TAXUNIT>
    <RETURNMASTER>0</RETURNMASTER>
    <VOUCHER>1</VOUCHER>
    </CMPINFO>
    </DESC>
    <DATA>
    <COLLECTION ISCMPDEPTYPE="Yes" CMPLOCUS="4" CMPDEPTYPE="64">
    <VOUCHER>
    <MASTERID>201</MASTERID>
    </VOUCHER>

    </COLLECTION>
    </DATA>
    </BODY>
    </ENVELOPE>
     


  2. Sai Vineeth

    Sai Vineeth Active Member


    Default Tally xml response does not return MasterId when you send delete action.
    If you want to change that you need to customize using TDL
     


  3. Rutal Jadav

    Rutal Jadav Member


    Can you guide me or show me that TDL how can I archive that?
     


  4. Sai Vineeth

    Sai Vineeth Active Member



Share This Page