Hi , I am trying to create balance sheet report using TDL in XML format, but while trying to filter Report by date wise, it Changes the System period Date in Tally. is there any other way to Filter the values by date without using SVFROMDATE and SVTODATE
You can do one thing. Write a seperate like balancesheet and call that report from via XML by applying SVFromdate and SVTodate. Code: [Report : My Balance Sheet] Use : Balance Sheet Form : Balance Sheet Set : SVFrom date : ##SVFromDate Set : SVToDate : ##SVToDate in XML, Replace the Report Name with above. This will solve your problem. Otherwise contact us.
Hi , Thanks for your reply, we have tried with above posted Code, I am able to get the report but the date is not getting filtered , Below is the Code which I have tried to do so .. Code: <ENVELOPE> <HEADER> <VERSION>1</VERSION> <TALLYREQUEST>Export</TALLYREQUEST> <TYPE>Data</TYPE> <ID>My Balance Sheet</ID> </HEADER> <BODY> <DESC> <STATICVARIABLES> <EXPLODEFLAG>Yes</EXPLODEFLAG> <SVEXPORTFORMAT>$$SysName:XML</SVEXPORTFORMAT> </STATICVARIABLES> <TDL> <TDLMESSAGE> <REPORT NAME="My Balance Sheet" ISMODIFY="No" ISFIXED="No" ISINITIALIZE="No" ISOPTION="No" ISINTERNAL="No"> <USE>Balance Sheet</USE> <FORMS>Balance Sheet</FORMS> <SET>SVFromDate:01-04-2010</SET> <SET>SVToDate:30-05-2011</SET> </REPORT> </TDLMESSAGE> </TDL> </DESC> </BODY> </ENVELOPE> I want to know ,Is this the right way to do it? Kindly assist me
There was a problem in your code. You have to use the SVFromDate and SVTodate under <STATICVARIABLES>. Find the corrected code below. Code: <ENVELOPE> <HEADER> <VERSION>1</VERSION> <TALLYREQUEST>Export</TALLYREQUEST> <TYPE>Data</TYPE> <ID>My Balance Sheet</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="My Balance Sheet" ISMODIFY="No" ISFIXED="No" ISINITIALIZE="No" ISOPTION="No" ISINTERNAL="No"> <USE>Balance Sheet</USE> <FORMS>Balance Sheet</FORMS> </REPORT> </TDLMESSAGE> </TDL> </DESC> </BODY> </ENVELOPE>
Do you want the financial startdate and end date of a particular date?? below is code to get the Financial Start date and End date of current date Code: [System : Formula] ITCurrFinYrBgn : $$FinYearBeg:##SVCurrentDate:$StartingFrom:Company:##SVCurrentCompany ITCurrFinYrEnd : $$FinYearEnd:##SVCurrentDate:$StartingFrom:Company:##SVCurrentCompany
Calling a function using XML has limitation in TDL,may be parameters will not work. For example, you can just check by calling $$NumLedgers
Hi, Thanks for your reply , I tried with above function it Come Correctly below is code I tried Code: <ENVELOPE> <HEADER> <VERSION>1</VERSION> <TALLYREQUEST>EXPORT</TALLYREQUEST> <TYPE>FUNCTION</TYPE> <ID>$$NumLedgers</ID> </HEADER> <BODY> <DESC> </DESC> </BODY> </ENVELOPE> And i got the response as below Code: <ENVELOPE> <HEADER> <VERSION>1</VERSION> <STATUS>1</STATUS> </HEADER> <BODY> <DESC> <CMPINFO> <COMPANY>0</COMPANY> <GROUP>0</GROUP> <LEDGER>0</LEDGER> <COSTCATEGORY>0</COSTCATEGORY> <COSTCENTRE>0</COSTCENTRE> <GODOWN>0</GODOWN> <STOCKGROUP>0</STOCKGROUP> <STOCKCATEGORY>0</STOCKCATEGORY> <STOCKITEM>0</STOCKITEM> <VOUCHERTYPE>0</VOUCHERTYPE> <CURRENCY>0</CURRENCY> <UNIT>0</UNIT> <BUDGET>0</BUDGET> <CLIENTRULE>0</CLIENTRULE> <SERVERRULE>0</SERVERRULE> <STATE>0</STATE> <TDSRATE>0</TDSRATE> <TAXCLASSIFICATION>0</TAXCLASSIFICATION> <STCATEGORY>0</STCATEGORY> <DEDUCTEETYPE>0</DEDUCTEETYPE> <ATTENDANCETYPE>0</ATTENDANCETYPE> <FBTCATEGORY>0</FBTCATEGORY> <FBTASSESSEETYPE>0</FBTASSESSEETYPE> <TARIFFCLASSIFICATION>0</TARIFFCLASSIFICATION> <EXCISEDUTYCLASSIFICATION>0</EXCISEDUTYCLASSIFICATION> <SERIALNUMBER>0</SERIALNUMBER> <ADJUSTMENTCLASSIFICATION>0</ADJUSTMENTCLASSIFICATION> <INCOMETAXSLAB>0</INCOMETAXSLAB> <INCOMETAXCLASSIFICATION>0</INCOMETAXCLASSIFICATION> <VOUCHER>0</VOUCHER> </CMPINFO> </DESC> <DATA> <RESULT TYPE="Number">34</RESULT> </DATA> </BODY> </ENVELOPE> and Also i tried with roundof function which requires parameters Code: <ENVELOPE> <HEADER> <VERSION>1</VERSION> <TALLYREQUEST>EXPORT</TALLYREQUEST> <TYPE>FUNCTION</TYPE> <ID>$$Round</ID> </HEADER> <BODY> <DESC> <FUNCPARAMLIST> <PARAM>@@FirstParameter</PARAM> <PARAM TYPE="Number">0.10</PARAM> </FUNCPARAMLIST> <TDL> <TDLMESSAGE> <SYSTEM TYPE="Formulae" NAME="FirstParameter" > 1242849 / 1000 </SYSTEM> </TDLMESSAGE> </TDL> </DESC> </BODY> </ENVELOPE> I got the response as Code: <ENVELOPE> <HEADER> <VERSION>1</VERSION> <STATUS>1</STATUS> </HEADER> <BODY> <DESC> <CMPINFO> <COMPANY>0</COMPANY> <GROUP>0</GROUP> <LEDGER>0</LEDGER> <COSTCATEGORY>0</COSTCATEGORY> <COSTCENTRE>0</COSTCENTRE> <GODOWN>0</GODOWN> <STOCKGROUP>0</STOCKGROUP> <STOCKCATEGORY>0</STOCKCATEGORY> <STOCKITEM>0</STOCKITEM> <VOUCHERTYPE>0</VOUCHERTYPE> <CURRENCY>0</CURRENCY> <UNIT>0</UNIT> <BUDGET>0</BUDGET> <CLIENTRULE>0</CLIENTRULE> <SERVERRULE>0</SERVERRULE> <STATE>0</STATE> <TDSRATE>0</TDSRATE> <TAXCLASSIFICATION>0</TAXCLASSIFICATION> <STCATEGORY>0</STCATEGORY> <DEDUCTEETYPE>0</DEDUCTEETYPE> <ATTENDANCETYPE>0</ATTENDANCETYPE> <FBTCATEGORY>0</FBTCATEGORY> <FBTASSESSEETYPE>0</FBTASSESSEETYPE> <TARIFFCLASSIFICATION>0</TARIFFCLASSIFICATION> <EXCISEDUTYCLASSIFICATION>0</EXCISEDUTYCLASSIFICATION> <SERIALNUMBER>0</SERIALNUMBER> <ADJUSTMENTCLASSIFICATION>0</ADJUSTMENTCLASSIFICATION> <INCOMETAXSLAB>0</INCOMETAXSLAB> <INCOMETAXCLASSIFICATION>0</INCOMETAXCLASSIFICATION> <VOUCHER>0</VOUCHER> </CMPINFO> </DESC> <DATA> <RESULT TYPE="Number">1242.80</RESULT> </DATA> </BODY> </ENVELOPE> This one is also works , so is there any other way to get Financial Year From from Company info ..
Hi , Thanks , Let me know once you get the Answer,for the Financial Year From and I have one more query in Tally XML How to take Ledger Monthly summary Details using TDL. I have Tried with below code without using TDL , I get the result but I found One thing wrong in tally ... Code: <ENVELOPE> <HEADER> <TALLYREQUEST>Export Data</TALLYREQUEST> </HEADER> <BODY> <EXPORTDATA> <REQUESTDESC> <REPORTNAME>Ledger Monthly Summary</REPORTNAME> <STATICVARIABLES> <SVCURRENTCOMPANY>ABC Limited</SVCURRENTCOMPANY> <SVFROMDATE>1-04-2012</SVFROMDATE> <SVTODATE>31-03-2013</SVTODATE> <DSPSHOWMONTHLY>Yes</DSPSHOWMONTHLY> <DSPSHOWALLACCOUNTS>Yes</DSPSHOWALLACCOUNTS> <LEDGERNAME>xxx</LEDGERNAME> <EXPLODEFLAG>TRUE</EXPLODEFLAG> </STATICVARIABLES> </REQUESTDESC> </EXPORTDATA> </BODY> </ENVELOPE> I am getting the response , but what happens is consider the above mentioned from date and to date, The Date mentioned is current financial year we will be having the data upto this month i.e. April. but it gives the Current Closing Balance to all the month from May to Mar 2013 , but no transaction has been Done yet from May to Mar 2013. so is there any way to find the Credits and Debit amount separately or is there any other way to fix the above mentioned issue ..Kindly Assists ..
Dear Anbu, Kindly try this, it may help you Code: <ENVELOPE> <HEADER> <VERSION>1</VERSION> <TALLYREQUEST>Export</TALLYREQUEST> <TYPE>Data</TYPE> <ID>SSPL MLK Account Master</ID> </HEADER> <BODY> <DESC> <TDL> <TDLMESSAGE> <REPORT NAME="SSPL MLK Account Master"> <FORMS> SSPL MLK Account Master </FORMS> <VARIABLE> EXPLODEFLAG,SVEXPORTFORMAT,SVCURRENTCOMPANY,SVFROMDATE,SVTODATE,LedgerName </VARIABLE> <SET>LedgerName:"All India Computer Institute"</SET> <SET>SVFROMDATE:$$Date:"01-Apr-2009"</SET> <SET>SVTODATE:$$Date:"31-Mar-2013"</SET> <SET>EXPLODEFLAG:Yes</SET> <SET>SVEXPORTFORMAT:$$SysName:XML</SET> </REPORT> <FORM NAME ="SSPL MLK Account Master"> <PARTS> SSPL MLK Account Master </PARTS> </FORM> <PART NAME="SSPL MLK Account Master"> <LINES>SSPL MLK Account Master</LINES> <REPEAT>SSPL MLK Account Master : Ledger Periodic Details</REPEAT> <SCROLLED>Vertical</SCROLLED> </PART> <LINE NAME="SSPL MLK Account Master"> <Fields>MLKMonth</Fields> <Fields>MLKYear</Fields> <Fields>MLKLedgerName</Fields> <Fields>MLKParent</Fields> <Fields>MLKVchLedDrAmount</Fields> <Fields>MLKVchLedCrAmount</Fields> <Fields>MLKLedOpening</Fields> <Fields>MLKLedOpeningType</Fields> <Fields>MLKLedclosing</Fields> <Fields>MLKLedclosingType</Fields> </LINE> <FIELD NAME="MLKMonth"> <USE>Name Field</USE> <SET>$$MonthOfDate:$$PeriodDateFrom</SET> </FIELD> <FIELD NAME="MLKYear"> <USE>Name Field</USE> <SET>$$YearOfDate:$$PeriodDateFrom</SET> </FIELD> <FIELD NAME="MLKLedgerName"> <USE>Name Field</USE> <SET>##LedgerName</SET> </FIELD> <FIELD NAME="MLKParent"> <USE>Name Field</USE> <SET>$Parent:Ledger:##LedgerName</SET> </FIELD> <FIELD NAME="MLKVchLedDrAmount"> <USE>Amount Field</USE> <SET>$$Abs:$BSDebits</SET> </FIELD> <FIELD NAME="MLKVchLedCrAmount"> <USE>Amount Field</USE> <SET>$$Abs:$BSCredits</SET> </FIELD> <FIELD NAME="MLKLedOpening"> <USE>Amount Field</USE> <SET>$$Abs:$TBalOpening</SET> </FIELD> <FIELD NAME="MLKLedOpeningType"> <USE>Amount Dr Cr Field</USE> <SET>$TBalOpening</SET> </FIELD> <FIELD NAME="MLKLedClosing"> <USE>Amount Field</USE> <SET>$$Abs:$TBalClosing</SET> </FIELD> <FIELD NAME="MLKLedClosingType"> <USE>Amount DrCr Field</USE> <SET>$TBalClosing</SET> </FIELD> </TDL> </DESC> </BODY> </ENVELOPE>
Is there a way to find the mid of the financial year through this method? I mean if current financial year is : 2017-18 then its two half: i.e. 01-04-2017 30-09-2017 and 01-10-2017 31-03-2017 Please guide...