The Symbol Prefix "_" is used to expose the Methods to ODBC. ex: Code: [#Object : Ledger] _DiffAMT : $ClosingBalance - $Opening Balance
Dear Admin, How to get Bills Outstanding Report into C#.net using either odbc or XML request IAm unable to form the sql query to get the Bills Outstanding
Dear surya143kumar, If u want to get data from tally using SQL Query mean u should follow few rules. 1. Should know that collection and its attributes. 2. u can get first level of attributes only. if u want entire data mean u should write a ur own collection as per ur requirement. XML request is the best way to get data from tally. For Receivable Bills <ENVELOPE> <HEADER> <TALLYREQUEST>Export Data</TALLYREQUEST> </HEADER> <BODY> <EXPORTDATA> <REQUESTDESC> <REPORTNAME>Bills Receivable</REPORTNAME> <STATICVARIABLES> <SVEXPORTFORMAT>$$SysName:XML</SVEXPORTFORMAT> <SVFROMDATE>01/04/2013</SVFROMDATE> // This is From Date <SVTODATE>31/03/2014</SVTODATE> // This is To Date </STATICVARIABLES> </REQUESTDESC> </EXPORTDATA> </BODY> </ENVELOPE> For Bills Payable <ENVELOPE> <HEADER> <TALLYREQUEST>Export Data</TALLYREQUEST> </HEADER> <BODY> <EXPORTDATA> <REQUESTDESC> <REPORTNAME>Bills Payable </REPORTNAME> <STATICVARIABLES> <SVEXPORTFORMAT>$$SysName:XML</SVEXPORTFORMAT> //If you give $$SysName:HTML mean u get in html format. <SVFROMDATE>01/04/2013</SVFROMDATE> <SVTODATE>31/03/2014</SVTODATE> </STATICVARIABLES> </REQUESTDESC> </EXPORTDATA> </BODY> </ENVELOPE>
Thank You, This help me a lot Will you please provide XML request to get Bills receivable by Ageing methods - Ageing by Bill date.