1. CLICK HERE TO JOIN WHATSAPP CHANNEL FOR TDL PROGRAMS

Only Export Required Fields from the Vouchers

Discussion in 'Tally Integration' started by K.Senthil Babu, Jan 24, 2019.

    
Tags:
  1. K.Senthil Babu

    K.Senthil Babu New Member


    Respected Experts,

    When i export, tally outputs all the fields, please guide how to export only the required field

    Code:
    <ENVELOPE>
    <HEADER>
    <VERSION>1</VERSION>
    <TALLYREQUEST>EXPORT</TALLYREQUEST>
    <TYPE>COLLECTION</TYPE>
    <ID>COL_SALES_VOUCHERS</ID> 
    </HEADER>
    <BODY>
    <DESC>
    <STATICVARIABLES>
    <VoucherTypeName>Sales</VoucherTypeName>
    <SVEXPORTFORMAT>$$SysName:XML</SVEXPORTFORMAT>
    <SVFROMDATE TYPE="Date">20180401</SVFROMDATE>
    <SVTODATE TYPE="Date">20180431</SVTODATE>
    </STATICVARIABLES>   
      <TDL> 
        <TDLMESSAGE> 
          <COLLECTION NAME="COL_SALES_VOUCHERS" ISINITIALIZE="Yes"> 
              <TYPE>Voucher</TYPE> 
              <FETCH>Voucher.$PARTYLEDGERNAME</FETCH> 
              <FETCH>Voucher.$VOUCHERTYPENAME</FETCH> 
              <FETCH>Voucher.$DATE</FETCH> 
              <FETCH>Voucher.$VOUCHERNUMBER</FETCH> 
              <FETCH>Voucher.$REFERENCE</FETCH> 
              <FETCH>LEDGERENTRIES.$AMOUNT</FETCH> 
          </COLLECTION> 
        </TDLMESSAGE> 
      </TDL>     

    </DESC>
    </BODY>
    </ENVELOPE>
    Thanks in Advance
     
    K.Senthil Babu, Jan 24, 2019
    #1


  2. K.Senthil Babu

    K.Senthil Babu New Member


    Thanks for all supporting me.

    Finally found out how to export the vouchers using xml export

    Code:
    <ENVELOPE>
    <HEADER>
        <VERSION>1</VERSION>
        <TALLYREQUEST>Export</TALLYREQUEST>
        <TYPE>Data</TYPE>
        <ID>Voucher Sales Receipt</ID>
    </HEADER>
    <BODY>
        <DESC>
            <STATICVARIABLES>
                <EXPLODEFLAG>Yes</EXPLODEFLAG>
                <SVEXPORTFORMAT>$$SysName:XML</SVEXPORTFORMAT>
                <SVFROMDATE TYPE="Date">20180401</SVFROMDATE>
                <SVTODATE TYPE="Date">20190213</SVTODATE>
            </STATICVARIABLES>
            <TDL>
                <TDLMESSAGE>
                    <REPORT NAME="Voucher Sales Receipt">
                        <FORMS>Voucher Sales Receipt</FORMS>
                        <TITLE>Simple Voucher Sales Receipt</TITLE>
                    </REPORT>
                    <FORM NAME="Voucher Sales Receipt">
                        <TOPPARTS>Voucher Part</TOPPARTS>
                        <XMLTAG>"VoucherList"</XMLTAG>
                    </FORM>
                    <PART NAME="Voucher Part">
                        <TOPLINES>Voucher Line Title, Voucher Details </TOPLINES>
                        <REPEAT>Voucher Details : COL_SALERECEIPT</REPEAT>
                        <SCROLLED>Vertical</SCROLLED>
                    </PART>
                    <LINE NAME="Voucher Line Title">
                        <USE>Voucher Details</USE>
                        <LOCAL>Field : Default : Type : String </LOCAL>
                        <LOCAL>Field : Field PartyLedgerName : Set as: "PartyLedgerName"</LOCAL>
                        <LOCAL>Field : Field Voucher Date : Set as: "Date"</LOCAL>
                        <LOCAL>Field : Field VoucherNumber : Set as: "VoucherNumber"</LOCAL>
                        <LOCAL>Field : Field Reference : Set as: "Reference"</LOCAL>
                        <LOCAL>Field : Field VoucherTypeName : Set as: "VoucherTypeName"</LOCAL>
                        <LOCAL>Field : Field VoucherAmount : Set as:"VoucherAmount"</LOCAL>
                    </LINE>
                    <LINE NAME="Voucher Details">
                        <LEFTFIELDS>Field PartyLedgerName,Field Voucher Date,Field VoucherNumber,Field Reference,Field VoucherTypeName</LEFTFIELDS>
                        <RIGHTFIELDS>Field VoucherAmount</RIGHTFIELDS>
                        <XMLTAG>SALERECEIPT</XMLTAG>
                    </LINE>
                    <FIELD NAME="Field PartyLedgerName">
                        <USE>Name Field</USE>
                        <SET>$PartyLedgerName</SET>
                    </FIELD>
                    <FIELD NAME="Field Voucher Date">
                        <SET>$Date</SET>
                    </FIELD>
                    <FIELD NAME="Field VoucherNumber">
                        <USE>Name Field</USE>
                        <SET>$VoucherNumber</SET>
                    </FIELD>
                    <FIELD NAME="Field Reference">
                        <USE>Name Field</USE>
                        <SET>$Reference</SET>
                    </FIELD>
                    <FIELD NAME="Field VoucherTypeName">
                        <USE>Name Field</USE>
                        <SET>$VoucherTypeName</SET>
                    </FIELD>
                    <FIELD NAME="Field VoucherAmount">
                        <USE>Amount Field</USE>
                        <SET>$Amount</SET>
                    </FIELD>
                    <COLLECTION NAME="COL_SALERECEIPT">
                        <TYPE>Voucher</TYPE>
                        <FETCH>*.*</FETCH>
                        <FETCH>LedgerEntries.*</FETCH>
                        <FILTERS>Filter_IsSalesOrReceipt,Filter_DateRange</FILTERS>
                    </COLLECTION>
                    <SYSTEM TYPE="Formulae" NAME="Filter_DateRange">($Date&gt;=$$Date:##SVFROMDATE) AND ($Date&lt;=$$Date:##SVTODATE)</SYSTEM>
                    <SYSTEM TYPE="Formulae" NAME="Filter_IsSalesOrReceipt">($$IsSales:$VoucherTypeName) OR ($$IsReceipt:$VoucherTypeName)</SYSTEM>
                </TDLMESSAGE>
            </TDL>
        </DESC>
    </BODY>
</ENVELOPE>

    Code:
    <XMLTAG>SALERECEIPT</XMLTAG>
    is used for exporting individual vouchers enclosed within "SALERECEIPT" XML tag.
    Sample Output as below

    Code:
    <VOUCHERLIST>
    <SALERECEIPT>
        <FIELDPARTYLEDGERNAME>AAAAAAAAAAAAAA</FIELDPARTYLEDGERNAME>
        <FIELDVOUCHERNUMBER>VOC-001</FIELDVOUCHERNUMBER>
        <FIELDVOUCHERDATE>01-Apr-2018</FIELDVOUCHERDATE>
        <FIELDREFERENCE>Ref-001</FIELDREFERENCE>
        <FIELDVOUCHERTYPENAME>Sales</FIELDVOUCHERTYPENAME>
        <FIELDVOUCHERAMOUNT>-25,000.00</FIELDVOUCHERAMOUNT>
    </SALERECEIPT>
    <SALERECEIPT>...</SALERECEIPT>
    <SALERECEIPT>...</SALERECEIPT>
    <SALERECEIPT>...</SALERECEIPT>
</VOUCHERLIST>
     
    K.Senthil Babu, Feb 13, 2019
    #2


  3. Pilla Kishore Kumar

    Pilla Kishore Kumar New Member


    Good job Mr. Senthil. Need to talk. Call me on 8885582820
     
    Pilla Kishore Kumar, Apr 19, 2019
    #3


  4. Ankit Parashar

    Ankit Parashar New Member


    This worked, but the DateRange Filter is not working, can someone suggest if it is some issue with new version, or has been there from starting.
    Thanks
     
    Ankit Parashar, Jun 3, 2019
    #4


  5. Kirubakaran

    Kirubakaran New Member


    Hi Sir,
    I am trying to export sales voucher with inventory details (stock item, rate, qty) using XML. The qty is not fetching. please check this code below

    Code:
    <?xml version="1.0" encoding="UTF-8"?>
    <ENVELOPE>
       <HEADER>
          <VERSION>1</VERSION>
          <TALLYREQUEST>Export</TALLYREQUEST>
          <TYPE>Data</TYPE>
          <ID>Sales Vouchers</ID>
       </HEADER>
       <BODY>
          <DESC>
             <STATICVARIABLES>
                <EXPLODEFLAG>Yes</EXPLODEFLAG>
                <SVEXPORTFORMAT>$$SysName:XML </SVEXPORTFORMAT>           
                <SVFROMDATE>20190401</SVFROMDATE>
                <SVTODATE>20200331</SVTODATE>           
             </STATICVARIABLES>
             <TDL>
                <TDLMESSAGE>
                   <REPORT NAME="Sales Vouchers">
                      <FORMS>Sales Vouchers</FORMS>
                      <TITLE>Simple Sales Vouchers</TITLE>
                   </REPORT>
                   <FORM NAME="Sales Vouchers">
                      <TOPPARTS>Voucher Part</TOPPARTS>                     
                      <XMLTAG>"VoucherList"</XMLTAG>
                   </FORM>
                   <PART NAME="Voucher Part">
                      <TOPLINES>Voucher Line Title, Voucher Details</TOPLINES>
                      <REPEAT>Voucher Details : COL_SALEVOUCHER</REPEAT>         
                      <SCROLLED>Vertical</SCROLLED>
                   </PART>                  
                   <LINE NAME="Voucher Line Title">
                      <USE>Voucher Details</USE>
                      <LOCAL>Field : Default : Type : String</LOCAL>   
                    <LOCAL>Field : Field PartyLedgerName : Set as: "PartyLedgerName"</LOCAL>                     
                      <LOCAL>Field : Field StockItem : Set as:"StockItem"</LOCAL>
                      <LOCAL>Field : Field BilledQty : Set as:"BilledQty"</LOCAL>                 
                      <LOCAL>Field : Field ACTUALQTY : Set as:"ACTUALQTY"</LOCAL>                 
                     
                   </LINE>
                  
                   <LINE NAME="Voucher Details">
                      <LEFTFIELDS>Field PartyLedgerName</LEFTFIELDS>
                      <LEFTFIELDS>Field StockItem</LEFTFIELDS>
                      <RIGHTFIELDS>Field BilledQty</RIGHTFIELDS>
                      <RIGHTFIELDS>Field ACTUALQTY</RIGHTFIELDS>
                      <XMLTAG>SALES</XMLTAG>
                   </LINE>                  
                  
                    <FIELD NAME="Field PartyLedgerName">
                      <USE>Name Field</USE>
                      <SET>$PartyLedgerName</SET>
                   </FIELD>
                  
                   <FIELD NAME="Field StockItem">
                      <USE>Name Field</USE>
                      <SET>$StockItem</SET>
                   </FIELD>
                  
                   <FIELD NAME="Field BilledQty">
                      <USE>Name Field</USE>
                      <SET>$BilledQty</SET>
                   </FIELD>
                  
                   <FIELD NAME="Field ACTUALQTY">
                      <USE>Name Field</USE>
                      <SET>$ACTUALQTY</SET>
                   </FIELD>
                  
                   <COLLECTION NAME="COL_SALEVOUCHER">
                      <TYPE>Voucher</TYPE>                       
                        <FETCH>*.*</FETCH>                       
                        <FETCH>ALLLEDGERENTRIES.*</FETCH> 
                        <FETCH>ALLINVENTORYENTRIES.*</FETCH>    
                        <FILTERS>Filter_DateRange,IsSalesVoucher</FILTERS>
                   </COLLECTION>
                                  
                  
                   <SYSTEM TYPE="Formulae" NAME="Filter_DateRange">($Date&gt;=$$Date:##SVFROMDATE) AND ($Date&lt;=$$Date:##SVTODATE)</SYSTEM>
                   <SYSTEM TYPE="Formulae" NAME="IsSalesVoucher">$$IsSales:$VoucherTypeName</SYSTEM>
                </TDLMESSAGE>
             </TDL>
          </DESC>
       </BODY>
    </ENVELOPE>
     
    Kirubakaran, Dec 16, 2019
    #5


  6. Chandresh J Geria

    Chandresh J Geria New Member


    there is some issue with your code data not extract from tally its going in loop
     
    Chandresh J Geria, Sep 14, 2022
    #6


  7. Sridharan S

    Sridharan S Member


    <FETCH>LEDGERENTRIES.$AMOUNT</FETCH>
    LedgerEntries is not part of Voucher Object. Tally connects internally both in data by ID
     
    Sridharan S, Jul 4, 2023
    #7


Share This Page