TIP: You can type at any time to perform a new search.
Stock Move Pivot Total Price
stock_move_pivot_total_price · OCA/stock-logistics-reporting
Security findings
Migration considerations
- Raw `cr.execute()` INSERT/UPDATE/DELETE bypasses the ORM (no compute/constrains/tracking/mail): `WITH product_prices AS ( SELECT pt.id AS product_id, sm.id AS stock_move_id, (pt.list_price + (COALESCE(SUM(pav.default_extra_price), 0) + COALESCE(SUM(ptav.price_extra), 0))) * SUM(sm.quantity) AS total_price FROM product_template pt INNER JOIN product_product as pp ON pp.product_tmpl_id = pt.id LEFT JOIN product_variant_combination pvc ON pt.id = pvc.product_product_id LEFT JOIN product_template_attribute_value ptav ON pvc.product_template_attribute_value_id = ptav.id LEFT JOIN product_attribute_value pav ON ptav.product_attribute_value_id = pav.id LEFT JOIN stock_move sm ON sm.product_id = pp.id GROUP BY pt.id, pt.list_price, sm.id ) UPDATE stock_move sm SET product_total_price = pp.total_price FROM product_prices pp WHERE sm.id = pp.stock_move_id;` - re-check the table/column names still match after upgrading. migration-raw-sql-write · source
Migration review checklist, not a compatibility verdict. No target version is selected: apply version-specific advice only when migrating to that version or later.
- Repository
- OCA/stock-logistics-reporting · module folder · Try on Runboat
- Module version
- 1.0.0
- Category
- Stock
- Folder size
- 0.04 MB
- License
- AGPL-3
- Application
- No
- Auto-installable
- No
- Website
- https://github.com/OCA/stock-logistics-reporting
- Last tracking update
- 2026-08-07 08:42:55
- Authors
- Odoo Community Association (OCA), APSL-Nagarro
- Maintainers
- Odoo Community Association (OCA), APSL-Nagarro
- Committers
- OCA-git-bot, oca-ci, Bhavesh Heliconia
- Odoo dependencies
- Python dependencies
- None
- System dependencies
- None
- Required by
- None
- Description
This module introduces Product total price for every stock move, wich can be selected as a measure in Move Analysis.
Code Analysis
Views touched (1)
| XML ID | Name | Model | Type | Status |
|---|---|---|---|---|
view_move_pivot_inherit |
stock.move.pivot.inherit | stock.move | pivot | Inherits stock.view_move_pivot |
HTTP endpoints (0)
No HTTP endpoints found for this module.
Models touched (1)
New fields (1)
-
product_total_priceFloatcompute='_compute_product_total_price'store=Truestring='Total Product Price'
No public methods.
Loading…