XML request to export all ledgers under Current Liabilities

Discussion in 'Tally Integration' started by Sanket Patel, Jun 22, 2021.

    
Tags:
  1. Sanket Patel

    Sanket Patel New Member


    Hello,
    How can I send xml request to get all Ledgers under "Current Liabilities" group with all tags information in xml.

    Below is the sample xml which I manually exported from Tally. But I want this in response by sending XML request to Tally.

    Code:
    <TALLYMESSAGE xmlns:UDF="TallyUDF">
         <LEDGER NAME="OUTPUT CGST @ 0%" RESERVEDNAME="">
          <OLDAUDITENTRYIDS.LIST TYPE="Number">
           <OLDAUDITENTRYIDS>-1</OLDAUDITENTRYIDS>
          </OLDAUDITENTRYIDS.LIST>
          <CREATEDDATE>20210620</CREATEDDATE>
          <GUID>5e6ee970-0f02-4e92-ba51-acd52788d5be-00000476</GUID>
          <CURRENCYNAME>₹</CURRENCYNAME>
          <PARENT>GST</PARENT>
          <CREATEDBY>sanket</CREATEDBY>
          <TAXCLASSIFICATIONNAME/>
          <TAXTYPE>GST</TAXTYPE>
          <GSTTYPE/>
          <APPROPRIATEFOR/>
          <GSTDUTYHEAD>Central Tax</GSTDUTYHEAD>
          <ROUNDINGMETHOD/>
          <SERVICECATEGORY>&#4; Not Applicable</SERVICECATEGORY>
          <EXCISELEDGERCLASSIFICATION/>
          <EXCISEDUTYTYPE/>
          <EXCISENATUREOFPURCHASE/>
          <LEDGERFBTCATEGORY/>
          <ISBILLWISEON>No</ISBILLWISEON>
          <ISCOSTCENTRESON>No</ISCOSTCENTRESON>
          <ISINTERESTON>No</ISINTERESTON>
          <ALLOWINMOBILE>No</ALLOWINMOBILE>
          <ISCOSTTRACKINGON>No</ISCOSTTRACKINGON>
          <ISBENEFICIARYCODEON>No</ISBENEFICIARYCODEON>
          <PLASINCOMEEXPENSE>No</PLASINCOMEEXPENSE>
          <ISUPDATINGTARGETID>No</ISUPDATINGTARGETID>
          <ASORIGINAL>Yes</ASORIGINAL>
          <ISCONDENSED>No</ISCONDENSED>
          <AFFECTSSTOCK>No</AFFECTSSTOCK>
          <ISRATEINCLUSIVEVAT>No</ISRATEINCLUSIVEVAT>
          <FORPAYROLL>No</FORPAYROLL>
          <ISABCENABLED>No</ISABCENABLED>
          <ISCREDITDAYSCHKON>No</ISCREDITDAYSCHKON>
          <INTERESTONBILLWISE>No</INTERESTONBILLWISE>
          <OVERRIDEINTEREST>No</OVERRIDEINTEREST>
          <OVERRIDEADVINTEREST>No</OVERRIDEADVINTEREST>
          <USEFORVAT>No</USEFORVAT>
          <IGNORETDSEXEMPT>No</IGNORETDSEXEMPT>
          <ISTCSAPPLICABLE>No</ISTCSAPPLICABLE>
          <ISTDSAPPLICABLE>No</ISTDSAPPLICABLE>
          <ISFBTAPPLICABLE>No</ISFBTAPPLICABLE>
          <ISGSTAPPLICABLE>No</ISGSTAPPLICABLE>
          <ISEXCISEAPPLICABLE>No</ISEXCISEAPPLICABLE>
          <ISTDSEXPENSE>No</ISTDSEXPENSE>
          <ISEDLIAPPLICABLE>No</ISEDLIAPPLICABLE>
          <ISRELATEDPARTY>No</ISRELATEDPARTY>
          <USEFORESIELIGIBILITY>No</USEFORESIELIGIBILITY>
          <ISINTERESTINCLLASTDAY>No</ISINTERESTINCLLASTDAY>
          <APPROPRIATETAXVALUE>No</APPROPRIATETAXVALUE>
          <ISBEHAVEASDUTY>No</ISBEHAVEASDUTY>
          <INTERESTINCLDAYOFADDITION>No</INTERESTINCLDAYOFADDITION>
          <INTERESTINCLDAYOFDEDUCTION>No</INTERESTINCLDAYOFDEDUCTION>
          <ISOTHTERRITORYASSESSEE>No</ISOTHTERRITORYASSESSEE>
          <OVERRIDECREDITLIMIT>No</OVERRIDECREDITLIMIT>
          <ISAGAINSTFORMC>No</ISAGAINSTFORMC>
          <ISCHEQUEPRINTINGENABLED>Yes</ISCHEQUEPRINTINGENABLED>
          <ISPAYUPLOAD>No</ISPAYUPLOAD>
          <ISPAYBATCHONLYSAL>No</ISPAYBATCHONLYSAL>
          <ISBNFCODESUPPORTED>No</ISBNFCODESUPPORTED>
          <ALLOWEXPORTWITHERRORS>No</ALLOWEXPORTWITHERRORS>
          <CONSIDERPURCHASEFOREXPORT>No</CONSIDERPURCHASEFOREXPORT>
          <ISTRANSPORTER>No</ISTRANSPORTER>
          <USEFORNOTIONALITC>No</USEFORNOTIONALITC>
          <ISECOMMOPERATOR>No</ISECOMMOPERATOR>
          <SHOWINPAYSLIP>No</SHOWINPAYSLIP>
          <USEFORGRATUITY>No</USEFORGRATUITY>
          <ISTDSPROJECTED>No</ISTDSPROJECTED>
          <FORSERVICETAX>No</FORSERVICETAX>
          <ISINPUTCREDIT>No</ISINPUTCREDIT>
          <ISEXEMPTED>No</ISEXEMPTED>
          <ISABATEMENTAPPLICABLE>No</ISABATEMENTAPPLICABLE>
          <ISSTXPARTY>No</ISSTXPARTY>
          <ISSTXNONREALIZEDTYPE>No</ISSTXNONREALIZEDTYPE>
          <ISUSEDFORCVD>No</ISUSEDFORCVD>
          <LEDBELONGSTONONTAXABLE>No</LEDBELONGSTONONTAXABLE>
          <ISEXCISEMERCHANTEXPORTER>No</ISEXCISEMERCHANTEXPORTER>
          <ISPARTYEXEMPTED>No</ISPARTYEXEMPTED>
          <ISSEZPARTY>No</ISSEZPARTY>
          <TDSDEDUCTEEISSPECIALRATE>No</TDSDEDUCTEEISSPECIALRATE>
          <ISECHEQUESUPPORTED>No</ISECHEQUESUPPORTED>
          <ISEDDSUPPORTED>No</ISEDDSUPPORTED>
          <HASECHEQUEDELIVERYMODE>No</HASECHEQUEDELIVERYMODE>
          <HASECHEQUEDELIVERYTO>No</HASECHEQUEDELIVERYTO>
          <HASECHEQUEPRINTLOCATION>No</HASECHEQUEPRINTLOCATION>
          <HASECHEQUEPAYABLELOCATION>No</HASECHEQUEPAYABLELOCATION>
          <HASECHEQUEBANKLOCATION>No</HASECHEQUEBANKLOCATION>
          <HASEDDDELIVERYMODE>No</HASEDDDELIVERYMODE>
          <HASEDDDELIVERYTO>No</HASEDDDELIVERYTO>
          <HASEDDPRINTLOCATION>No</HASEDDPRINTLOCATION>
          <HASEDDPAYABLELOCATION>No</HASEDDPAYABLELOCATION>
          <HASEDDBANKLOCATION>No</HASEDDBANKLOCATION>
          <ISEBANKINGENABLED>No</ISEBANKINGENABLED>
          <ISEXPORTFILEENCRYPTED>No</ISEXPORTFILEENCRYPTED>
          <ISBATCHENABLED>No</ISBATCHENABLED>
          <ISPRODUCTCODEBASED>No</ISPRODUCTCODEBASED>
          <HASEDDCITY>No</HASEDDCITY>
          <HASECHEQUECITY>No</HASECHEQUECITY>
          <ISFILENAMEFORMATSUPPORTED>No</ISFILENAMEFORMATSUPPORTED>
          <HASCLIENTCODE>No</HASCLIENTCODE>
          <PAYINSISBATCHAPPLICABLE>No</PAYINSISBATCHAPPLICABLE>
          <PAYINSISFILENUMAPP>No</PAYINSISFILENUMAPP>
          <ISSALARYTRANSGROUPEDFORBRS>No</ISSALARYTRANSGROUPEDFORBRS>
          <ISEBANKINGSUPPORTED>No</ISEBANKINGSUPPORTED>
          <ISSCBUAE>No</ISSCBUAE>
          <ISBANKSTATUSAPP>No</ISBANKSTATUSAPP>
          <ISSALARYGROUPED>No</ISSALARYGROUPED>
          <USEFORPURCHASETAX>No</USEFORPURCHASETAX>
          <AUDITED>No</AUDITED>
          <SORTPOSITION> 1000</SORTPOSITION>
          <ALTERID> 1259</ALTERID>
          <SERVICETAXDETAILS.LIST>      </SERVICETAXDETAILS.LIST>
          <LBTREGNDETAILS.LIST>      </LBTREGNDETAILS.LIST>
          <VATDETAILS.LIST>      </VATDETAILS.LIST>
          <SALESTAXCESSDETAILS.LIST>      </SALESTAXCESSDETAILS.LIST>
          <GSTDETAILS.LIST>      </GSTDETAILS.LIST>
          <LANGUAGENAME.LIST>
           <NAME.LIST TYPE="String">
            <NAME>OUTPUT CGST @ 0%</NAME>
           </NAME.LIST>
           <LANGUAGEID> 1033</LANGUAGEID>
          </LANGUAGENAME.LIST>
          <XBRLDETAIL.LIST>      </XBRLDETAIL.LIST>
          <AUDITDETAILS.LIST>      </AUDITDETAILS.LIST>
          <SCHVIDETAILS.LIST>      </SCHVIDETAILS.LIST>
          <EXCISETARIFFDETAILS.LIST>      </EXCISETARIFFDETAILS.LIST>
          <TCSCATEGORYDETAILS.LIST>      </TCSCATEGORYDETAILS.LIST>
          <TDSCATEGORYDETAILS.LIST>      </TDSCATEGORYDETAILS.LIST>
          <SLABPERIOD.LIST>      </SLABPERIOD.LIST>
          <GRATUITYPERIOD.LIST>      </GRATUITYPERIOD.LIST>
          <ADDITIONALCOMPUTATIONS.LIST>      </ADDITIONALCOMPUTATIONS.LIST>
          <EXCISEJURISDICTIONDETAILS.LIST>      </EXCISEJURISDICTIONDETAILS.LIST>
          <EXCLUDEDTAXATIONS.LIST>      </EXCLUDEDTAXATIONS.LIST>
          <BANKALLOCATIONS.LIST>      </BANKALLOCATIONS.LIST>
          <PAYMENTDETAILS.LIST>      </PAYMENTDETAILS.LIST>
          <BANKEXPORTFORMATS.LIST>      </BANKEXPORTFORMATS.LIST>
          <BILLALLOCATIONS.LIST>      </BILLALLOCATIONS.LIST>
          <INTERESTCOLLECTION.LIST>      </INTERESTCOLLECTION.LIST>
          <LEDGERCLOSINGVALUES.LIST>      </LEDGERCLOSINGVALUES.LIST>
          <LEDGERAUDITCLASS.LIST>      </LEDGERAUDITCLASS.LIST>
          <OLDAUDITENTRIES.LIST>      </OLDAUDITENTRIES.LIST>
          <TDSEXEMPTIONRULES.LIST>      </TDSEXEMPTIONRULES.LIST>
          <DEDUCTINSAMEVCHRULES.LIST>      </DEDUCTINSAMEVCHRULES.LIST>
          <LOWERDEDUCTION.LIST>      </LOWERDEDUCTION.LIST>
          <STXABATEMENTDETAILS.LIST>      </STXABATEMENTDETAILS.LIST>
          <LEDMULTIADDRESSLIST.LIST>      </LEDMULTIADDRESSLIST.LIST>
          <STXTAXDETAILS.LIST>      </STXTAXDETAILS.LIST>
          <CHEQUERANGE.LIST>      </CHEQUERANGE.LIST>
          <DEFAULTVCHCHEQUEDETAILS.LIST>      </DEFAULTVCHCHEQUEDETAILS.LIST>
          <ACCOUNTAUDITENTRIES.LIST>      </ACCOUNTAUDITENTRIES.LIST>
          <AUDITENTRIES.LIST>      </AUDITENTRIES.LIST>
          <BRSIMPORTEDINFO.LIST>      </BRSIMPORTEDINFO.LIST>
          <AUTOBRSCONFIGS.LIST>      </AUTOBRSCONFIGS.LIST>
          <BANKURENTRIES.LIST>      </BANKURENTRIES.LIST>
          <DEFAULTCHEQUEDETAILS.LIST>      </DEFAULTCHEQUEDETAILS.LIST>
          <DEFAULTOPENINGCHEQUEDETAILS.LIST>      </DEFAULTOPENINGCHEQUEDETAILS.LIST>
          <CANCELLEDPAYALLOCATIONS.LIST>      </CANCELLEDPAYALLOCATIONS.LIST>
          <ECHEQUEPRINTLOCATION.LIST>      </ECHEQUEPRINTLOCATION.LIST>
          <ECHEQUEPAYABLELOCATION.LIST>      </ECHEQUEPAYABLELOCATION.LIST>
          <EDDPRINTLOCATION.LIST>      </EDDPRINTLOCATION.LIST>
          <EDDPAYABLELOCATION.LIST>      </EDDPAYABLELOCATION.LIST>
          <AVAILABLETRANSACTIONTYPES.LIST>      </AVAILABLETRANSACTIONTYPES.LIST>
          <LEDPAYINSCONFIGS.LIST>      </LEDPAYINSCONFIGS.LIST>
          <TYPECODEDETAILS.LIST>      </TYPECODEDETAILS.LIST>
          <FIELDVALIDATIONDETAILS.LIST>      </FIELDVALIDATIONDETAILS.LIST>
          <INPUTCRALLOCS.LIST>      </INPUTCRALLOCS.LIST>
          <GSTCLASSFNIGSTRATES.LIST>      </GSTCLASSFNIGSTRATES.LIST>
          <EXTARIFFDUTYHEADDETAILS.LIST>      </EXTARIFFDUTYHEADDETAILS.LIST>
          <VOUCHERTYPEPRODUCTCODES.LIST>      </VOUCHERTYPEPRODUCTCODES.LIST>
         </LEDGER>
        </TALLYMESSAGE>
     


  2. Sai Vineeth

    Sai Vineeth Active Member


    Use this XML - Custom Ledger Collection XML
    Change
    Code:
    <SYSTEM TYPE="Formulae" NAME="Ledgerfilter">$Name="Abhilashloan a/c"</SYSTEM>
    To
    Code:
    <SYSTEM TYPE="Formulae" NAME="Ledgerfilter">$Parent="Current Liabilities"</SYSTEM>
     


Share This Page