1. CLICK HERE TO JOIN WHATSAPP CHANNEL FOR TDL PROGRAMS

How to fetch all the closing balance values of a ledger using XML query in Tally

Discussion in 'Tally Integration' started by Researcher, Jul 17, 2021.

    
Tags:
  1. Researcher

    Researcher New Member


    One of our ledger has multiple closing balance values with dates specified for each closing balance . We want to fetch all the closing balance values along with the date information using XML request .
     
    Researcher, Jul 17, 2021
    #1


  2. Sai Vineeth

    Sai Vineeth Active Member


    Can you post sample XML of Ledger that has multiple closing balances
    because I never seen a ledger with multiple closing balances
     
    Sai Vineeth, Jul 17, 2021
    #2


  3. saravanan1999

    saravanan1999 New Member


    Hello VineethJi,
    How to get Bill wise Outstanding Debit And Credit Amount (Cr,Dr) Only Get Debit amount not geting credit amount
    Please Help,
    Thanks For Advance

    <ENVELOPE>
    <HEADER>
    <VERSION>1</VERSION>
    <TALLYREQUEST>Export</TALLYREQUEST>
    <TYPE>Data</TYPE>
    <ID>Custom Current Assets</ID>
    </HEADER>
    <BODY>
    <DESC>
    <STATICVARIABLES>
    <EXPLODEFLAG>Yes</EXPLODEFLAG>
    <SVEXPORTFORMAT>$$SysName:XML</SVEXPORTFORMAT>
    <SVCURRENTCOMPANY>${company}</SVCURRENTCOMPANY>
    <SVFROMDATE>${fromDate}</SVFROMDATE>
    <SVTODATE>${toDate}</SVTODATE>
    </STATICVARIABLES>
    <TDL>
    <TDLMESSAGE>
    <REPORT NAME="Custom Current Assets">
    <FORMS>OutDetails</FORMS>
    <TITLE>Simple OutDetails</TITLE>
    </REPORT>
    <FORM NAME="OutDetails">
    <TOPPARTS>OutDetails Part</TOPPARTS>
    <XMLTAG>"TallyGraphs"</XMLTAG>
    </FORM>
    <PART NAME="OutDetails Part">
    <TOPLINES>OutDetailsTitle,OutDetailsList</TOPLINES>
    <REPEAT>OutDetailsList:Ledger</REPEAT>
    <SCROLLED>Vertical</SCROLLED>
    </PART>
    <LINE NAME="OutDetailsTitle">
    <USE>OutDetailsList</USE>
    <LOCAL>Field : Default : Type : String </LOCAL>
    <LOCAL>Field : Field PartyLedgerName : Set as: "PartyLedgerName"</LOCAL>
    <LOCAL>Field : Field Group : Set as: "Group"</LOCAL>
    <LOCAL>Field : Field ClosingDr : Set as:$Closing Dr</LOCAL>
    <LOCAL>Field : Field ClosingCr : Set as:$Closing Cr</LOCAL>
    </LINE>
    <LINE NAME="OutDetailsList">
    <LEFTFIELDS>PartyLedgerName,Group,ClosingDr,ClosingCr</LEFTFIELDS>
    </LINE>
    <FIELD NAME="PartyLedgerName">
    <USE>Name Field</USE>
    <SET>$Name</SET>
    </FIELD>
    <FIELD NAME="Group">
    <USE>Name Field</USE>
    <SET>$Parent</SET>
    </FIELD>
    <FIELD NAME="ClosingDr">
    <USE>Amount Field</USE>
    <SET>If $IsDr="$ClosingBalance" Then $ClosingBalance else 0 </SET>
    </FIELD>
    <FIELD NAME="ClosingCr">
    <USE>Amount Field</USE>
    <SET>If Not $IsCr="$ClosingBalance" Then $ClosingBalance else 0 </SET>
    </FIELD>
    <COLLECTION NAME="Ledger" ISMODIFY="No">
    <TYPE>Ledger</TYPE>
    <FILTER>LedgerFilterVal</FILTER>
    <FETCH>ClosingBalance,LedgerName,Amount,Date</FETCH>
    <BY>IsParty : $IsPartyLedger</BY>
    <Compute>Credit : $ClosingBalance Cr</Compute>
    <Compute>Debit : $ClosingBalance Dr</Compute>
    </COLLECTION>
    <SYSTEM TYPE="Formulae" NAME="LedgerFilterVal">$$IsGrpOfGrp:$Parent:#PartyLedgerName</SYSTEM>
    </TDLMESSAGE>
    </TDL>
    </DESC>
    </BODY>
    </ENVELOPE>
     
    saravanan1999, Oct 15, 2021
    #3


  4. B Patil

    B Patil New Member


    You can call default reports "Bills Receivable","Bills Payable","Group Ledger Outstandings","Ledger Outstanding" etc


    <ENVELOPE>
    <HEADER>
    <TALLYREQUEST>EXPORT DATA </TALLYREQUEST>
    </HEADER>
    <BODY>
    <EXPORTDATA>
    <REQUESTDESC>
    <REPORTNAME>Bills Receivable</REPORTNAME>
    <STATICVARIABLES>
    <SVEXPORTFORMAT>$$SysName:XML</SVEXPORTFORMAT>
    <SVToDate>19950601</SVToDate>
    <GROUPNAME>Sundry Creditors</GROUPNAME>
    </STATICVARIABLES>
    </REQUESTDESC>
    </EXPORTDATA>
    </BODY>
    </ENVELOPE>

    Group Name can be your choice

    For a given ledger it can be

    <ENVELOPE>
    <HEADER>
    <TALLYREQUEST>EXPORT DATA </TALLYREQUEST>
    </HEADER>
    <BODY>
    <EXPORTDATA>
    <REQUESTDESC>
    <REPORTNAME>Ledger Outstandings</REPORTNAME>
    <STATICVARIABLES>
    <SVEXPORTFORMAT>$$SysName:XML</SVEXPORTFORMAT>
    <LEDGERNAME>XXXX Required Ledger Name</LEDGERNAME>
    <ShowBillRange>Pending Bills</ShowBillRange>
    </STATICVARIABLES>
    </REQUESTDESC>
    </EXPORTDATA>
    </BODY>
    </ENVELOPE>
     
    B Patil, Nov 25, 2021
    #4


  5. saravanan1999

    saravanan1999 New Member


    Thanks ji..

    And another one doubt
    Please Rectify this issue...


    I want to reduce my ouput lines how to apply filter to get only ALL Inventries.list(stockitem,rate,qty) and LedgerList(ledger name,ledger amount).
    And my code produce the some unwanted tags (eg: BatchAllocations,Billallocations,OLDAUDITENTRYIDS.LIST)

    <ENVELOPE>
    <HEADER>
    <VERSION>1</VERSION>
    <TALLYREQUEST>Export</TALLYREQUEST>
    <TYPE>Collection</TYPE>
    <ID>salesregister</ID>
    </HEADER>
    <BODY>
    <DESC>
    <STATICVARIABLES>
    <EXPLODEFLAG>Yes</EXPLODEFLAG>
    <SVEXPORTFORMAT>$$SysName:XML</SVEXPORTFORMAT>
    <SVFROMDATE>${fromDate}</SVFROMDATE>
    <SVTODATE>${toDate}</SVTODATE>
    </STATICVARIABLES>
    <TDL>
    <TDLMESSAGE>
    <COLLECTION NAME="salesregister">
    <TYPE>Voucher</TYPE>
    <FETCH>PartyLedgername,Amount,GrossRevenue</FETCH>
    <FILTERS>Filter_IsSales,Chkclsbal</FILTERS>
    </COLLECTION>
    <SYSTEM TYPE="Formulae" NAME="Filter_FilterQtyTotal">($$FilterQtyTotal:AllInventoryEntries:VATFltItemAndClass:$BilledQty)</SYSTEM>
    <SYSTEM TYPE="Formulae" NAME="Filter_IsSales">($$IsSales:$VoucherTypeName) </SYSTEM>
    <SYSTEM TYPE="Formulae" NAME="Chkclsbal"> $$Fullist:BatchAllocations:$BatchName</SYSTEM>
    </TDLMESSAGE>
    </TDL>
    </DESC>
    </BODY>
    </ENVELOPE>
     
    saravanan1999, Nov 26, 2021
    #5


  6. Abisha

    Abisha New Member


    New
    Hello sir, how to fetch Narration details?
    <ENVELOPE>
    <HEADER>
    <VERSION>1</VERSION>
    <TALLYREQUEST>Export</TALLYREQUEST>
    <TYPE>Data</TYPE>
    <ID>Group OutStandings</ID>
    </HEADER>
    <BODY>
    <DESC>
    <STATICVARIABLES>
    <SVCURRENTCOMPANY>${company}</SVCURRENTCOMPANY>
    <SVFROMDATE>${fromDate}</SVFROMDATE>
    <SVTODATE>${toDate}</SVTODATE>
    <SVEXPORTFORMAT>$$SysName:XML</SVEXPORTFORMAT>
    <GROUPNAME>Sundry Debtors</GROUPNAME>
    <SHOWBYBILL>Yes</SHOWBYBILL>
    <EXPLODEFLAG>Yes</EXPLODEFLAG>
    </STATICVARIABLES>
    </DESC>
    </BODY>
    </ENVELOPE>
     
    Abisha, Jan 24, 2022
    #6


  7. B Patil

    B Patil New Member


     
    B Patil, Jan 29, 2022
    #7


  8. B Patil

    B Patil New Member


    Add <ExplodeNarrFlag>Yes</ExplodeNarrFlag>
     
    B Patil, Jan 29, 2022
    #8


  9. Abisha

    Abisha New Member


    Thanks for your support,
    But its not working for the above code..
     
    Abisha, Feb 21, 2022
    #9


Share This Page