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.
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.
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.
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.
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.