I will help you send me your requirements in a mail jayashritdlexpert@gmail.com or otherwise post here ,,
I am not TDL developer but I can Integrate external applications with Tally using C#, python, VBA If you require Tally Integration specialist ping me at contact@saivineeth.com
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>
;;;Try the below code: <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> <SETAS>If $$IsDr:$ClosingBalance Then $ClosingBalance Else 0</SETAS> </FIELD> <FIELD NAME="ClosingCr"> <USE>Amount Field</USE> <SETAS>If $$IsDr:$ClosingBalance Then 0 Else $ClosingBalance</SETAS> </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>
This code Get only debit or credit amount, But i want Ledger Outstanding (Bill Wise) Debit and Credit Amount. Thanks For Advance <ENVELOPE> <HEADER> <VERSION>1</VERSION> <TALLYREQUEST>Export</TALLYREQUEST> <TYPE>Data</TYPE> <ID>Outstandings</ID> </HEADER> <BODY> <DESC> <STATICVARIABLES> <EXPLODEFLAG>Yes</EXPLODEFLAG> <SVEXPORTFORMAT>$$SysName:XML</SVEXPORTFORMAT> <SVCURRENTCOMPANY>${company}</SVCURRENTCOMPANY> <SVFROMDATE>1-Apr-2009</SVFROMDATE> <SVTODATE>31-Mar-2021</SVTODATE> </STATICVARIABLES> <TDL> <TDLMESSAGE> <REPORT NAME="Outstandings"> <FORMS>CurrentAssets</FORMS> <TITLE>Simple CurrentAssets</TITLE> </REPORT> <FORM NAME="CurrentAssets"> <TOPPARTS>CurrentAssets Part</TOPPARTS> <XMLTAG>"TallyGraphs"</XMLTAG> </FORM> <PART NAME="CurrentAssets Part"> <TOPLINES>CurrentAssetsList</TOPLINES> <REPEAT>CurrentAssetsList:Ledger</REPEAT> <SCROLLED>Vertical</SCROLLED> </PART> <LINE NAME="CurrentAssetsList"> <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>$GetClosingBalDr</SET> </FIELD> <FIELD NAME="ClosingCr"> <USE>Amount Field</USE> <SET>$GetClosingBalCr</SET> </FIELD> <COLLECTION NAME="Ledger" ISMODIFY="No"> <TYPE>Group</TYPE> <FILTER>LedgerGroupFilter</FILTER> <FETCH>SVFROMDATE,SVTODATE,Name,Parent,Date,TBalOpening,DBalClosing,Date</FETCH> <Compute>GetClosingBalDr : $BILLOP</Compute> <Compute>GetClosingBalCr : $BILLCL</Compute> </COLLECTION> <SYSTEM TYPE="Formulae" NAME="LedgerGroupFilter">$Name="Sundry Debtors"</SYSTEM> <SYSTEM TYPE="Formulae" NAME="LedgerFilterVal">$$IsGrpOfGrp:$Parent:#PartyLedgerName</SYSTEM> <SYSTEM TYPE="Formulae" NAME="Filter_DateRange">($Date>=$$Date:##SVFROMDATE) AND ($Date<=$$Date:##SVTODATE)</SYSTEM> </TDLMESSAGE> </TDL> </DESC> </BODY> </ENVELOPE>
This code Get only debit or credit amount, But i want Ledger Outstanding (Bill Wise) Debit and Credit Amount. Thanks For Advance <ENVELOPE> <HEADER> <VERSION>1</VERSION> <TALLYREQUEST>Export</TALLYREQUEST> <TYPE>Data</TYPE> <ID>Outstandings</ID> </HEADER> <BODY> <DESC> <STATICVARIABLES> <EXPLODEFLAG>Yes</EXPLODEFLAG> <SVEXPORTFORMAT>$$SysName:XML</SVEXPORTFORMAT> <SVCURRENTCOMPANY>${company}</SVCURRENTCOMPANY> <SVFROMDATE>1-Apr-2009</SVFROMDATE> <SVTODATE>31-Mar-2021</SVTODATE> </STATICVARIABLES> <TDL> <TDLMESSAGE> <REPORT NAME="Outstandings"> <FORMS>CurrentAssets</FORMS> <TITLE>Simple CurrentAssets</TITLE> </REPORT> <FORM NAME="CurrentAssets"> <TOPPARTS>CurrentAssets Part</TOPPARTS> <XMLTAG>"TallyGraphs"</XMLTAG> </FORM> <PART NAME="CurrentAssets Part"> <TOPLINES>CurrentAssetsList</TOPLINES> <REPEAT>CurrentAssetsList:Ledger</REPEAT> <SCROLLED>Vertical</SCROLLED> </PART> <LINE NAME="CurrentAssetsList"> <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>$GetClosingBalDr</SET> </FIELD> <FIELD NAME="ClosingCr"> <USE>Amount Field</USE> <SET>$GetClosingBalCr</SET> </FIELD> <COLLECTION NAME="Ledger" ISMODIFY="No"> <TYPE>Group</TYPE> <FILTER>LedgerGroupFilter</FILTER> <FETCH>SVFROMDATE,SVTODATE,Name,Parent,Date,TBalOpening,DBalClosing,Date</FETCH> <Compute>GetClosingBalDr : $BILLOP</Compute> <Compute>GetClosingBalCr : $BILLCL</Compute> </COLLECTION> <SYSTEM TYPE="Formulae" NAME="LedgerGroupFilter">$Name="Sundry Debtors"</SYSTEM> <SYSTEM TYPE="Formulae" NAME="LedgerFilterVal">$$IsGrpOfGrp:$Parent:#PartyLedgerName</SYSTEM> <SYSTEM TYPE="Formulae" NAME="Filter_DateRange">($Date>=$$Date:##SVFROMDATE) AND ($Date<=$$Date:##SVTODATE)</SYSTEM> </TDLMESSAGE> </TDL> </DESC> </BODY> </ENVELOPE>
vishnu Joshi, can you connect me on whatsapp 9923002403. i am looking for TDL developer for my company.