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 in Others by Kithuzzz
• 20,660 points
40 views

1 answer to this question.

0 votes

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 by narikkadan
• 37,660 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 in Others by gaurav
• 22,040 points
307 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 in Others by Edureka
• 13,640 points
6,186 views
0 votes
0 answers

How to handle large http response data from observer in Angular application to avoid browser crash?

Suppose we have a angular application which ...READ MORE

Apr 19, 2019 in Others by Hemant Gajbe
1,764 views
0 votes
1 answer

How to open .xlsx files in MS Excel from VS Code?

Hello, to open xlxs files, or files ...READ MORE

answered Feb 17 in Others by gaurav
• 22,040 points
256 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 in Others by narikkadan
• 37,660 points
126 views
0 votes
1 answer

Sending excel data to Tally

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

answered Nov 19 in Others by narikkadan
• 37,660 points
28 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,720 points
452 views
0 votes
1 answer
0 votes
1 answer

Unable to import data in excel from another website using VB code

Replace : Set ieTable = ieDoc.all.Item("report-table") With: Set ieTable = ...READ MORE

answered Sep 21 in Others by narikkadan
• 37,660 points
73 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