Skip ke Konten
Pertanyaan ini telah diberikan tanda
accountingexportreportxls
2 Replies
8371 Tampilan
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
Buang
Avatar
Pawan Kumar Sharma
Jawaban Terbai

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
Buang
Avatar
Kinah Guinto
Penulis Jawaban Terbai

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
Buang
Post Terkait Replies Tampilan Aktivitas
What types of subformulas are there in a financial report?
accounting report
Avatar
0
Jul 25
579
How to export accounting data
accounting export
Avatar
Avatar
1
Jun 23
3324
Accounting reports related query
accounting report
Avatar
Avatar
Avatar
2
Feb 23
1954
How to create a new Pdf report In Accounting Module ?
accounting report
Avatar
2
Jun 16
5847
How to hide an item on a report?
accounting report
Avatar
0
Jun 15
3927