Odoo Help

Welcome!

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

0

How to print General Ledger report in Excel

By
Shawn Varghese
on 2/5/15, 4:17 AM 2,158 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?

Shawn Varghese
on 2/7/15, 2:29 AM

I mean in Excel

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

Bruno JOLIVEAU
on 2/7/15, 10:41 AM

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

Shawn Varghese
on 2/8/15, 12:33 PM
0
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


0
Emad Jaddou
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?


Your Answer

Please try to give a substantial answer. If you wanted to comment on the question or answer, just use the commenting tool. Please remember that you can always revise your answers - no need to answer the same question twice. Also, please don't forget to vote - it really helps to select the best questions and answers!

About This Community

This community is for professionals and enthusiasts of our products and services. Read Guidelines

Question tools

2 follower(s)

Stats

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