How to extract Bills receivable data to excel from tally by ODBC

0 votes

I am new to extracting data with ODBC Tally ERP 9.0. I researched and got some help with Extracting Day Books / Transaction Data from Tally using ODBC Although this solution helps in some way it doesn't fully solve the problem. I want to get data in this format Date Party's Ledger Name Voucher No Amount. 

Nov 12, 2022 in Others by Kithuzzz
• 38,010 points
876 views

1 answer to this question.

+1 vote

To obtain the company's receivable bills, you must create a collection as shown below.

[Collection: CMPRecevables]

    Type            : Bills
    Is ODBC Table   : YEs
    Filter          : IsReceivable
    Fetch           : Name, BillDate, Parent, ClosingBalance    

Connect this table using odbc and use below query

select $Name, $BillDate, $Parent, $ClosingBalance from CMPRecevables
answered Nov 12, 2022 by narikkadan
• 63,700 points

Related Questions In Others

0 votes
1 answer

How to import data from a HTML table on a website to excel?

Hello  To import any HTML file in excel there ...READ MORE

answered Feb 10, 2022 in Others by gaurav
• 23,260 points
6,730 views
0 votes
1 answer

How to convert data from txt files to Excel files using python

Hi , there are few steps to ...READ MORE

answered Feb 16, 2022 in Others by Edureka
• 13,670 points
13,479 views
0 votes
1 answer

How to scrape the specific text from kworb and extract it as an excel file?

The best practice to scrape tables is ...READ MORE

answered Feb 18, 2023 in Others by narikkadan
• 63,700 points
471 views
0 votes
1 answer

How to automatically get a specified range of data from Excel to XML in VBA

Range method works, always identify the sheet ...READ MORE

answered Mar 18, 2023 in Others by narikkadan
• 63,700 points
580 views
0 votes
1 answer
0 votes
1 answer

Excel to IBM DB2 Connection

Try using the IBM DB2 for I ...READ MORE

answered Sep 29, 2022 in Others by narikkadan
• 63,700 points
1,384 views
0 votes
1 answer

Sending excel data to Tally

You can use Requests to send the ...READ MORE

answered Nov 19, 2022 in Others by narikkadan
• 63,700 points
670 views
0 votes
1 answer

Retrieve epay.info Balance with VBA and Excel

This code should log you in, provided ...READ MORE

answered Sep 5, 2018 in Blockchain by digger
• 26,740 points
956 views
0 votes
1 answer

How can I convert excel to PDF by Libreoffice and keep all format from excel file?

"Times New Roman" typeface does not have ...READ MORE

answered Oct 3, 2022 in Others by narikkadan
• 63,700 points
1,362 views
0 votes
1 answer

How can I preserve the format while exporting data from excel to evernote

The contents for an Evernote note are ...READ MORE

answered Jan 5, 2023 in Others by narikkadan
• 63,700 points
423 views
webinar REGISTER FOR FREE WEBINAR X
REGISTER NOW
webinar_success Thank you for registering Join Edureka Meetup community for 100+ Free Webinars each month JOIN MEETUP GROUP