Add field to pivot table

Question

I'm trying to add a field to the pivot table "account.invoice.report".

Here's my code:
category = fields.Char( string = 'Category' , compute = '_compute_category' ,  store = True ,  readonly = True )
@api.multi      @api.depends ( 'partner_id' )      def   _compute_category ( self ):
my_code
I can see the new field on Invoices Analysis view but when I click on it I got an error saying that the field does not exist. When I look in the database, the field does not exist.
I tried to add it also in

Nesrine Essaies · Answer

hello,
you can follow this example:
class  AccountInvoiceReport(models.Model):
_inherit =  'account.invoice.report'
team_id = fields.Many2one(  'crm.team' ,  string  =  'Sales Team'  )
def  _select  (  self  ):
return  super  (AccountInvoiceReport  ,  self  )._select() +  ", sub.team_id as team_id"
def  _sub_select  (  self  ):
return  super  (AccountInvoiceReport  ,  self  )._sub_select() +  ", ai.team_id as team_id"
def  _group_by  (  self  ):
return  super  (AccountInvoiceReport  ,  self  )._

Eman Abdulmalik · Answer

Hello Wided,
In order to add a field to account.invoice.report you have to add your field as you already did and you also have to inherit the methods _sub_select and _group_by and modify with your fields in those methods.

I hope this helps

Post Terkait	Replies	Tampilan
How to add new field into pivot table? pivot v14 account.invoice.report	2 Okt 23	8544
new sales analysis pivot report odoo 10 sales analysis pivot	0 Sep 20	4876
Can we redefine these filters on pivot table? Diselesaikan graph table pivot	2 Feb 17	6782
Would you have a trick to remove the total column on pivot table? hide total table pivot	6 Des 18	15532
Can we use pivot table on the frontend portal? Diselesaikan reporting portal table pivot	1 Apr 24	4137

Pertanyaan ini telah diberikan tanda

Menikmati diskusi? Jangan hanya membaca, ikuti!