1. CLICK HERE TO JOIN WHATSAPP CHANNEL FOR TDL PROGRAMS

How to fetch all entered vouchers (DayBook) through SQL Query from Tally?

Discussion in 'Tally Integration' started by Prateek Mantri, Oct 10, 2013.

    
  1. Prateek Mantri

    Prateek Mantri New Member


    I want to retrieve all entered vouchers through SQL Query.
    I tried to select all records from following:
    1. Vouchers
    2. Ledger
    3. Ledger Vouchers

    But it returns list of ledgers or vouchers without party names and other details.
    Kindly help
     
    Prateek Mantri, Oct 10, 2013
    #1


  2. admin

    admin Administrator Staff Member


    use Table name as : company vouhers

    select * from companyvouchers
     
    admin, Oct 17, 2013
    #2


  3. Prateek Mantri

    Prateek Mantri New Member


    Thanks, It displayed vouchers but still I cannot fetch amount, rate, quantity and other details of such vouchers
    Also, I want to filter results on date and amounts.
     
    Prateek Mantri, Oct 19, 2013
    #3


  4. ramdasmji

    ramdasmji New Member


    HOW TO CONNECT TALLY AND VISUAL BASIC.
    HOPE AN EARLY REPLY FROM YOU

    THANKS IN ADVANCE

    RAMDAS
    RAMDASMJI@GMAIL.COM
     
    ramdasmji, Oct 21, 2013
    #4


  5. himanshu

    himanshu New Member


    can anyone tell me how to fetch sales register and purchase register bill in columnar format with tdl and sql quary...
    thanks in advance..
    my email id is goku.hp@gmail.com
     
    himanshu, May 10, 2016
    #5


Share This Page