Want to extract monthly summary

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

 

Sir Create Your Collection Using TDL and Add this to your Code

Is ODBC Table: Yes

 

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.

 

I think ODBC will give you data only Later you can use it to create report Accordingly

 

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