1. CLICK HERE TO JOIN WHATSAPP CHANNEL FOR TDL PROGRAMS

How to fetch all the sales/purchase vouchers from a company ?

Discussion in 'Tally Integration' started by Noor Hussain Ladkhan, Oct 3, 2012.

    
  1. Noor Hussain Ladkhan

    Noor Hussain Ladkhan New Member


    Dear Experts,

    Please let me know how to fetch all the sales/purchase vouchers from a company for a particular day or between two dates. Please let me know which report I have to use for it.

    Thanks and regards,
    Noor Hussain
     
    Noor Hussain Ladkhan, Oct 3, 2012
    #1


  2. admin

    admin Administrator Staff Member


    [Report: Sales Register]

    [Report: Purchase Register]

    For period, pass dates via SVFromdate and SVToDate variables
     
    admin, Oct 3, 2012
    #2


  3. Noor Hussain Ladkhan

    Noor Hussain Ladkhan New Member


    Thanks a lot for your quick response. Please could you provide a sample xml about how to use the above mentioned features and get the purchase and sales register details.

    Thanks,
    Noor
     
    Noor Hussain Ladkhan, Oct 3, 2012
    #3


  4. Noor Hussain Ladkhan

    Noor Hussain Ladkhan New Member


    As per your suggestions i used the below code for fetching Purchase Vouchers.
    Code:
          Dim StrRequestXML As String = _
"<ENVELOPE>" & _
"  <HEADER>" & _
"    <TALLYREQUEST>Export Data</TALLYREQUEST>" & _
"  </HEADER>" & _
"  <BODY>" & _
"    <EXPORTDATA>" & _
"      <REQUESTDESC>" & _
"        <REPORTNAME>Purchase Register</REPORTNAME>" & _
"        <STATICVARIABLES>" & _
"          <SVEXPORTFORMAT>$$SysName:XML</SVEXPORTFORMAT>" & _
"<SVFROMDATE>01/09/2012</SVFROMDATE>" & _
        "<SVTODATE>02/09/2012</SVTODATE>" & _
"        </STATICVARIABLES>" & _
"    </REQUESTDESC>" & _
"    </EXPORTDATA>" & _
"  </BODY>" & _
"</ENVELOPE>"
    Its response is as follows:
    Code:
    <ENVELOPE>
<DSPPERIOD>September</DSPPERIOD>
<DSPACCINFO>  <DSPCLDRAMT>  <DSPCLDRAMTA>-2062.93</DSPCLDRAMTA>
</DSPCLDRAMT>
  <DSPCLCRAMT>  <DSPCLCRAMTA></DSPCLCRAMTA>
</DSPCLCRAMT>
</DSPACCINFO>
</ENVELOPE>
    But I want all the details of the voucher like voucher no, party name, itemname etc. Please let me know how can I get it. What report I have to use for it.

    Thanks and regards,
    Noor Hussain
     
    Noor Hussain Ladkhan, Oct 4, 2012
    #4


  5. admin

    admin Administrator Staff Member


    You can write your own reports which contains the desired fields expected by you.

    you can make a call to same report via soap
     
    admin, Oct 6, 2012
    #5


  6. Noor Hussain Ladkhan

    Noor Hussain Ladkhan New Member


    Hi,

    Thanks for your quick response. Can you please provide me with a sample user created report or where can I find it.

    Thanks and regards,
    Noor Hussain
     
    Noor Hussain Ladkhan, Oct 8, 2012
    #6


  7. admin

    admin Administrator Staff Member


    [Report: MY Report]
    Use: Day Book

    Dim StrRequestXML As String = _
    "<ENVELOPE>" & _
    " <HEADER>" & _
    " <TALLYREQUEST>Export Data</TALLYREQUEST>" & _
    " </HEADER>" & _
    " <BODY>" & _
    " <EXPORTDATA>" & _
    " <REQUESTDESC>" & _
    " <REPORTNAME>MY Report</REPORTNAME>" & _
    " <STATICVARIABLES>" & _
    " <SVEXPORTFORMAT>$$SysName:XML</SVEXPORTFORMAT>" & _
    "<SVFROMDATE>01/09/2012</SVFROMDATE>" & _
    "<SVTODATE>02/09/2012</SVTODATE>" & _
    " </STATICVARIABLES>" & _
    " </REQUESTDESC>" & _
    " </EXPORTDATA>" & _
    " </BODY>" & _
    "</ENVELOPE>"
     
    admin, Oct 8, 2012
    #7


  8. Ajay singh

    Ajay singh New Member


    Hello,
    Can we also specify time there along with data?
    for an example like:- 01/09/2012 2:00AM to 02/09/2012 12:00AM.
    Please reply if any body knows.
    Thanks and Regards
    Ajay singh
     
    Ajay singh, Oct 18, 2012
    #8


  9. admin

    admin Administrator Staff Member


    No.. You can not send time along with date
     
    admin, Nov 5, 2012
    #9


Share This Page