Skip ke Konten
Pertanyaan ini telah diberikan tanda
projectsales.orderrelated_fields
1 Balas
6958 Tampilan
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
Buang
Avatar
Corven
Penulis Jawaban Terbai

 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
Buang
Post Terkait Replies Tampilan Aktivitas
Action to create Project from sales order Diselesaikan
action project sales.order
Avatar
Avatar
Avatar
Avatar
Avatar
4
Sep 25
1799
creating and editable related field from product.template on Sales order - Odoo 16
sales.order related_fields Studio
Avatar
Avatar
1
Mei 24
2411
Why sales Order cannot change?
project sales.order helpme odoo16features
Avatar
Avatar
1
Apr 24
2176
Create a new project once quote is accepted by client
project task invoices sales.order
Avatar
0
Sep 23
2108
Create Project from Sales Order or Invoice
project invoice automated sales.order
Avatar
Avatar
1
Mar 15
4194