Is their any way to fetch master data from Tally Prime ranging between ALTERID's through XML Request

448 Views Asked by At

Is there any way to fetch the master data like Ledgers from tally ranging from xyz AlterId to abc AlterId or the Ledgers whose alterId is greater then xyz AlterId?

1

There are 1 best solutions below

0
On BEST ANSWER

Convert Exactly what you required into a TDL Formula and Filter Masters Based on That Formulae

$ALTERID > '100'

> is escaped text of >

If you want filter between Range(Ex:100 to 120) then

$ALTERID > '100' AND $ALTERID < '120'

If you go any problem then try removing quotes for $ALTERID > 100

Final XML will look like

<ENVELOPE>
    <HEADER>
        <VERSION>1</VERSION>
        <TALLYREQUEST>Export</TALLYREQUEST>
        <TYPE>Collection</TYPE>
        <ID>CustMasterColl</ID>
    </HEADER>
    <BODY>
        <DESC>
            <STATICVARIABLES>
                <SVEXPORTFORMAT>$$SysName:XML</SVEXPORTFORMAT>
                
            </STATICVARIABLES>
            <TDL>
                <TDLMESSAGE>
                    <COLLECTION ISMODIFY="No" ISFIXED="No" ISINITIALIZE="No" ISOPTION="No" ISINTERNAL="No" NAME="CustMasterColl">
  <!-- * Tally Masters Types like Ledger, Group, StockItem ..etc., -->
                        <TYPE>Ledger</TYPE>
                        <FILTERS>Masterfilter</FILTERS>
                    </COLLECTION>
<!-- * IF you want Between then $ALTERID &gt; '100' AND $ALTERID &lt; '120' -->
                    <SYSTEM TYPE="Formulae" NAME="Masterfilter">$ALTERID &gt; '100'</SYSTEM>
                </TDLMESSAGE>
            </TDL>
        </DESC>
    </BODY>
</ENVELOPE>