Sale Manual Delivery (sale_manual_delivery)

Security findings

Migration considerations

Raw `cr.execute()` INSERT/UPDATE/DELETE bypasses the ORM (no compute/constrains/tracking/mail): `update sale_order_line as sol set qty_procured = r.qty_procured, qty_to_procure = sol.product_uom_qty - r.qty_procured from (select sol.id, sum( case when ( sl.usage = 'customer' and sm.origin_returned_move_id is null or ( sm.origin_returned_move_id is not null and sm.to_refund )) then ROUND( ((sm.product_uom_qty / sm_product_uom.factor) * sol_product_uom.factor), SCALE(%s) ) when ( sl.usage != 'customer' and sm.to_refund ) then ROUND( ((sm.product_uom_qty / sm_product_uom.factor) * sol_product_uom.factor), SCALE(%s) ) * -1 else 0 end) AS qty_procured from sale_order_line as sol inner join ( select sol.id, sm.id as move_id, sm.location_id, sm.location_dest_id from sale_order_line as sol left join stock_move as sm on ( sm.state != 'cancel' and sm.scrap_id is null and sol.product_id = sm.product_id and sm.sale_line_id = sol.id ) ) as q on q.id = sol.id left join stock_move as sm on sm.id = q.move_id left join product_product as pp on pp.id = sol.product_id left join product_template as pt on pt.id = pp.product_tmpl_id left join stock_location as sl on sl.id = q.location_dest_id LEFT JOIN uom_uom sm_product_uom ON sm.product_uom = sm_product_uom.id LEFT JOIN uom_uom sol_product_uom ON sol.product_uom_id = sol_product_uom.id group by sol.id, sm.product_uom, sol.product_uom_id ) as r where r.id = sol.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/sale-workflow · module folder · Try on Runboat
Module version: 1.0.0
Category: Sale
Folder size: 0.56 MB
License: AGPL-3
Application: No
Auto-installable: No
Website: https://github.com/OCA/sale-workflow
Last tracking update: 2026-08-07 09:06:23
Authors: Odoo Community Association (OCA), Camptocamp SA
Maintainers: Odoo Community Association (OCA), Camptocamp SA
Committers: Weblate, Tobias Zehntner, OCA-git-bot, oca-ci

Odoo dependencies

OCA/sale-workflow:

- sale_stock_reference_by_line

odoo/odoo:

- stock_delivery

- sale_stock

- sale

- sales_team

- base

- mail

- base_setup

- web

- bus

- account

- product

- uom

- portal

- digest

- payment

- utm

- stock_account

- stock

- barcodes_gs1_nomenclature

- barcodes

- delivery

- payment_custom

Python dependencies

None

System dependencies

None

Required by

None

Description

The goal of this module is to allow the manual creation of delivery
slips. If activated, a sale order won't directly impact the stock. It
will not make a reservation on the stock. It allows the delivery and the
impact on stock to be done manually when needed. The goal is to be used
on long term projects where not all the material is shipped at once. As
you make many shipments, every time you make a new delivery, you can
choose an new carrier as well as a planned date. A wizard helps you to
chose what to deliver by showing you how much you already planned to
ship.

![Field](../static/description/field.png)

![Wizard](../static/description/wizard.png)

Code Analysis info_outline

Views touched (5)

XML ID	Name	Model	Type	Status
`crm_team_view_form`	crm.team.form	crm.team	form	Inherits sales_team.crm_team_view_form
`manual_delivery_wizard_form`	manual.delivery.wizard.form	manual.delivery	form	New
`view_order_form`	sale.order.form	sale.order	form	Inherits sale.view_order_form
`view_order_line_tree`	sale.order.line.tree	sale.order.line	tree	Inherits sale.view_order_line_tree
`view_sales_order_undelivered_line_filter`	sale.order.undelivered.line	sale.order.line	search	New

HTTP endpoints (0)

No HTTP endpoints found for this module.

Models touched (7)

New fields (1)

manual_delivery Boolean
help='If enabled, the deliveries are not created at SO confirmation. You need to use the Create Delivery button in order to reserve and ship the goods.'

Public methods (0)

No public methods.

New fields (6)

carrier_id Many2one → delivery.carrier
ondelete='cascade' string='Delivery Method' args: 'delivery.carrier'
commercial_partner_id Many2one → res.partner
ondelete='cascade' readonly=True required=True args: 'res.partner'
date_planned Date
line_ids One2many → manual.delivery.line
string='Lines to validate' args: 'manual.delivery.line', 'manual_delivery_id'
partner_id Many2one → res.partner
domain="['|',('id', '=', commercial_partner_id),('parent_id', '=', commercial_partner_id)]" ondelete='cascade' string='Delivery Address' args: 'res.partner'
route_id Many2one → stock.route
domain=[('sale_selectable', '=', True)] help='Leave it blank to use the same route that is in the sale line' ondelete='cascade' string='Use specific Route' args: 'stock.route'

Public methods (2)

confirm(self)
Creates the manual procurements
default_get(self, fields)
@api.model

New fields (7)

manual_delivery_id Many2one → manual.delivery
ondelete='cascade' readonly=True required=True string='Wizard' args: 'manual.delivery'
name Text
related='order_line_id.name'
order_line_id Many2one → sale.order.line
ondelete='cascade' readonly=True required=True string='Sale Order Line' args: 'sale.order.line'
product_id Many2one
related='order_line_id.product_id'
qty_ordered Float
help='Quantity ordered in the related Sale Order' readonly=True related='order_line_id.product_uom_qty' string='Ordered'
qty_procured Float
related='order_line_id.qty_procured'
quantity Float

Public methods (0)

No public methods.

New fields (2)

has_pending_delivery Boolean
compute='_compute_delivery_pending' args: 'Delivery Pending'
manual_delivery Boolean
help='If enabled, the deliveries are not created at SO confirmation. You need to use the Create Delivery button in order to reserve and ship the goods.'

Public methods (1)

action_manual_delivery_wizard(self)

New fields (2)

qty_procured Float
compute='_compute_qty_procured' help='Quantity already planned or shipped (stock movements already created)' readonly=True store=True string='Quantity Procured'
qty_to_procure Float
compute='_compute_qty_to_procure' help='There is Pending qty to add to a delivery' readonly=True store=True string='Quantity to Procure'

Public methods (0)

No public methods.

New fields (0)

No new fields.

Public methods (0)

No public methods.

New fields (2)

date_planned Date
partner_id Many2one → res.partner
args: 'res.partner'

Public methods (0)

No public methods.

Loading…

build Migration considerations

Code Analysis info_outline

Views touched (5)

HTTP endpoints (0)

Models touched (7)

crm.team Extends Model 1 field 0 methods CrmTeam · inherits crm.team

manual.delivery New model TransientModel 6 fields 2 methods ManualDelivery · Manual Delivery

manual.delivery.line New model TransientModel 7 fields 0 methods ManualDeliveryLine · Manual Delivery Line

sale.order Extends Model 2 fields 1 method SaleOrder · inherits sale.order

sale.order.line Extends Model 2 fields 0 methods SaleOrderLine · inherits sale.order.line

stock.move Extends Model 0 fields 0 methods StockMove · inherits stock.move

stock.reference Extends Model 2 fields 0 methods StockReference · inherits stock.reference

Migration considerations