1. CLICK HERE TO JOIN WHATSAPP CHANNEL FOR TDL PROGRAMS

Needs to retrieve sales order details using xml request to Tally erp9

Discussion in 'Tally Integration' started by Ajay singh, Mar 11, 2013.

    
  1. Ajay singh

    Ajay singh New Member


    Hi all,
    I have to retrieve sales order invoice details from the tally using xml request for the given data range.
    so please help me.
    Thanks and regards
    Ajay singh
     
    Ajay singh, Mar 11, 2013
    #1


  2. admin

    admin Administrator Staff Member



    XML File:
    Code:
    <ENVELOPE>
<HEADER>
<VERSION>1</VERSION>
<TALLYREQUEST>Export</TALLYREQUEST>
<TYPE>Data</TYPE>
<ID>Sales Orders Book</ID>
</HEADER>
<BODY>
<DESC>
<STATICVARIABLES>
<EXPLODEFLAG>Yes</EXPLODEFLAG>
<SVEXPORTFORMAT>$$SysName:XML</SVEXPORTFORMAT>
<SVFROMDATE>01/04/2006</SVFROMDATE>
<SVTODATE>31/03/2013</SVTODATE>
</STATICVARIABLES>
<TDL>
<TDLMESSAGE>
<REPORT NAME="Sales Orders Book">
</REPORT>
</TDLMESSAGE>
</TDL>
</DESC>
</BODY>
</ENVELOPE>
    TDL File:

    Code:
    [#Report: Sales Orders Book]
      Form    : Day Book
     
    admin, Mar 12, 2013
    #2
    Chittaranjan Tripathy, kpstup and Ajay singh like this.


  3. Ajay singh

    Ajay singh New Member


    Thanks sir,
    One more please,
    How can we retrieve sales order by passing Invoice Number?
    I have to make a aspx page there the user will provide the invoice number and system should get the invoice details from the tally based on the invoice number.
    I mean by passing the invoice number to tally, tally should fetch the details of that particular order.
    Please help sir,
    Thanks and Regards
    Ajay singh
     
    Ajay singh, Mar 13, 2013
    #3
    Chittaranjan Tripathy likes this.


  4. admin

    admin Administrator Staff Member


    Apply Filter in the collection and Pass the voucher number as Variable in the XML.. use this variable value for filteration
     
    admin, Mar 15, 2013
    #4


  5. Ajay singh

    Ajay singh New Member


    Hi Sir,
    Right now I don't know how to apply filter on the collection
    Please provide me filter program so that accordingly i will modify the voucher collection.
    It will be very heplfull for me if you will provide me the voucher collection filtration program.
    Thanks and Regards
    Ajay singh
     
    Ajay singh, Mar 15, 2013
    #5


  6. Chittaranjan Tripathy

    Chittaranjan Tripathy New Member


    Good Afternoon Sir,
    How could I Fetch(export) Ledger Vouchers for a specific
    Ledger using XML ?


    Thanks & Regards
    Chittaranjan Tripathy
     
    Chittaranjan Tripathy, Dec 12, 2014
    #6


  7. ram rockz

    ram rockz New Member


    I need to get the sales order details such as: order no, date, quantity, rate, amount and grand total.

    <ENVELOPE>
    <HEADER>
    <VERSION>1</VERSION>
    <TALLYREQUEST>EXPORT</TALLYREQUEST>
    <TYPE>DATA</TYPE>
    <ID>Voucher Register</ID>
    </HEADER>
    <BODY>
    <DESC>
    <STATICVARIABLES>
    <VoucherTypeName>Sales Order</VoucherTypeName>
    <SVEXPORTFORMAT>$$SysName:XML</SVEXPORTFORMAT>
    </STATICVARIABLES>
    </DESC>
    </BODY>
    </ENVELOPE>
    I have used this one but it's returning all that data except order no and grand total. Plus this code also returns a large amount unwanted data along with it.
    How can I fetch order no, date, quantity, rate, amount and grand total only from the sales order with out having any unwanted data?
     
    ram rockz, Apr 14, 2017
    #7


Share This Page