Transactions to external application

Hi Experts,

I want to extract all transactions (both debit and credit) of specific ledger or all ledgers using ODBC in external application. i.e. query will run from external application not calculator panel.

Ledger Name and date range (From date, To date) will be passed as parameter through the external application.

Is it possible to extract data for a specific ledger and for all ledgers.

Required fields in output are Date, Ledger name(debit credit both), Dr Amount, Cr Amount.

Need your expert guidance.

Thanks.

 

1. Learn Tally XML Format
2. Watch Software Codecs ( YouTube Channel )

Hope This Helps

 

Thanks for support,
Can you please help me to use ODBC to get the output

 

Start Tally on localhost
Steps:
1. Press F11
2. Go to Advance Configuration
3. Use tally as both ( server & client )

Now, Install ODBC Ansi Driver 8.0
Open Excel
Steps:
Go to Data tab
Use Microsoft query to fetch data from tally

Rules:
Tally must be open in background
At least one company should be open

 

Thanks for valuable support

 

For Data exchange/ transfer it is adviceable to use XML request, Tally will support both ODBC and XML request, for good practice
click to view various type of business integration xml request formats