Need to Fetch Ledgerwise Group Outstanding in Xml Request

Discussion in 'Free Source Codes' started by Abisha, Nov 25, 2022.

    
  1. Abisha

    Abisha New Member


    The below code is getting Ledgerwise outstanding data in Tally Prime but in Tally ERP 9 it fetch data along with group details, I don't want group 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>$$GroupSundryDebtors</GROUPNAME>
    <IsLedgerwise>yes</IsLedgerwise>
    <EXPLODEFLAG>No</EXPLODEFLAG>
    </STATICVARIABLES>
    </DESC>
    </BODY>
    </ENVELOPE>

    <IsLedgerwise>yes</IsLedgerwise> Gets ledgerwise report in tally Prime. I think that <IsLedgerwise>yes</IsLedgerwise> tag is not working in tally ERP 9. Also I tried <DSPLEDGERTYPE>Item-wise</DSPLEDGERTYPE> , <DSPLEDGERWISE>yes</DSPLEDGERWISE> are not working.
    I want to fetch ledgerwise data on both tally prime as well as erp 9.
     


  2. Sai Vineeth

    Sai Vineeth Active Member


    Which version(full) of tally,
    you are using?
     


  3. Abisha

    Abisha New Member


    Tally Prime Edit Log - working
    Tally ERP 9 - not working
     


  4. Sai Vineeth

    Sai Vineeth Active Member


    In Tally erp9 which version you are using?
     


  5. Abisha

    Abisha New Member


    Latest version only 6.6.3
     


  6. Sai Vineeth

    Sai Vineeth Active Member


    I tested on 6.6.3 and its working fine
     


  7. Abisha

    Abisha New Member


    Code is working but Group details also Capturing right?
     


  8. Sai Vineeth

    Sai Vineeth Active Member


    yeah, group details also coming o_O
     


  9. Abisha

    Abisha New Member


    How to solve this??
     


  10. Sai Vineeth

    Sai Vineeth Active Member


    for now - I don't know, need to check
     


  11. Abisha

    Abisha New Member


    My Goal is to get credit and debit amount on group outstanding...

    Here is another code, But it capture only pending amount. So that only moved to the previously shared code.
    Check this code, is there any possible solution to add Cr/Dr amount here means it is also fine for me.

    <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>CurrentAssets</FORMS>
    <TITLE>Simple CurrentAssets </TITLE>
    </REPORT>
    <FORM NAME="CurrentAssets">
    <TOPPARTS>CurrentAssets Part</TOPPARTS>
    <XMLTAG>"TallyGraphs"</XMLTAG>
    </FORM>
    <PART NAME="CurrentAssets Part">
    <TOPLINES>CurrentAssets Line Title, CurrentAssets Details </TOPLINES>
    <REPEAT>CurrentAssets Details : GetGroupWithClosingAmt</REPEAT>
    <SCROLLED>Vertical</SCROLLED>
    <COMMONBORDERS>Yes</COMMONBORDERS>
    </PART>
    <LINE NAME="CurrentAssets Line Title">
    <USE>CurrentAssets Details</USE>
    <LOCAL>Field : Default : Type : String </LOCAL>
    <LOCAL>Field : Field PartyLedgerName : Set as: "Group Name"</LOCAL>
    <LOCAL>Field : Field DAmount : Set as: "DAmount"</LOCAL>
    <LOCAL>Field : Field CAmount : Set as: "CAmount"</LOCAL>
    </LINE>
    <LINE NAME="CurrentAssets Details">
    <LEFTFIELDS>PartyLedgerName</LEFTFIELDS>
    <RIGHTFIELDS>DAmount,CAmount</RIGHTFIELDS>
    <XMLTAG>MANI</XMLTAG>
    <EXPLODEFLAG>Yes</EXPLODEFLAG>
    <EXPLODE>LedgerExplodePart</EXPLODE>
    </LINE>
    <FIELD NAME="PartyLedgerName">
    <USE>Name Field</USE>
    <SET>$Name</SET>
    </FIELD>
    <FIELD NAME="DAmount">
    <USE>Amount Field</USE>
    <SET>$Debit</SET>
    </FIELD>
    <FIELD NAME="CAmount">
    <USE>Amount Field</USE>
    <SET>$Credit</SET>
    </FIELD>
    <PART NAME="LedgerExplodePart">
    <LINE>CurrentAssets Details1 </LINE>
    <REPEAT>CurrentAssets Details1 : GetLedgerCollAmt</REPEAT>
    </PART>
    <LINE NAME="CurrentAssets Details1">
    <LEFTFIELDS>LedgerNameTag,parentNameTag</LEFTFIELDS>
    <RIGHTFIELDS>AmountVal</RIGHTFIELDS>
    <XMLTAG>Ledger Details</XMLTAG>
    </LINE>
    <FIELD NAME="LedgerNameTag">
    <USE>Name Field</USE>
    <SET>$Name</SET>
    </FIELD>
    <FIELD NAME="parentNameTag">
    <USE>Name Field</USE>
    <SET>$Parent</SET>
    </FIELD>
    <FIELD NAME="AmountVal">
    <USE>Amount Field</USE>
    <SET>$GetClosingBal</SET>
    </FIELD>
    <COLLECTION NAME="GetGroupWithClosingAmt" ISMODIFY="No">
    <TYPE>Group</TYPE>
    <FETCH>Name,Parent,TBalOpening,DBalClosing</FETCH>
    <Compute>Debit:$DebitClosingBalance</Compute>
    <Compute>Credit:$CreditClosingBalance</Compute>
    <Filter>LedgerGroupFilter</Filter>
    </COLLECTION>
    <COLLECTION NAME="GetLedgerCollAmt" ISMODIFY="No">
    <TYPE>Ledger</TYPE>
    <FETCH>Name,Parent,TBalOpening,DBalClosing</FETCH>
    <Compute>GetClosingBal:$ClosingBalance</Compute>
    <Filter>LedgerFilterVal</Filter>
    </COLLECTION>
    <SYSTEM TYPE="Formulae" NAME="LedgerGroupFilter">$Name="Sundry Debtors"</SYSTEM>
    <SYSTEM TYPE="Formulae" NAME="LedgerFilterVal">$$IsGrpOfGrp:$Parent:#PartyLedgerName</SYSTEM>
    </TDLMESSAGE>

    </TDL>
    </DESC>
    </BODY>
    </ENVELOPE>
     


  12. Sai Vineeth

    Sai Vineeth Active Member


    Use logic from this answer

     


  13. Abisha

    Abisha New Member


    Noted , But I'm expecting credit amount , debit amount , not closing balance..

    I will show one example

    While export from tally :
    <DSPACCNAME>
    <DSPDISPNAME>S.V.S Computers</DSPDISPNAME>
    </DSPACCNAME>
    <DSPACCINFO>
    <DSPCLDRAMT>
    <DSPCLDRAMTA>89437.50</DSPCLDRAMTA> //credit amt
    </DSPCLDRAMT>
    <DSPCLCRAMT>
    <DSPCLCRAMTA>93015.00</DSPCLCRAMTA> //debit amt
    </DSPCLCRAMT>

    Runing TDL Functions code:

    closing balance = 89437.50 -93015.00 =3577.50

    <LEDGERDETAILS>
    <LEDGERNAMETAG>S.V.S Computers</LEDGERNAMETAG>
    <PARENTNAMETAG>South Debtors</PARENTNAMETAG>
    <DRAMOUNT></DRAMOUNT>
    <CRAMOUNT>3577.50</CRAMOUNT> //closing balance
    </LEDGERDETAILS>

    I'm expecting total credit & debit amount on the above code not closing balance

    <DSPCLDRAMTA>89437.50</DSPCLDRAMTA> //credit amt
    </DSPCLDRAMT>
    <DSPCLCRAMT>
    <DSPCLCRAMTA>93015.00</DSPCLCRAMTA> //debit amt
     
    Last edited: Dec 2, 2022


Share This Page