I have a Order form and Invoice form.

Order form fields: Item, incoming qty

Invoice form fields: Item, outgoing qty, price

I am trying to find a way to sum all the invoices and then enter them in a new field in the order report so that I can have a new field called "balance" (Order.incoming qty - Invoice.Outgoing qty).

What ways is that possible?

Thanks!