Is their any way to get the name of selected company from tally on which user is currently working using XML request.
Use below xml Code: <ENVELOPE> <HEADER> <VERSION>1</VERSION> <TALLYREQUEST>EXPORT</TALLYREQUEST> <TYPE>FUNCTION</TYPE> <ID>$$string</ID> </HEADER> <BODY> <DESC> <FUNCPARAMLIST> <PARAM>##SVCURRENTCOMPANY</PARAM> </FUNCPARAMLIST> </DESC> </BODY> </ENVELOPE> or Code: <ENVELOPE> <HEADER> <VERSION>1</VERSION> <TALLYREQUEST>Export</TALLYREQUEST> <TYPE>Collection</TYPE> <ID>CompanyInfo</ID> </HEADER> <BODY> <DESC> <STATICVARIABLES /> <TDL> <TDLMESSAGE> <OBJECT NAME="CurrentCompany"> <LOCALFORMULA>CurrentCompany:##SVCURRENTCOMPANY</LOCALFORMULA> </OBJECT> <COLLECTION NAME="CompanyInfo"> <OBJECTS>CurrentCompany</OBJECTS> </COLLECTION> </TDLMESSAGE> </TDL> </DESC> </BODY> </ENVELOPE>
Hey i want to fetch the COMPANYNUMBER and GUID as well in this existing XML. Can you please share the way to do it.
Code: <ENVELOPE> <HEADER> <VERSION>1</VERSION> <TALLYREQUEST>EXPORT</TALLYREQUEST> <TYPE>Function</TYPE> <ID>$$CurrentCompany</ID> </HEADER> <BODY> <DESC> <TDL> <TDLMESSAGE/> </TDL> <STATICVARIABLES> <SVEXPORTFORMAT>$$SysName:XML</SVEXPORTFORMAT> </STATICVARIABLES> <FUNCPARAMLIST></FUNCPARAMLIST> </DESC> </BODY> </ENVELOPE>
Thanks for sharing the XML, but it isn't working properly. The response I got from this XML -> <ENVELOPE> <HEADER> <VERSION>1</VERSION> <STATUS>1</STATUS> <PRODMAJORVER>1</PRODMAJORVER> <PRODMINORVER>1</PRODMINORVER> <PRODMAJORREL>2</PRODMAJORREL> <PRODMINORREL>1</PRODMINORREL> <PRODTYPE>5</PRODTYPE> </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> <LBTCLASSIFICATION>0</LBTCLASSIFICATION> <TAXUNIT>0</TAXUNIT> <RETURNMASTER>0</RETURNMASTER> <VOUCHER>0</VOUCHER> </CMPINFO> </DESC> <DATA> <RESULT TYPE="String">Test Pvt Ltd</RESULT> </DATA> </BODY> </ENVELOPE> The Test Pvt Ltd does have the ledgers and vouchers still returning 0.
Use the name you received from ##SVCURRENTCOMPANY to filter Company Collection Code: <SYSTEM TYPE="Formulae" NAME="ActiveCompanyFilter">$Name=##SVCURRENTCOMPANY</SYSTEM> Full Xml will be Code: <ENVELOPE> <HEADER> <VERSION>1</VERSION> <TALLYREQUEST>EXPORT</TALLYREQUEST> <TYPE>COLLECTION</TYPE> <ID>ListofCompanies</ID> </HEADER> <BODY> <DESC> <STATICVARIABLES> <SVViewName /> </STATICVARIABLES> <TDL> <TDLMESSAGE> <COLLECTION ISMODIFY="No" ISFIXED="No" ISINITIALIZE="Yes" ISOPTION="No" ISINTERNAL="No" NAME="ListofCompanies"> <TYPE>Company</TYPE> <NATIVEMETHOD>Name</NATIVEMETHOD> <NATIVEMETHOD>StartingFrom,GUID,CompanyNumber</NATIVEMETHOD> <filter>ActiveCompanyFilter</filter> </COLLECTION> <SYSTEM TYPE="Formulae" NAME="ActiveCompanyFilter">$Name=##SVCURRENTCOMPANY</SYSTEM> </TDLMESSAGE> </TDL> </DESC> </BODY> </ENVELOPE>
this is not the count of existing objects, they are count of objects created / altered in instance through xml requests, once connection closes or tally restarts it will start from zero