Overslaan naar inhoud
Menu
Je moet geregistreerd zijn om te kunnen communiceren met de community.
Deze vraag is gerapporteerd
1 Beantwoorden
3663 Weergaven

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
Annuleer
Beste antwoord

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
Annuleer
Auteur

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

Gerelateerde posts Antwoorden Weergaven Activiteit
3
mrt. 25
994
0
jan. 23
1536
2
okt. 21
3087
2
jan. 25
4425
0
feb. 20
3252