Hi Experts, I want to generate an ODBC TABLE that will have following fields. Month, LedgerName, DrTotal (i.e. sum of all Dr transactions of a ledger for the month), CrTotal (Sum of credit transactions of a ledger for the month) e.g. Assume Mr. A ledger has 3 dr. transactions (20000,50000,30000) and 2 credit transactions (25000,55000) for the month of May then output will have following records Month Ledger DrTotal CrTotal May Mr. A 100000 80000 I am working on a third party application so I want to access this table through odbc connection. Required your expert help and support Thank you
Thanks sir for your quick response, I never came across to TDL before my current project so I am not able to write collection for required output. Can you please help me in this. I am trying to learn these concepts online and this community is really very helpful for experts and new learners like me as well. Thanks.
Hi, This monthly summary report was generated through tally and we can export it to excel, but I want to know that is it possible to extract this report (for all months) externally i.e using ODBC (User don't want to export it from tally but want to extract it using query) if yes then please help me to get the solution. Thanks.
Thank you sir for response, You are right sir, I need help in extracting data only, creating report from data is not an issue Thanks