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