This question has been flagged
2 Replies
7121 Views

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
Discard
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
Discard
Author 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
Discard