1. CLICK HERE TO JOIN WHATSAPP CHANNEL FOR TDL PROGRAMS

How to get voucher list of specific voucher type in tally via soap request

Discussion in 'Tally Integration' started by anupganatra, Jan 15, 2016.

    
Tags:
  1. anupganatra

    anupganatra New Member


    Hi,

    I am using following SOAP request to get voucher for specific dates.

    <ENVELOPE>
    <HEADER>
    <VERSION>1</VERSION>
    <TALLYREQUEST>Export</TALLYREQUEST>
    <TYPE>Collection</TYPE>
    <ID>Day Book</ID>
    </HEADER>
    <BODY>
    <DESC>
    <STATICVARIABLES>
    <SVFROMDATE TYPE="Date">dd-MMM-yyyy</SVFROMDATE>
    <SVTODATE TYPE="Date">dd-MMM-yyyy</SVTODATE>
    <EXPLODEFLAG>Yes</EXPLODEFLAG>
    <SVEXPORTFORMAT>$$SysName:XML</SVEXPORTFORMAT>
    </STATICVARIABLES>
    <TDL>
    <TDLMESSAGE>
    <COLLECTION NAME="Day Book" ISMODIFY="No">
    <TYPE>Voucher</TYPE>
    <FETCH>Vouchernumber</FETCH>
    </COLLECTION>
    </TDLMESSAGE>
    </TDL>
    </DESC>
    </BODY>
    </ENVELOPE>

    With this SOAP request I am getting all type of vouchers like Receipt, Payment, Debit Note in response. I just want to get only particular voucher type in my response.

    What I need to add in SOAP request to get voucher of particular voucher types only???
     
    anupganatra, Jan 15, 2016
    #1


  2. s.srini

    s.srini New Member


    You Can Try this..


    VoucherTypeName Tag for Your Voucher Type


    <ENVELOPE>
    <HEADER>
    <VERSION>1</VERSION>
    <TALLYREQUEST>Export</TALLYREQUEST>
    <TYPE>Collection</TYPE>
    <ID>Day Book</ID>
    </HEADER>
    <BODY>
    <DESC>
    <STATICVARIABLES>
    <SVFROMDATE TYPE="Date">dd-MMM-yyyy</SVFROMDATE>
    <SVTODATE TYPE="Date">dd-MMM-yyyy</SVTODATE>
    <EXPLODEFLAG>Yes</EXPLODEFLAG>
    <SVEXPORTFORMAT>$$SysName:XML</SVEXPORTFORMAT>
    </STATICVARIABLES>
    <TDL>
    <TDLMESSAGE>
    <COLLECTION NAME="Day Book" ISMODIFY="No">
    <TYPE>Voucher</TYPE>
    <FETCH>Vouchernumber</FETCH>

    <FILTERS>VTYPE</FILTERS>

    </COLLECTION>

    <SYSTEM TYPE="Formulae" NAME="VTYPE>
    $VOUCHERTYPENAME equal to "Your Voucher Type Name"
    </SYSTEM>


    </TDLMESSAGE>
    </TDL>
    </DESC>
    </BODY>
    </ENVELOPE>



    for more help on TDL Tally XML request visit http://coimbatore-biz.com/blog/techsupport/Tally Request XMLs

     
    s.srini, Jan 30, 2017
    #2


Share This Page