Satwaki Sarkar's Recent Activity

  1. Satwaki Sarkar attached a file to the thread ODBC get all ledger details.

    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]...

    Target1.png Target2.png Scenario1.png Scenario2.png Scenario2 code2.png Mar 27, 2021
  2. Satwaki Sarkar left a message on Samiksha's profile.

    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

    Mar 25, 2021
  3. Satwaki Sarkar liked Samiksha's post in the thread ODBC get all ledger details.

    Make a Function to collect the Values.......... Then compute the same in your collection.

    Mar 25, 2021
  4. Satwaki Sarkar replied to the thread ODBC get all ledger details.

    Hey Samiksha, Thanks for your response. Can you please elaborate? I am not following. I am very new to this

    Mar 25, 2021
  5. Satwaki Sarkar attached a file to the thread ODBC get all ledger details.

    @Amit Kamdar Still doesn't seem to work. See attached screenshot. Is there a way to see the bill allocations table alone?

    excel_screenshot4.png Mar 25, 2021
  6. Satwaki Sarkar replied to the thread ODBC get all ledger details.

    @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?

    Mar 24, 2021
  7. Satwaki Sarkar liked Sudhir83411's post in the thread ODBC - Export Vouchers in Excel.

    hi all Its not working i am getting only first line of item of the voucher

    Mar 24, 2021
  8. Satwaki Sarkar replied to the thread how to export invoices from tally using odbc.

    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...

    Mar 24, 2021
  9. Satwaki Sarkar replied to the thread ODBC multiple company extract data.

    Many thanks, this works! Can you please look at the bill reference number not showing issue as well in the other post...

    Mar 23, 2021
  10. Satwaki Sarkar liked Sudhir83411's post in the thread ODBC multiple company extract data.

    [Collection: CompanyCollection] Type : Company Fetch : Name [Collection : RTSAllVouchers2] Type: Voucher [Collection : Reccoll]...

    Mar 23, 2021
  11. Satwaki Sarkar replied to the thread ODBC get all ledger details.

    I tried this as well. Still doesn't work Compute:BillRef :$.Ledgerentries[1].BILLALLOCATIONS[$$Line].Name Compute: BillType:...

    Mar 23, 2021
  12. Satwaki Sarkar replied to the thread ODBC get all ledger details.

    Thanks for your reply! I tried the below code but still getting the same value repeated as in screenshot shared above [Collection :...

    Mar 23, 2021
  13. Satwaki Sarkar replied to the thread ODBC multiple company extract data.

    While using ODBC for data extraction, based on my understanding. company and period needs to be set in Tally before running the query in...

    Mar 23, 2021
  14. Satwaki Sarkar replied to the thread ODBC multiple company extract data.

    It is the same code as in below post http://tdlexpert.com/index.php?threads/odbc-get-all-ledger-details.9967/#post-40559

    Mar 22, 2021