Se rendre au contenu
Cette question a été signalée
analysistablepivotInvoiceaccount.invoice.report
2 Réponses
12309 Vues
Avatar
Wided Kefi

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 "account.invoice" but still the field is not added in the database.

Avatar
Ignorer
Avatar
Nesrine Essaies
Meilleure réponse 
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)._group_by() + ", ai.team_id"
Avatar
Ignorer
Avatar
Eman Abdulmalik
Meilleure réponse

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

Avatar
Ignorer
Publications associées Réponses Vues Activité
How to add new field into pivot table?
pivot v14 account.invoice.report
Avatar
Avatar
Avatar
2
oct. 23
8538
new sales analysis pivot report odoo 10
sales analysis pivot
Avatar
0
sept. 20
4866
Can we redefine these filters on pivot table? Résolu
graph table pivot
Avatar
Avatar
2
févr. 17
6780
Would you have a trick to remove the total column on pivot table?
hide total table pivot
Avatar
Avatar
Avatar
6
déc. 18
15525
Can we use pivot table on the frontend portal? Résolu
reporting portal table pivot
Avatar
1
avr. 24
4132