Hello,
My company has three warehouses and we make daily many internal transfers, we want to show the value of teh products(price) in each transfer
in teh table of the internal transfer items we would like to add acolumn of price and a total price of all the transfered products
Note: Odoo V19 Enterprise edition
thanks
This question has been flagged
2
Replies
1124
Views
Hi,
Please refer to the code:
from odoo import models, fields, api
class StockMove(models.Model):
_inherit = 'stock.move'
unit_cost = fields.Float(
string='Unit Cost',
compute='_compute_unit_cost',
store=True
)
line_value = fields.Float(
string='Line Value',
compute='_compute_line_value',
store=True
)
@api.depends('stock_valuation_layer_ids.unit_cost')
def _compute_unit_cost(self):
for move in self:
svl = move.stock_valuation_layer_ids[:1]
move.unit_cost = svl.unit_cost if svl else 0.0
@api.depends('quantity_done', 'unit_cost')
def _compute_line_value(self):
for move in self:
move.line_value = move.quantity_done * move.unit_cost
from odoo import models, fields, api
class StockPicking(models.Model):
_inherit = 'stock.picking'
total_transfer_value = fields.Float(
string='Total Transfer Value',
compute='_compute_total_transfer_value',
store=True
)
@api.depends('move_ids.line_value')
def _compute_total_transfer_value(self):
for picking in self:
picking.total_transfer_value = sum(
picking.move_ids.mapped('line_value')
)
Hope it helps.
Not a simple answer. By value you mean the cost of the product or the sales price? Is the company multi-currency? Do you have product variants? Do you have UOM conversion for products?
The answers to the above change which fields are used to perform the computation, but regardless you are going to need at a minimum three customer fields. The first custom field is the move's line item value which will be part of the Product Move (Stock Line) aka stock.move.line model. The second is the move total which is on the Stock Move stock.move table. The third is a currency_id field for the line item referencing the res.currency table.
The line item value (let's call that field stock.move.line/x_value_total) calculation is going to depend a lot on the first part set of questions I asked.
Edit: It will be a monetary field referencing the currency_id field. The correct qty field I believe is quantity_product_uom (quantity of line item converted to the base quantity of the product) which is multiple by the product's (from product.product) cost / sales price. If the currencies are different then currency conversion will be needed too.
The stock move total will of course be a summation of the all of the line's x_value_total.
UI additions can be handled in Odoo Studio by going to the form, opening Odoo Studio, clicking on the appropriate section and adding the monetary fields where you need them.
Enjoying the discussion? Don't just read, join in!
Create an account today to enjoy exclusive features and engage with our awesome community!
Sign up| Related Posts | Replies | Views | Activity | |
|---|---|---|---|---|
|
0
Dec 25
|
1242 | ||
|
1
Sep 24
|
3451 | ||
|
2
May 26
|
6317 | ||
|
1
May 25
|
2384 | ||
|
0
Aug 24
|
3016 |
