Odoo Help

0

How to print General Ledger report in Excel

By
Shawn Varghese
on 2/5/15, 4:17 AM 3,020 views

I know this question has been raised many, many times before, and I have gone through all the previous posts, but I still don't understand what exactly has to be done. I have a requirement to Print reports like the 'General Ledger' report in Excel. That is to say, when I press the 'Print' button in the Wizard pop-up, it should create an Excel spreadsheet report.

This is what I have gathered so far:

There are different reporting engines for Excel report creation:

1) XLS report

2) Jasper Reports

3) Aeroo Reports

I have also seen posts which give detailed instructions for the installations for these.

I installed the xls report module and a sample account_move_line report and saw the effect. However, in that case, the List View was already available on the browser and that was being exported into Excel. However, in cases like the General Ledger report, it is directly created in a separate file.

Do any of these reporting engines perform this task? I would be very grateful for any direction and guidance I can get for this. I am using OpenERP 7.

Thanks

4
Bruno JOLIVEAU
On 2/6/15, 2:18 PM

Hi,

Maybe you can try this

https://www.odoo.com/apps/modules/7.0/account_financial_report_webkit_xls/

Thanks Bruno ! This is very helpful. Is there any module available to print Balance Sheets and Profit/Loss reports?

ePillars Systems LLC, Shawn Varghese
on 2/7/15, 2:29 AM

I mean in Excel

ePillars Systems LLC, Shawn Varghese
on 2/7/15, 4:15 AM

See in the same repo fort balance sheets. Let you to verify for profit and loss reports, eventually share what you'll find

Savoir-faire Linux, Bruno JOLIVEAU
on 2/7/15, 10:41 AM

Yup I checked the repo... but these 2 reports have not been created in xls.

ePillars Systems LLC, Shawn Varghese
on 2/8/15, 12:33 PM
0
Emad Jaddo
On 4/9/15, 1:58 PM

I am also interested in a way to export Profit & Lost and Balance Sheet reports.


Is there any aeroo template available?


-1
Mustufa Rangwala
On 11/7/16, 8:49 AM

Hello,

We have this apps https://apps.odoo.com/apps/modules/10.0/base_financial_report_excel/ (PAID), if you would like to see. (Also available in v9)

Thank you,

Probuse Consulting Service Pvt Ltd

www.probuse.com


About This Community

This platform is for beginners and experts willing to share their Odoo knowledge. It's not a forum to discuss ideas, but a knowledge base of questions and their answers.

Register

Odoo Training Center

Access to our E-learning platform and experience all Odoo Apps through learning videos, exercises and Quizz.

Test it now

Question tools

2 follower(s)

Stats

Asked: 2/5/15, 4:17 AM
Seen: 3020 times
Last updated: 11/7/16, 8:49 AM