1. CLICK HERE TO JOIN WHATSAPP CHANNEL FOR TDL PROGRAMS

Address and CIN values not fetched in Tally Prime export

Discussion in 'Tally Integration' started by Researcher1, Jul 6, 2023.

    
Tags:
  1. Researcher1

    Researcher1 Member


    I am trying to export data using the following XML query:
    Code:
    <ENVELOPE><HEADER><VERSION>1</VERSION><TALLYREQUEST>Export</TALLYREQUEST><TYPE>Collection</TYPE><ID>Company Collection</ID></HEADER><BODY><DESC><STATICVARIABLES><SVEXPORTFORMAT>$$SysName:XML</SVEXPORTFORMAT></STATICVARIABLES><TDL><TDLMESSAGE><COLLECTION NAME="Company Collection" ISMODIFY="No"><TYPE>Company</TYPE><FETCH>*</FETCH></COLLECTION></TDLMESSAGE></TDL></DESC></BODY></ENVELOPE>
    However, I've noticed that the address and CIN values are not fetched in the exported data. I have double-checked the TDL and XML query & tried adding individual tag name,but I couldn't find any specific issues.
    Please suggest how to modify the above query to fetch address and CIN values in the exported data. Or is there any other query available?
     
    Researcher1, Jul 6, 2023
    #1


  2. Sai Vineeth

    Sai Vineeth Active Member


    What field you are looking into for CIN?
     
    Sai Vineeth, Jul 6, 2023
    #2


  3. Sridharan S

    Sridharan S Member


    address and CIN values
    Maybe COMPANYNUMBER tag is what you want.
     
    Sridharan S, Jul 7, 2023
    #3


  4. Researcher1

    Researcher1 Member


    I Tried the COMPANYNUMBER tag . Did not get any CIN number information.
    Please suggest any alternate solution.

    Code:
    <ENVELOPE>
<HEADER>
<VERSION>1</VERSION>
<TALLYREQUEST>Export</TALLYREQUEST>
<TYPE>Collection</TYPE>
<ID>Company Collection</ID>
</HEADER>
<BODY>
<DESC>
<STATICVARIABLES>
<SVEXPORTFORMAT>$$SysName:XML</SVEXPORTFORMAT>
</STATICVARIABLES>
<TDL>
<TDLMESSAGE>
<COLLECTION NAME="Company Collection" ISMODIFY="No">
<TYPE>Company</TYPE>
<FETCH>COMPANYNUMBER</FETCH>
</COLLECTION>
</TDLMESSAGE>
</TDL>
</DESC>
</BODY>
</ENVELOPE>
     
    Researcher1, Jul 13, 2023
    #4


  5. Researcher1

    Researcher1 Member


    I tried using the "corporateidentityno" tag to fetch the CIN detail of the company and this worked for me. Can anyone suggest a tag to fetch address of the company. Any alternate solution on how to fetch address of the company also would be helpful.

    Code:
    <ENVELOPE>
  <HEADER>
    <VERSION>1</VERSION>
    <TALLYREQUEST>Export</TALLYREQUEST>
    <TYPE>Collection</TYPE>
    <ID>compcoll</ID>
  </HEADER>
  <BODY>
    <DESC>
      <STATICVARIABLES>
        <SVEXPORTFORMAT>$$SysName:XML</SVEXPORTFORMAT>
      </STATICVARIABLES>
      <TDL>
        <TDLMESSAGE>
          <COLLECTION NAME="compcoll" ISINITIALIZE="Yes">
            <TYPE>Company</TYPE>
            <FETCH>corporateidentityno</FETCH>  
          </COLLECTION>
        </TDLMESSAGE>
      </TDL>
    </DESC>
  </BODY>
</ENVELOPE>
     
    Last edited: Jul 17, 2023
    Researcher1, Jul 15, 2023
    #5


  6. Researcher1

    Researcher1 Member


    Address can be fetched using the following query
    Code:
    <ENVELOPE>
<HEADER>
<VERSION>1</VERSION>
<TALLYREQUEST>Export</TALLYREQUEST>
<TYPE>Collection</TYPE>
<ID>Company Collection</ID>
</HEADER>
<BODY>
<DESC>
<STATICVARIABLES>
<SVEXPORTFORMAT>$$SysName:XML</SVEXPORTFORMAT>
</STATICVARIABLES>
<TDL><TDLMESSAGE>
<COLLECTION NAME="Company Collection" ISMODIFY="No">
<TYPE>Company</TYPE>
<FETCH>fullcompanyaddress</FETCH>
</COLLECTION>
</TDLMESSAGE>
</TDL>
</DESC>
</BODY>
</ENVELOPE>
     
    Researcher1, Aug 11, 2023
    #6


Share This Page