Get Ledgers from tally via XML request from external application

Discussion in 'Tally Integration' started by teja varma, Sep 6, 2019.

    
  1. teja varma

    teja varma Active Member


    get list of all ledgers contains or matching a specific words or Characters

    ;;;;; xml request

    Code:
    <ENVELOPE>
        <HEADER>
            <VERSION>1</VERSION>
            <TALLYREQUEST>Export</TALLYREQUEST>
            <TYPE>Data</TYPE>
            <ID>Hostledgers</ID>
        </HEADER>
        <BODY>
            <DESC>
                <STATICVARIABLES>
                    <SVEXPORTFORMAT>$$SysName:XML</SVEXPORTFORMAT>
              </STATICVARIABLES>
      <TDL>
    <TDLMESSAGE>
       <REPORT NAME="Hostledgers">
        <FORMS>Hostledgers</FORMS>
       </REPORT>
       <FORM NAME="Hostledgers">
        <TOPPARTS>Hostledgers</TOPPARTS>
       </FORM>
       <PART NAME="Hostledgers">
        <TOPLINES>Hostledgers</TOPLINES>
         <REPEAT>Hostledgers:Hostledcoll</REPEAT>
        <SCROLLED>Vertical</SCROLLED>
       </PART>
       <LINE NAME="Hostledgers">
        <LEFTFIELDS>ledname</LEFTFIELDS>
       </LINE>
       <FIELD NAME="ledname">
        <SET>$Name</SET>
       </FIELD>
        <COLLECTION NAME="Hostledcoll" >
        <TYPE>Ledgers</TYPE>
        <FILTERS>isreqledger</FILTERS>
       </COLLECTION>
      <SYSTEM TYPE="Formulae" NAME="isreqledger">$Name:Ledger:$Name contains &quot;Sales&quot;</SYSTEM>
    </TDLMESSAGE>
    </TDL>
    </DESC>
    </BODY>
    </ENVELOPE>
    

    ;; response

    Code:
    <ENVELOPE>
    <LEDNAME>GST ST Sales</LEDNAME>
    <LEDNAME>GST SA Sales</LEDNAME>
    <LEDNAME>GST OS Sales@12%</LEDNAME>
    <LEDNAME>GST OT Sales@5%</LEDNAME>
    <LEDNAME>GST  Sales@12%</LEDNAME>
    <LEDNAME>GST SALES @18%</LEDNAME>
    <LEDNAME>GST  SALES @5%</LEDNAME>
    </ENVELOPE>

    You can replace ' Sales ' with the name that you want
    <SYSTEM TYPE="Formulae" NAME="isreqledger">$Name:Ledger:$Name contains &quot;Sales&quot;</SYSTEM>
     


Share This Page