Skip to Content
Вам необхідно зареєструватися, щоб взаємодіяти зі спільнотою.
All Posts Люди Значки
Мітки (View all)
odoo accounting v14 pos v15
Про цей форум
Це запитання позначене
1 Відповісти
1000 Переглядів
Аватар
doug jenkins

I have multiple sales orders for a project.  I am trying to create a field on the project form card that will total all of the untaxed amounts on the sales orders.  I have created a One2Many field to show the list of all of the sales orders but can't figure out how to get a field on the Project form to total from the sub list.  Can anyone help?

Аватар
Відмінити
Аватар
Waleed Ali Mohsen
Найкраща відповідь

Hi Doug,

You can add computed field in project and the computed method will loop the sale orders and save the total to the the computed field as below:


total_sale_amount_untaxed = fields.Monetary(string='Total Sale Untaxed Amount', store=True, compute='_compute_untaxed_amount')

@api.depends('sale_order_ids') # replace sale_order_ids with the One2many which you created to retrieve sale orders

def _compute_untaxed_amount(self):
    for project in self:
        total_amount = 0.0
        for order in project.sale_order_ids:
            total_amount += order.amount_untaxed
        project.total_sale_amount_untaxed = total_amount

Note: The above code will work if you are using one currency but if you are using multi currency then you need to convert the sale order with secondary currency to the company currency.

Аватар
Відмінити