Skip to Content
You need to be registered to interact with the community.
All Posts People Badges
Ključne besede (View all)
odoo accounting v14 pos v15
About this forum
This question has been flagged
methodfunction_field
1 Odgovori
8047 Prikazi
Avatar
Grf
0

I have this function that calculates qty_incoming, but there is an outgoing_qty field that I want to calculate with the same function and not to create separate function for its calculation. how can I do this?

 _columns = {
            '
            'incoming_qty': fields.function(_product_inc_out_qty, type='float',
                digits_compute=dp.get_precision('Product Unit of Measure'),
                string='Incoming'
            ),
            'outgoing_qty': fields.function(_product_inc_out_qty, type='float',
                digits_compute=dp.get_precision('Product Unit of Measure'),
                string='Outgoing'
            ),
        }

function:

def _product_inc_out_qty(self, cr, uid, ids, field_names=None, arg=False, context=None):
        if context is None:
            context = {}

        res = {}
        for move_id in ids:
            move = self.browse(cr, uid, move_id, context=context)

            res[move.id] = move.product_id.incoming_qty or 0.0
        return res



if I do something like this, then I get error TypeError: float() argument must be a string or a number


def _product_inc_out_qty(self, cr, uid, ids, field_names=None, arg=False, context=None):
        if context is None:
            context = {}

        res = {}
        vals = {
            'outgoing_qty': 0.0,
            'incoming_qty': 0.0,


        }
        for move_id in ids:
            move = self.browse(cr, uid, move_id, context=context)
            vals['outgoing_qty'] = move.product_id.qty_available or 0.0
            vals['incoming_qty'] = move.product_id.incoming_qty or 0.0
            res[move.id] = vals

        return res

Avatar
Opusti
Avatar
Niyas Raphy (Walnut Software Solutions)
Best Answer

Hi,

In the sales module you can see similar sample in which for multiple field values are computed using the same function, have a look at those function and you can update your case.


See the sample:

amount_tax = fields.Monetary(string='Taxes', store=True, readonly=True, compute='_amount_all')
amount_total = fields.Monetary(string='Total', store=True, readonly=True, compute='_amount_all', track_visibility='always', track_sequence=6)

Compute function: 

@api.depends('order_line.price_total')
def _amount_all(self):
    """
    Compute the total amounts of the SO.
    """
    for order in self:
        amount_untaxed = amount_tax = 0.0
        for line in order.order_line:
            amount_untaxed += line.price_subtotal
            amount_tax += line.price_tax
        order.update({
            'amount_untaxed': amount_untaxed,
            'amount_tax': amount_tax,
            'amount_total': amount_untaxed + amount_tax,
        })


You can see same code in v8 here in this file: https://github.com/odoo/odoo/blob/8.0/addons/sale/sale.py

Thanks

Avatar
Opusti
Grf
Avtor

I updated my question, I tried something similar but getting error

Grf
Avtor

TypeError: float() argument must be a string or a number

Related Posts Odgovori Prikazi Aktivnost
Expected singleton Solved
method
Avatar
Avatar
Avatar
Avatar
9
mar. 20
42924
Triggering method
method
Avatar
Avatar
2
okt. 18
4690
adding lines without overwriting existing
method
Avatar
Avatar
1
okt. 17
5010
i want to write in database
method
Avatar
Avatar
1
mar. 15
5430
Write method
method
Avatar
Avatar
Avatar
2
mar. 15
7599