Export Vouchers from Tally using specific Stock Item

Discussion in 'Free Source Codes' started by Rutal Jadav, Aug 29, 2023.

    
  1. Rutal Jadav

    Rutal Jadav Member


    I am using the below-mentioned XML to export vouchers from the tally. Can we export Vouchers from the tally using specific stock Items available in Vouchers?

    For Example, I want to export all vouchers from the tally for a specific item (Item1) between from and to date.

    <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 -->
    <SVCURRENTCOMPANY>Company Name</SVCURRENTCOMPANY>
    <SVViewName>Accounting Voucher View</SVViewName>
    <SVFROMDATE TYPE="Date">20230401</SVFROMDATE>
    <SVTODATE TYPE="Date">20240331</SVTODATE>
    </STATICVARIABLES>
    <TDL>
    <TDLMESSAGE>
    <COLLECTION ISMODIFY="No" ISFIXED="No" ISINITIALIZE="Yes" ISOPTION="No" ISINTERNAL="No" NAME="CusVouchers">
    <TYPE>Voucher</TYPE>
    <FETCH>*,ALLINVENTORYENTRIES,LEDGERENTRIES,ALLLEDGERENTRIES</FETCH>
    <FILTER>AlterIdFilter</FILTER>
    </COLLECTION>
    <SYSTEM TYPE="Formulae" NAME="AlterIdFilter">$AlterID &gt; 0</SYSTEM>
    </TDLMESSAGE>
    </TDL>
    </DESC>
    </BODY>
    </ENVELOPE>
     


  2. Sai Vineeth

    Sai Vineeth Active Member


    You can use
    Code:
    <TYPE>Vouchers    : StockItem</TYPE>
    <ChildOf> StockItemName</ChildOf>
    
     


Share This Page