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
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
[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
I tried to run "select * from MyLedgerVouchers", but it does not return anything with following collection. Please help if I am doing anything wrong.