Query on fully shipped orders

vissers9

Hi all,

I'm trying to make a query on fully shipped orders so I can make an accrual on transport costs.
As I will make a Purchase document and assign an item charge I only want fully shipped orders displayed.
My thought was creating a total on "Qty" and "Qty Shipped" on the sales line table and these have to match.
But I cannot get this inserted in NAV Query to get a good result.

This is the first time I use NAV queries, but I don't see how to match a field against another one, let alone on a summed field.

Would quering be the appropriate way or would it be better to use CAL te get a recordset?
If a query is possible, please let me know how to do this.

Or maybe you have even another way to filter on fully shipped invoices.

Thanks, Rob

gravecz

use field Outstanding quantity=0.