BankersDate tag must be Fetched under BankAllocations.LIST tag in Sales/Purchase register XML

Discussion in 'Tally Integration' started by Researcher, Jan 8, 2025.

Tags:
  1. Researcher

    Researcher New Member


    While fetching the Sales/Purchase Register using an XML request in Tally Prime, I want to retrieve the BANKERSDATE tag under the BANKALLOCATIONS.LIST tag.

    Currently, it is appearing only under the VOUCHERS tag. How can I modify the request to get the desired response? Below is the query I tried executing, but it is not working.
    Code:
    <ENVELOPE>
    <HEADER>
        <VERSION>1</VERSION>
        <TALLYREQUEST>Export</TALLYREQUEST>
        <TYPE>Data</TYPE>
        <ID>DaybookGR</ID>
    </HEADER>
    <BODY>
        <DESC>
            <STATICVARIABLES>
                <EXPLODEFLAG>Yes</EXPLODEFLAG>
                <SVEXPORTFORMAT>$$SysName:XML</SVEXPORTFORMAT>
                <SVFROMDATE>20240401</SVFROMDATE>
                <SVTODATE>20240430</SVTODATE>
            </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>
                        <SCROLLED>Vertical</SCROLLED>
                    </PART>
                    <PART NAME="Inventorylist Line Title">
                        <TOPLINES>Inventory Details</TOPLINES>
                        <REPEAT>Inventory Details:InventoryEntries</REPEAT>
                        <SCROLLED>Vertical</SCROLLED>
                    </PART>
                    <PART NAME="Allledgerlist Line Title">
                        <TOPLINES>Allledger Details</TOPLINES>
                        <REPEAT>Allledger Details:All LedgerEntries</REPEAT>
                        <SCROLLED>Vertical</SCROLLED>
                    </PART>
                    <PART NAME="Bankallocationslist Line Title">
                        <TOPLINES>Bankallocations Details</TOPLINES>
                        <REPEAT>Bankallocations Details:BANK ALLOCATIONS</REPEAT>
                        <SCROLLED>Vertical</SCROLLED>
                    </PART>
                    <PART NAME="Ratedetails Line Title">
                        <TOPLINES>Rate Details</TOPLINES>
                        <REPEAT>Rate Details:RATEDETAILS</REPEAT>
                        <SCROLLED>Vertical</SCROLLED>
                    </PART>
                    <LINE NAME="Daybook Details">
                        <RIGHTFIELDS>vchType,VoucherNumber,Date,VOUCHER REMOTEID,NARRATION,PartyGSTIN,Reference,ReferenceDate,V_PARTYNAME</RIGHTFIELDS>
                        <XMLTAG>Voucher</XMLTAG>
                        <EXPLODE>Ledgerlist Line Title</EXPLODE>
                        <EXPLODE>Inventorylist Line Title</EXPLODE>
                        <EXPLODE>Allledgerlist Line Title</EXPLODE>
                    </LINE>
                    <LINE NAME="Ledger Details">
                        <LEFTFIELDS>LedgerName,PARTYNAME,Amount</LEFTFIELDS>
                        <XMLTAG>LedgerList</XMLTAG>
                    </LINE>
                    <LINE NAME="Inventory Details">
                        <LEFTFIELDS>InvAmount</LEFTFIELDS>
                        <XMLTAG>InventoryList</XMLTAG>
                        <EXPLODE>Ratedetails Line Title</EXPLODE>
                    </LINE>
                    <LINE NAME="Rate Details">
                        <LEFTFIELDS>GSTRATEDUTYHEAD,GSTRATE</LEFTFIELDS>
                        <XMLTAG>Ratedetails</XMLTAG>
                    </LINE>
                    <LINE NAME="Allledger Details">
                        <LEFTFIELDS>BANKERSDATE</LEFTFIELDS>
                        <XMLTAG>ALLLEDGERENTRIES.LIST</XMLTAG>
                        <EXPLODE>Bankallocationslist Line Title</EXPLODE>
                    </LINE>
                    <LINE NAME="Bankallocations Details">
                        <LEFTFIELDS>BANKERSDATE</LEFTFIELDS>
                        <XMLTAG>BANKALLOCATIONS.LIST</XMLTAG>
                    </LINE>
                    <FIELD NAME="LedgerName">
                        <SET>$LedgerName</SET>
                    </FIELD>
                    <FIELD NAME="PARTYNAME">
                        <SET>$PARTYNAME</SET>
                    </FIELD>
                    <FIELD NAME="V_PARTYNAME">
                        <SET>$PARTYNAME</SET>
                    </FIELD>
                    <FIELD NAME="InvAmount">
                        <SET>$VATAssblValue</SET>
                        <USE>Amount Field</USE>
                    </FIELD>
                    <FIELD NAME="GSTRATEDUTYHEAD">
                        <SET>$GSTRATEDUTYHEAD</SET>
                    </FIELD>
                    <FIELD NAME="GSTRATE">
                        <SET>$GSTRATE</SET>
                    </FIELD>
                    <FIELD NAME="Date">
                        <SET>$$DDMMYYYYDateFormat:$Date:"-"</SET>
                    </FIELD>
                    <FIELD NAME="BANKERSDATE">
                        <SET>$$DDMMYYYYDateFormat:$BANKERSDATE:"-"</SET>
                    </FIELD>
                    <FIELD NAME="VoucherNumber">
                        <SET>$VoucherNumber</SET>
                    </FIELD>
                    <FIELD NAME="VOUCHER REMOTEID">
                        <SET>$GUID</SET>
                    </FIELD>
                    <FIELD NAME="Amount">
                        <SET>$Amount</SET>
                        <USE>Amount Field</USE>
                    </FIELD>
                    <FIELD NAME="NARRATION">
                        <SET>$NARRATION</SET>
                    </FIELD>
                    <FIELD NAME="PartyGSTIN">
                        <SET>$PartyGSTIN</SET>
                    </FIELD>
                    <FIELD NAME="Reference">
                        <SET>$Reference</SET>
                    </FIELD>
                    <FIELD NAME="ReferenceDate">
                        <SET>$ReferenceDate</SET>
                    </FIELD>
                    <COLLECTION NAME="GetLedgerCollAmt" ISMODIFY="No">
                        <TYPE>Vouchers:VoucherType</TYPE>
                        <CHILDOF>$$VchTypeSales</CHILDOF>
                        <FETCH>VoucherNumber,GUID,LedgerName,PARTYNAME,VoucherTypeName,Date,BANKERSDATE,NARRATION,PartyGSTIN,Reference,ReferenceDate,InvAmount,GSTRATE,GSTRATEDUTYHEAD,V_PARTYNAME</FETCH>
                    </COLLECTION>
                </TDLMESSAGE>
            </TDL>
        </DESC>
    </BODY>
</ENVELOPE>
     
    Researcher, Jan 8, 2025
    #1


Share This Page