Getting Name Of Selected Company Through XML

Discussion in 'Tally Integration' started by Rajan Mourya, Dec 15, 2021.

    
  1. Rajan Mourya

    Rajan Mourya Member


    Is their any way to get the name of selected company from tally on which user is currently working using XML request.
     


  2. Sai Vineeth

    Sai Vineeth Active Member


    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>
    
     


  3. Rajan Mourya

    Rajan Mourya Member


    Both code are working fine, Thanks.
     
    Sai Vineeth likes this.


  4. Rajan Mourya

    Rajan Mourya Member


    Hey i want to fetch the COMPANYNUMBER and GUID as well in this existing XML. Can you please share the way to do it.
     


  5. Sridharan S

    Sridharan S Member


    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>
     
    Last edited: Apr 21, 2022


  6. Sridharan S

    Sridharan S Member



  7. Rajan Mourya

    Rajan Mourya Member


    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.
     


  8. Sai Vineeth

    Sai Vineeth Active Member


    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>
     


  9. Sai Vineeth

    Sai Vineeth Active Member


    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
     


  10. Rajan Mourya

    Rajan Mourya Member


    Thanks, This is what i exactly wanted.
     


  11. Sridharan S

    Sridharan S Member


    Result node is what is wanted. Think of it as function return value.
     
    Last edited: Apr 23, 2022


Share This Page