I am pulling all ledger data through ODBC. Presently, i am selecting each company in tally and running the query in excel. Is there a way to pull for all the companies at once?
It is the same code as in below post http://tdlexpert.com/index.php?threads/odbc-get-all-ledger-details.9967/#post-40559
While using ODBC for data extraction, based on my understanding. company and period needs to be set in Tally before running the query in excel. Is there a way to set the period / company names in the SQL query itself like how we do in S4 Hana?
[Collection: CompanyCollection] Type : Company Fetch : Name [Collection : RTSAllVouchers2] Type: Voucher [Collection : Reccoll] Source Collection: RTSAllVouchers2 Walk : LedgerEntries Fetch: date,vouchertypename,Vouchernumber,PartyLedgerName,PartyName Compute:LedgerName:$LedgerName Compute:BillRef :$.Ledgerentries[1].BILLALLOCATIONS[1].Name Compute: BillType: $.Ledgerentries[1].BILLALLOCATIONS[1].BillType Compute:Amount:$Amount Compute :CompName:$$LoopCollObj:$Name [Collection: ConsollReccoll] Collection :Reccoll:CompanyCollection IsODBCTable: Yes
Many thanks, this works! Can you please look at the bill reference number not showing issue as well in the other post http://tdlexpert.com/index.php?threads/odbc-get-all-ledger-details.9967/#post-40559