Boolean field in invoice line based on sale.order.line

Odoo is the world's easiest all-in-one management software.
It includes hundreds of business apps:

All apps

1 回复

3644 查看

Can some one explane me relation between sale.order.line and invoice.line.

For example i added field check_qty = fealds.float("Qty") to sale.order.line

when i confirm SO i get Invoice that is related to SO. In that invoice are invoice.lines that are created from SO sale.order.lines.

and i have field check = fields.boolean("check") in invoice.line.

so my goal is to check related sale.order.line of invoice.line if "check_qty" > 0 then i make field check = True

Hello,

into sale.order.line has field name "invoice_lines" and into account.invoice.line has field "sale_line_ids".

this both fields type is many2many and have common relational table.

so using this two fields you can achieve your goal.

Thank you.

编写者

for line in invoice.invoice_line_ids:

if line.sale_line_ids:

if line.sale_line_ids.qty_avl_stock >= line.sale_line_ids.product_uom_qty:

if i do something like this, i can get "expecting singleton error" because it's many2many fields and there can be more then 1 record

立即创建账户，享受专属功能，与我们的精彩社区互动！

相关帖文	回复	查看
Building a new order from previously purchased sales order lines V18 order.lines	3 3月 25	990
Can someone give me an example of code to include in a server action to generate an invoice with a selection of products/quantities? invoice.line	0 1月 23	1535
Odoo 14: Adding new field to invoice line from Studio 已解决 invoice.line	2 10月 21	3086
Show three decimals in Sale Order line subtotals? Have changed currency precision to 3 decimal places (only fixes price and total, not subtotal) order.lines	2 1月 25	4425
[v10] how can i add an invoice line in invoice_line_ids by code after the change of selection field "produit" invoice.line	0 2月 20	3252