1. CLICK HERE TO JOIN WHATSAPP CHANNEL FOR TDL PROGRAMS

How to filter ledger collection based on date range?

Discussion in 'Tally Integration' started by Azad, Nov 11, 2020.

    
Tags:
  1. Azad

    Azad New Member


    Hello friends,

    I am unable to filter the ledger collection based on SVFromDate and SVToDate using the following date. Please help

    Code:
    <ENVELOPE>
   <HEADER>
      <VERSION>1</VERSION>
      <TALLYREQUEST>EXPORT</TALLYREQUEST>
      <TYPE>COLLECTION</TYPE>
      <ID>TTLedger</ID>
   </HEADER>
   <BODY>
      <DESC>
         <STATICVARIABLES>
            <EXPLODEFLAG>Yes</EXPLODEFLAG>
            <SVEXPORTFORMAT>$$SysName:XML</SVEXPORTFORMAT>
            <SVFROMDATE>01/04/2019</SVFROMDATE>
            <SVTODATE>31/03/2020</SVTODATE>
         </STATICVARIABLES>
         <TDL>
            <TDLMESSAGE>
               <COLLECTION NAME="TTLedger">
                  <TYPE>Ledger</TYPE>
                  <FETCH>Name, Parent, ClosingBalance</FETCH>
               </COLLECTION>
            </TDLMESSAGE>
         </TDL>
      </DESC>
   </BODY>
</ENVELOPE>
    Regards,
    Azad
     
    Azad, Nov 11, 2020
    #1


  2. Amit Kamdar

    Amit Kamdar Administrator Staff Member


    Put Date in yyyymmdd format........
     
    Amit Kamdar, Nov 11, 2020
    #2


  3. Azad

    Azad New Member


    Its still not working Sir. Its showing data till date
     
    Azad, Nov 11, 2020
    #3


  4. Azad

    Azad New Member


    Hello Sir, Now its working.

    Is it possible to include the very primary group (not the parent) in the list?
     
    Azad, Nov 11, 2020
    #4


  5. Azad

    Azad New Member


    Never mind. Got it. Its $GrandParent
     
    Azad, Nov 11, 2020
    #5


Share This Page