I changed my code to below and now it works for target 1, however target 2 i am still getting only the top row. [Collection : Reccoll] Source...
Hello, can you guide me on how i can create a function and use it in a collection as you suggested in the post? Thanks
Hey Samiksha, Thanks for your response. Can you please elaborate? I am not following. I am very new to this
@Amit Kamdar Still doesn't seem to work. See attached screenshot. Is there a way to see the bill allocations table alone?
@Amit Kamdar Any idea how i can get this? My guess is bill reference details are coming from pending bills. How do we fetch that?
Hey Nagaraj, Since i have vouchers with multiple entries of the same stock item, i modified the query as below to get all the stock item names....
Many thanks, this works! Can you please look at the bill reference number not showing issue as well in the other post...
I tried this as well. Still doesn't work Compute:BillRef :$.Ledgerentries[1].BILLALLOCATIONS[$$Line].Name Compute: BillType:...
Thanks for your reply! I tried the below code but still getting the same value repeated as in screenshot shared above [Collection : Reccoll]...
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...
It is the same code as in below post http://tdlexpert.com/index.php?threads/odbc-get-all-ledger-details.9967/#post-40559
Total is fine. I was referring to the bill reference numbers. It is showing the value as of the first entry for all the entries. MNF/MH/2021/0279...
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...
Thanks a lot Sudhir, it works now! However bill ref is still not showing the correct value as attached. Any way to fix that?
I am trying to get all ledger details through ODBC. In few cases, a voucher has multiple ledger entries with the same name. Whats happening is...
Separate names with a comma.
