Skip to Content
This question has been flagged
accountingexportreportxls
2 Replies
8429 Zobrazenia
Avatar
Kinah Guinto

Hi,

I'm still new in odoo 10.  I want to export a report in Sale/Purchase Journal. My problem is,  the report is not a list view form. I don't know how to generate a report in Sale/Purchase Journal. Can you teach me how to do this one? 

Thank you

Avatar
Zrušiť
Avatar
Pawan Kumar Sharma
Best Answer

Hello @Kinah,

You can generate XLS Report by export from Action Menu. Where in 'Export Formats' you can select excel and then export file.

Or you can also generate own XLS Report by following Example.

I think it will helpful for you.

<data><openerp><report
    id="partner_xlsx"
    model="hr_timesheet_sheet.sheet"string="Timesheet Report"
    report_type="xlsx"
    name="hr_timesheet_sheet.sheet.xlsx"
    file="hr_timesheet_sheet.sheet.xlsx"
    attachment_use="False"/></openerp></data>
Avatar
Zrušiť
Avatar
Kinah Guinto
Autor Best Answer

Here's my code for the custom button of my export in Sales/Journal Purchase in PDF Reports:

 <record id="account_common_report_view_journal" model="ir.ui.view">      

      <field name="name">Common Report</field>     

      <field name="model">account.print.journal</field> 

      <field name="inherit_id" ref="account.account_common_report_view" /> 

      <field name="arch" type="xml">   

           <xpath expr="//footer/button[@name='check_report']" position="after"> 

               <button name="export_to_xls" string="Export to .xls" type="object" class="oe_highlight"/>      

          </xpath>      

      </field>  

  </record>


Avatar
Zrušiť
Related Posts Replies Zobrazenia Aktivita
What types of subformulas are there in a financial report?
accounting report
Avatar
0
júl 25
676
How to export accounting data
accounting export
Avatar
Avatar
1
jún 23
3498
Accounting reports related query
accounting report
Avatar
Avatar
Avatar
2
feb 23
2044
How to create a new Pdf report In Accounting Module ?
accounting report
Avatar
2
jún 16
5937
How to hide an item on a report?
accounting report
Avatar
0
jún 15
4016