Zum Inhalt springen
Menü
Sie müssen registriert sein, um mit der Community zu interagieren.
Diese Frage wurde gekennzeichnet
1 Antworten
3648 Ansichten

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
Verwerfen
Beste Antwort

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
Verwerfen
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

Verknüpfte Beiträge Antworten Ansichten Aktivität
3
März 25
990
0
Jan. 23
1535
2
Okt. 21
3086
2
Jan. 25
4425
0
Feb. 20
3252