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