Skip to Content
Menu
This question has been flagged

I'm trying to visualize in the projects module the amount of the sales order/contract associated to that project. My code uses related fields and somehow I the fields show up with all their attributes from the sale order (ie help info) but they show up as empty.

Why do the fields show up correctly but not the actual values?


This is the field in the sale.order model:

from openerp import fields, models, api
class Sale(models.Model):      
_inherit = 'sale.order'
      sale_order_project = fields.One2many('project.project', 'sale_order', string = 'Sale Order Project')


This is the related field in the project model:

from openerp import fields, models, api
class Project(models.Model):         _inherit = 'project.project'
        sale_order = fields.Many2one('sale.order', string = 'Sale Order')
        amount_total_untaxed = fields.Float('Amount Untaxed', related = 'sale_order.amount_untaxed', store=True)
        amount_total = fields.Float('Amount Total', related='sale_order.amount_total',store = True)


Thanks!

Avatar
Discard
Author Best Answer

 I foud the problem, it was an issue with the record id

Since sale.order project_id is the same as project.project analytic_account_id, when requesting sales order data the id must be associated with the analityc account.


The code looks like:

from openerp import fields, models, api



class Analytic(models.Model):
_inherit = 'account.analytic.account'  
  sale_order_ids = fields.One2many('sale.order', 'project_id', string='Sale orders', store=True)


from openerp import fields, models, api
class Project(models.Model):
    _inherit = 'project.project'
amount_total = fields.Float(related='analytic_account_id.sale_order_ids.amount_total', store=True)
 
Avatar
Discard
Related Posts Replies Views Activity
1
May 24
351
1
Apr 24
346
0
Sep 23
429
1
Mar 15
3023
2
Nov 24
156