1. CLICK HERE TO JOIN WHATSAPP CHANNEL FOR TDL PROGRAMS

How to call areport via XML? - Code provided

Discussion in 'Tally Integration' started by admin, Apr 13, 2012.

    
  1. admin

    admin Administrator Staff Member


    Code:
    <ENVELOPE>
<HEADER>
<VERSION>1</VERSION>
<TALLYREQUEST>Export</TALLYREQUEST>
<TYPE>Data</TYPE>
<ID>[I][B]Balance Sheet[/B][/I]</ID>
</HEADER>
<BODY>
<DESC>
<STATICVARIABLES>
<EXPLODEFLAG>Yes</EXPLODEFLAG>
<SVEXPORTFORMAT>$$SysName:XML</SVEXPORTFORMAT>
<SVFROMDATE>01/04/2006</SVFROMDATE>
<SVTODATE>31/03/2007</SVTODATE>
</STATICVARIABLES>
<TDL>
<TDLMESSAGE>
<REPORT NAME="[I][B]Balance Sheet[/B][/I]" ISMODIFY="No" ISFIXED="No" ISINITIALIZE="No" ISOPTION="No" ISINTERNAL="No">
</REPORT>
</TDLMESSAGE>
</TDL>
</DESC>
</BODY>
</ENVELOPE>
    In the above you can replace the Balance Sheet with any other report Name provided in TDL.

    Ex: Daybook, Trial Balance, Profit and Loss, etc
     
    admin, Apr 13, 2012
    #1
    Anbu likes this.


  2. Anbu

    Anbu New Member


     
    Anbu, Apr 19, 2012
    #2


  3. admin

    admin Administrator Staff Member


    Calling a function using XML has limitation in TDL,may be parameters will not work.

    For example, you can just check by calling $$NumLedgers
     
    admin, Apr 20, 2012
    #3


  4. Anbu

    Anbu New Member


    Hi,
    Is there any other way to get Financial Year From from Company info
     
    Anbu, Apr 20, 2012
    #4


  5. Anbu

    Anbu New Member


    Hi,

    I need to find the Outstanding Receivable/Payable details with TDL - XML


    I tried A lot, Please help
     
    Anbu, Jul 26, 2012
    #5


  6. Ajay singh

    Ajay singh New Member


    In Tally developer report(Vouchers (#). but i am not getting how to use this............First of all what it means adding (#).
    Because Vouchers already we have.
    Please tell me how to retrieve this type of report, we have to pass something from xml or how it will be.
    In your example i am seeing you are retrieving report(Balance Sheet) i checked in report this was not there. is this a custom report or you are passing some value to that.
    Reply me ASAP
    Thanks and Regards
    Ajay singh
     
    Ajay singh, Oct 18, 2012
    #6


  7. admin

    admin Administrator Staff Member


    Sir, i think you are new to TDL. Please try to learn basic tdl concept before starting any integration with tally by doing tdl also..
     
    admin, Nov 5, 2012
    #7


  8. Ajay singh

    Ajay singh New Member


    Hi Admin sir,
    I have to retrieve sales details based on the Invoice number,
    Below is my xml request,
    <ENVELOPE>
    <HEADER>
    <TALLYREQUEST>Export Data</TALLYREQUEST>
    </HEADER>
    <BODY>
    <EXPORTDATA>
    <REQUESTDESC>
    <REPORTNAME>Sales vouchers</REPORTNAME>
    <STATICVARIABLES>
    <SVEXPORTFORMAT>$$SysName:XML</SVEXPORTFORMAT>
    <SVFROMDATE>20110601</SVFROMDATE>
    <SVTODATE>20120901</SVTODATE>
    </STATICVARIABLES>
    <PARAM><VOUCHERNUMBER>2</VOUCHERNUMBER></PARAM>
    </REQUESTDESC>
    </EXPORTDATA>
    </BODY>
    </ENVELOPE>

    above red color i tried to pass voucher number but it was not working, i m very new in tally,
    i need to pass voucher number so that tally will give me only that particular sales voucher details.
    Please help me out on the above.
    Thanks
    Ajay singh
     
    Ajay singh, Mar 11, 2013
    #8
    ram rockz likes this.


Share This Page