ODBC-Get all transaction of Ledger

Discussion in 'Tally Integration' started by Sanket Patel, Aug 8, 2019.

    
Tags:
  1. Sanket Patel

    Sanket Patel New Member


    Hi
    Is there any query with TDL which can show all dr/cr transactions for particular Ledger?
    e.g
    show all entries of ABC A/c (which includes Sales, Receipt, Journal, Payment etc) with Voucher Type, Number and date.

    Thanks
     


  2. Sanket Patel

    Sanket Patel New Member


    This is needed because i want data in excel in format as said above withour doing manual export process from tally every time.
    Please help.

    Thanks
     


  3. Devendra_Rawat

    Devendra_Rawat Well-Known Member


    [Collection : MyLedgerVouchers]
    Type : Vouchers : Ledger
    Child Of : ##MyLedgerName

    Compute : myleddate : $Date
    Compute : myledNo : $VoucherNumber
    Compute : myledAmount: $Amount


    .... like this do it for all required fields

    Is Odbc Table : Yes



    Now collection becomes available in ODBC

    you can access it from ODBC query using any language
     


  4. Sanket Patel

    Sanket Patel New Member


    I tried to run "select * from MyLedgerVouchers", but it does not return anything with following collection.
    Please help if I am doing anything wrong.


     


Share This Page