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

Related Posts	Відповіді	Переглядів
How to add new field into pivot table? pivot v14 account.invoice.report	2 жовт. 23	8572
new sales analysis pivot report odoo 10 sales analysis pivot	0 вер. 20	4904
Can we redefine these filters on pivot table? Вирішено graph table pivot	2 лют. 17	6801
Would you have a trick to remove the total column on pivot table? hide total table pivot	6 груд. 18	15570
Can we use pivot table on the frontend portal? Вирішено reporting portal table pivot	1 квіт. 24	4168

Це запитання позначене

Enjoying the discussion? Don't just read, join in!