How to fetch the child element of ALLINVENTORYENTRIES.LIST

Discussion in 'Tally Integration' started by Researcher1, Jun 10, 2024 at 5:42 PM.

    
  1. Researcher1

    Researcher1 Member


    I want to retrieve the VATASSBLVALUE from the Columnar Sales Register report.
    Please note that VATASSBLVALUE is a child element of ALLINVENTORYENTRIES.LIST.

    Kindly modify the following custom report XML request to fulfill my requirement

    Code:
    <ENVELOPE>
        <HEADER>
            <VERSION>1</VERSION>
            <TALLYREQUEST>Export</TALLYREQUEST>
            <TYPE>Data</TYPE>
            <ID>DaybookGR</ID>
        </HEADER>
        <BODY>
            <DESC>
                <STATICVARIABLES>
    
                </STATICVARIABLES>
                <TDL>
                    <TDLMESSAGE>
                        <REPORT NAME="DaybookGR"> <FORMS>DaybookGR</FORMS></REPORT>
                        <FORM NAME="DaybookGR"><TOPPARTS>DaybookGR</TOPPARTS></FORM>
                        <PART NAME="DaybookGR"><TOPLINES>Daybook Details</TOPLINES><REPEAT>Daybook Details : GetLedgerCollAmt</REPEAT><SCROLLED>Vertical</SCROLLED></PART>
                        <PART NAME="Ledgerlist Line Title"><TOPLINES>Ledger Details</TOPLINES><REPEAT>Ledger Details:LedgerEntries</REPEAT> </PART>
                        <LINE NAME="Daybook Details"><RIGHTFIELDS>vchType,VoucherNumber</RIGHTFIELDS><XMLTAG>Voucher</XMLTAG><EXPLODE>Ledgerlist Line Title</EXPLODE></LINE>
                        <LINE NAME="Ledger Details"><LEFTFIELDS>LedgerName, Amount</LEFTFIELDS><XMLTAG>LedgerList</XMLTAG></LINE>
                        <FIELD NAME="LedgerName"><SET>$LedgerName</SET></FIELD>
                        <FIELD NAME="VoucherNumber"><SET>$VoucherNumber</SET> </FIELD>
                        <FIELD NAME="Amount"><SET>$Amount</SET><USE>Amount Field</USE></FIELD>
                        <COLLECTION NAME="GetLedgerCollAmt" ISMODIFY="No"><TYPE>Voucher</TYPE>
         <FETCH>VoucherNumber,LedgerName,VoucherTypeName</FETCH></COLLECTION>
                    </TDLMESSAGE>
                </TDL>
            </DESC>
        </BODY>
    </ENVELOPE>
     
    Last edited: Jun 11, 2024 at 12:33 PM


Share This Page