1. CLICK HERE TO JOIN WHATSAPP CHANNEL FOR TDL PROGRAMS

How To Uniquely Differentiate The Companies Apart From The Name, Tallyid And GUID

Discussion in 'Tally Integration' started by Rajan Mourya, Jan 19, 2022.

    
Tags:
  1. Rajan Mourya

    Rajan Mourya Member


    Is their any way to differentiate the split companies through xml request apart from the name, tallyid and guid. Or any way to find that the particular company is spliced from which company apart from GUID.

    As we are developing an third party application which provide service on file credited system so we need to identify that the spliced company is from particular company only.
     
    Rajan Mourya, Jan 19, 2022
    #1


  2. Himanshu-2002

    Himanshu-2002 Active Member


    Simple, Guid of Parent company and splited company will be same and Splited company Data ID will be greater than parent one...We can concatenate Guid and Data ID to generate a unique ID.
     
    Himanshu-2002, Jan 19, 2022
    #2


  3. Rajan Mourya

    Rajan Mourya Member


    Let suppose i have created a company on September 2020 and i started entering data into it for one year till September 2021 but financial year ends on 31 March 2022 and i want to Separate the Data of Financial year 1st April 2020 to 31 March 2021 so i will split the current company from 1 April 2021.
     
    Rajan Mourya, Jan 19, 2022
    #3


  4. Rajan Mourya

    Rajan Mourya Member


    I am using this XMl to fetch the List Of Opened Companies

    XML Request:>

    <ENVELOPE>
    <HEADER>
    <VERSION>1</VERSION>
    <TALLYREQUEST>Export</TALLYREQUEST>
    <TYPE>COLLECTION</TYPE>
    <ID>compcoll</ID>
    </HEADER>
    <BODY>
    <DESC>
    <STATICVARIABLES>
    <SVEXPORTFORMAT>$$SysName:XML</SVEXPORTFORMAT>
    <LICNUMM>$$LicenseInfo:SerialNumber</LICNUMM>
    </STATICVARIABLES>
    <TDL>
    <TDLMESSAGE>
    <COLLECTION NAME="compcoll" ISINITIALIZE= "Yes">
    <TYPE>Company</TYPE>
    <BELONGSTO>Yes</BELONGSTO>
    <FETCH>Name,Guid,Mailingname,Address,PhoneNumber,MobileNumbers,Companynumber,GSTRegNumber,Gstregistrationnumber,gstnum,StartingFrom,STATENAME</FETCH>
    <PARMVAR>LICNUMM:$$LicenseInfo:SerialNumber</PARMVAR>
    <COMPUTE>gstnum:$GSTRegNumber:taxunit:"Default Tax Unit"</COMPUTE>
    <COMPUTE>licnumbervar:$$LicenseInfo:SerialNumber</COMPUTE>
    </COLLECTION>
    </TDLMESSAGE>
    </TDL>
    </DESC>
    </BODY>
    </ENVELOPE>

    Response ::>
    <ENVELOPE>
    <HEADER>
    <VERSION>1</VERSION>
    <STATUS>1</STATUS>
    </HEADER>
    <BODY>
    <DESC>
    <CMPINFO>
    <COMPANY>0</COMPANY>
    <GROUP>28</GROUP>
    <LEDGER>2</LEDGER>
    <COSTCATEGORY>1</COSTCATEGORY>
    <COSTCENTRE>0</COSTCENTRE>
    <GODOWN>1</GODOWN>
    <STOCKGROUP>0</STOCKGROUP>
    <STOCKCATEGORY>0</STOCKCATEGORY>
    <STOCKITEM>0</STOCKITEM>
    <VOUCHERTYPE>29</VOUCHERTYPE>
    <CURRENCY>2</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>7</INCOMETAXSLAB>
    <INCOMETAXCLASSIFICATION>94</INCOMETAXCLASSIFICATION>
    <LBTCLASSIFICATION>0</LBTCLASSIFICATION>
    <TAXUNIT>1</TAXUNIT>
    <RETURNMASTER>0</RETURNMASTER>
    <VOUCHER>0</VOUCHER>
    </CMPINFO>
    </DESC>
    <DATA>
    <COLLECTION>
    <COMPANY NAME="Split Testing" RESERVEDNAME="">
    <STARTINGFROM TYPE="Date">20200401</STARTINGFROM>
    <NAME TYPE="String">Split Testing</NAME>
    <GUID TYPE="String">8d87daf8-d706-425e-b6e2-b4e8c0ec1047</GUID>
    <PHONENUMBER TYPE="String">8980957789</PHONENUMBER>
    <STATENAME TYPE="String">Gujarat</STATENAME>
    <MAILINGNAME TYPE="String">INR</MAILINGNAME>
    <COMPANYNUMBER TYPE="Number"> 10000</COMPANYNUMBER>
    <GSTNUM TYPE="String"></GSTNUM>
    <LICNUMBERVAR TYPE="Number"> 737536374</LICNUMBERVAR>
    </COMPANY>
    <COMPANY NAME="Split Testing - (from 1-Apr-20)" RESERVEDNAME="">
    <STARTINGFROM TYPE="Date">20200401</STARTINGFROM>
    <NAME TYPE="String">Split Testing - (from 1-Apr-20)</NAME>
    <GUID TYPE="String">8d87daf8-d706-425e-b6e2-b4e8c0ec1047</GUID>
    <PHONENUMBER TYPE="String">8980957789</PHONENUMBER>
    <STATENAME TYPE="String">Gujarat</STATENAME>
    <MAILINGNAME TYPE="String">INR</MAILINGNAME>
    <COMPANYNUMBER TYPE="Number"> 10005</COMPANYNUMBER>
    <GSTNUM TYPE="String"></GSTNUM>
    <LICNUMBERVAR TYPE="Number"> 737536374</LICNUMBERVAR>
    </COMPANY>
    <COMPANY NAME="Split Testing - (from 1-Apr-21)" RESERVEDNAME="">
    <STARTINGFROM TYPE="Date">20210401</STARTINGFROM>
    <NAME TYPE="String">Split Testing - (from 1-Apr-21)</NAME>
    <GUID TYPE="String">8d87daf8-d706-425e-b6e2-b4e8c0ec1047</GUID>
    <PHONENUMBER TYPE="String">8980957789</PHONENUMBER>
    <STATENAME TYPE="String">Gujarat</STATENAME>
    <MAILINGNAME TYPE="String">INR</MAILINGNAME>
    <COMPANYNUMBER TYPE="Number"> 10006</COMPANYNUMBER>
    <GSTNUM TYPE="String"></GSTNUM>
    <LICNUMBERVAR TYPE="Number"> 737536374</LICNUMBERVAR>
    </COMPANY>
    </COLLECTION>
    </DATA>
    </BODY>
    </ENVELOPE>

    I am not aware of data id and i can't find it in Response as well.
     
    Rajan Mourya, Jan 19, 2022
    #4


  5. Sai Vineeth

    Sai Vineeth Active Member


    ok Understood tnq
     
    Sai Vineeth, Jan 19, 2022
    #5


  6. Rajan Mourya

    Rajan Mourya Member


    So is their any way to get the data id from this existing XML Request
     
    Rajan Mourya, Jan 19, 2022
    #6


  7. Sai Vineeth

    Sai Vineeth Active Member


    You can use Company Number
    Code:
    <COMPANYNUMBER TYPE="Number"> 10006</COMPANYNUMBER>
     
    Sai Vineeth, Jan 19, 2022
    #7


  8. Rajan Mourya

    Rajan Mourya Member


    Ok, i have tried this one as well but in this case their is one loop hole, If you copy past the existing file manually from file explorer and by changing it's Data id you can rename the company after opening it into tally so in that case their is two different company with same guid.
     
    Rajan Mourya, Jan 19, 2022
    #8


  9. Sai Vineeth

    Sai Vineeth Active Member


    th
    then use and operator while identifying company ( GUID="zxxxxxx" & Name = "xxxxx")
     
    Sai Vineeth, Jan 19, 2022
    #9


  10. Rajan Mourya

    Rajan Mourya Member


    Then in that case user has to buy more credits for the company that he has already enrolled.
     
    Rajan Mourya, Jan 19, 2022
    #10


  11. Rajan Mourya

    Rajan Mourya Member


    And we want to avoid that.
     
    Rajan Mourya, Jan 19, 2022
    #11


  12. Sai Vineeth

    Sai Vineeth Active Member


    then you have to charge based on GUID only
     
    Sai Vineeth, Jan 19, 2022
    #12


  13. Rajan Mourya

    Rajan Mourya Member


    OK, Thanks.
     
    Rajan Mourya, Jan 19, 2022
    #13


Share This Page