1. CLICK HERE TO JOIN WHATSAPP CHANNEL FOR TDL PROGRAMS

help needed pls filter data with only sundry debtor and creditor and their address full list

Discussion in 'Tally Integration' started by gauravss, May 6, 2023.

    
  1. gauravss

    gauravss Member


    <?xml version="1.0" encoding="utf-8"?>
    <ENVELOPE>
    <HEADER>
    <VERSION>1</VERSION>
    <TALLYREQUEST>Export</TALLYREQUEST>
    <TYPE>Data</TYPE>
    <ID>MyReportLedgerTable</ID>
    </HEADER>
    <BODY>
    <DESC>
    <STATICVARIABLES>
    <SVEXPORTFORMAT>ASCII (Comma Delimited)</SVEXPORTFORMAT>
    </STATICVARIABLES>
    <TDL>
    <TDLMESSAGE>
    <REPORT NAME="MyReportLedgerTable">
    <FORMS>MyForm</FORMS>
    </REPORT>
    <FORM NAME="MyForm">
    <PARTS>MyPart</PARTS>
    </FORM>
    <PART NAME="MyPart">
    <LINES>MyLine</LINES>
    <REPEAT>MyLine : MyCollection</REPEAT>
    <SCROLLED>Vertical</SCROLLED>
    </PART>
    <LINE NAME="MyLine">
    <FIELDS>FldGuid,FldName,FldParent,FldIsRevenue,FldIsDeemedPositive,FldSortPosition</FIELDS>
    </LINE>
    <FIELD NAME="FldGuid">
    <SET>$Guid</SET>
    </FIELD>
    <FIELD NAME="FldName">
    <SET>$$StringFindAndReplace:$Name:'"':'""'</SET>
    </FIELD>
    <FIELD NAME="FldParent">
    <SET>$$StringFindAndReplace:$Parent:'"':'""'</SET>
    </FIELD>
    <FIELD NAME="FldIsRevenue">
    <SET>$IsRevenue</SET>
    </FIELD>
    <FIELD NAME="FldIsDeemedPositive">
    <SET>$IsDeemedPositive</SET>
    </FIELD>
    <FIELD NAME="FldSortPosition">
    <SET>$SortPosition</SET>
    </FIELD>
    <COLLECTION NAME="MyCollection">
    <TYPE>Ledger</TYPE>
    </COLLECTION>
    </TDLMESSAGE>
    </TDL>
    </DESC>
    </BODY>
    </ENVELOPE>
     
    gauravss, May 6, 2023
    #1


  2. gauravss

    gauravss Member

    gauravss, May 6, 2023
    #2


  3. gauravss

    gauravss Member


    <COLLECTION NAME="MyCollection">
    <TYPE>Ledger</TYPE>
    <Childof>Sundry Debtors</Childof>
    <NATIVEMETHOD>Sundry Creditors</NATIVEMETHOD>
    <!-- * will fetch all fields if you want specific fields you can specify -->
    <NATIVEMETHOD>Name,Parent,*</NATIVEMETHOD>
    </COLLECTION>

    still not able to add creditor
     
    gauravss, May 6, 2023
    #3


  4. Sai Vineeth

    Sai Vineeth Active Member

    Sai Vineeth, May 7, 2023
    #4


  5. Sai Vineeth

    Sai Vineeth Active Member


    Code:
           <COLLECTION ISMODIFY="No" ISFIXED="No" ISINITIALIZE="No" ISOPTION="No" ISINTERNAL="No" NAME="CustomLedgerCollection">
            <TYPE>Ledger: Group</TYPE>
            <CHILDOF>SundryDebtors</CHILDOF>
            <BELONGSTO>Yes</BELONGSTO>
            <NATIVEMETHOD>*, *.*</NATIVEMETHOD>
          </COLLECTION>
     
    Sai Vineeth, May 7, 2023
    #5


  6. Sai Vineeth

    Sai Vineeth Active Member


    Similar approach for SundryCreditors also
    use
    <CHILDOF>SundryCreditors</CHILDOF>
     
    Sai Vineeth, May 7, 2023
    #6


  7. gauravss

    gauravss Member


    used bellowed mention way with your help but problem is if pincode or any data is blank its not getting data further how to solve it

    thanks for your help

    <?xml version="1.0" encoding="utf-8"?>
    <ENVELOPE>
    <HEADER>
    <VERSION>1</VERSION>
    <TALLYREQUEST>Export</TALLYREQUEST>
    <TYPE>Data</TYPE>
    <ID>MyReportLedgerTable</ID>
    </HEADER>
    <BODY>
    <DESC>
    <STATICVARIABLES>
    <SVEXPORTFORMAT>ASCII (Comma Delimited)</SVEXPORTFORMAT>
    </STATICVARIABLES>
    <TDL>
    <TDLMESSAGE>
    <REPORT NAME="MyReportLedgerTable">
    <FORMS>MyForm</FORMS>
    </REPORT>
    <FORM NAME="MyForm">
    <PARTS>MyPart</PARTS>
    </FORM>
    <PART NAME="MyPart">
    <LINES>MyLine</LINES>
    <REPEAT>MyLine : MyCollection</REPEAT>
    <SCROLLED>Vertical</SCROLLED>
    </PART>
    <LINE NAME="MyLine">
    <FIELDS>FldGuid,FldSortPosition</FIELDS>
    </LINE>
    <FIELD NAME="FldGuid">
    <SET>$$StringFindAndReplace:$Name:'"':'""'</SET>
    </FIELD>
    <FIELD NAME="FldName">
    <SET></SET>
    </FIELD>
    <FIELD NAME="FldParent">
    <SET></SET>
    </FIELD>
    <FIELD NAME="FldIsRevenue">
    <SET></SET>
    </FIELD>
    <FIELD NAME="FldIsDeemedPositive">
    <SET></SET>
    </FIELD>
    <FIELD NAME="FldSortPosition">
    <SET>$PinCode</SET>
    </FIELD>
    <COLLECTION ISMODIFY="No" ISFIXED="No" ISINITIALIZE="No" ISOPTION="No" ISINTERNAL="No" NAME="MyCollection">
    <TYPE>Ledger</TYPE>
    <BELONGSTO>Yes</BELONGSTO>
    <NATIVEMETHOD>*, *.*</NATIVEMETHOD>
    </COLLECTION>

    </TDLMESSAGE>
    </TDL>
    </DESC>
    </BODY>
    </ENVELOPE>
     
    gauravss, May 16, 2023
    #7


Share This Page