Skip to Content
This question has been flagged
projectsales.orderrelated_fields
1 Respondre
6957 Vistes
Avatar
Corven

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
Descartar
Avatar
Corven
Autor 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
Descartar
Related Posts Respostes Vistes Activitat
Action to create Project from sales order Solved
action project sales.order
Avatar
Avatar
Avatar
Avatar
Avatar
4
de set. 25
1796
creating and editable related field from product.template on Sales order - Odoo 16
sales.order related_fields Studio
Avatar
Avatar
1
de maig 24
2411
Why sales Order cannot change?
project sales.order helpme odoo16features
Avatar
Avatar
1
d’abr. 24
2176
Create a new project once quote is accepted by client
project task invoices sales.order
Avatar
0
de set. 23
2107
Create Project from Sales Order or Invoice
project invoice automated sales.order
Avatar
Avatar
1
de març 15
4193