Přejít na obsah
You need to be registered to interact with the community.
All Posts Lidé Odznaky
Štítky (View all)
odoo accounting v14 pos v15
O tomto fóru
This question has been flagged
invoice.lineorder.lines
1 Odpovědět
3643 Zobrazení
Avatar
Grf

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

Avatar
Zrušit
Avatar
Mitul Shingala
Nejlepší odpověď

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.

Avatar
Zrušit
Grf
Autor

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

Related Posts Odpovědi Zobrazení Aktivita
Building a new order from previously purchased sales order lines V18
order.lines
Avatar
Avatar
Avatar
3
bře 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
Avatar
0
led 23
1535
Odoo 14: Adding new field to invoice line from Studio Vyřešeno
invoice.line
Avatar
Avatar
2
říj 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
Avatar
2
led 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
Avatar
0
úno 20
3252