Skip to Content
Menu
This question has been flagged
2 Replies
8605 Rodiniai

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

Portretas
Atmesti
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>
Portretas
Atmesti
Autorius 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>


Portretas
Atmesti
Related Posts Replies Rodiniai Veikla
1
rugs. 25
897
1
birž. 23
3848
2
vas. 23
2187
2
birž. 16
6108
0
birž. 15
4237