get last master Id and filter based on master ID For Ex: if last master Id is 1000 and batch size is 250 in first batch we can get first 250 by filtering master id < 250, next batch masterid >250 and master id < 500
Can you please share the XML for the same? Right now I am using the below XML which returns all the ledgers. ``` <ENVELOPE> <HEADER> <VERSION>1</VERSION> <TALLYREQUEST>Export</TALLYREQUEST> <TYPE>COLLECTION</TYPE> <ID>saltotal</ID> </HEADER> <BODY> <DESC> <STATICVARIABLES> <SVEXPORTFORMAT>$$SysName:XML</SVEXPORTFORMAT> </STATICVARIABLES> <TDL> <TDLMESSAGE> <COLLECTION NAME="saltotal" ISINITIALIZE="Yes">" <TYPE>Ledger</TYPE> <BELONGSTO>Yes</BELONGSTO> <SVFROMDATE TYPE='Date'>3.9.2021</SVFROMDATE> <SVTODATE TYPE='Date'>3.9.2021</SVTODATE> <FETCH>Name,Guid,MasterId,Alterid,OnlyAlias,Parent,PriceLevel,IsBillWiseOn,BillCreditPeriod,CREDITLIMIT,AffectsStock,MailingName,Address,CountryName,LedStateName,Pincode,PartyGSTIN,Gstregistrationtype,Gst Type,Gstapplicable,Gstappropriateto,GstDutyHead,GstNatureofsupply,gsttypeofsupply,LedgerContact,Ledgerphone,LedgerMobile,LedgerFax,Email,Emailcc,Website,Panstatus,pannumber,Itno,masteralterid,GSTDETAILS.LIST,SVCURRENTCOMPANY</FETCH> <COMPUTE>masteralterid:$MasterId + $AlterId</COMPUTE> <Compute>ParentName : $_PrimaryGroup</Compute> </COLLECTION> </TDLMESSAGE> </TDL> </DESC> </BODY> </ENVELOPE>```
I already answered similar question asked by you in stackoverflow https://stackoverflow.com/questions...ata-from-tally-prime-ranging-between-alterids Add Filter to Collection Code: ...... <filter>MasterFilter</filter> </COLLECTION> <SYSTEM TYPE="Formulae" NAME="ActiveCompanyFilter">$masterid < 250</SYSTEM> .....