NAV 2013 R2. Display open and posted headers in a subform

delaghetto

Hi!

I'm trying to make a customer List Subform where I need to display all purchases (posted and not posted) mixed.

What would be the best way to do this? I need something like a UNION query between tables 38 and 122 and add that to the source of the list, but dunno if this is possible in NAV.

Also the lines should link to the actual Order Card

Thanks

Miklos_Hollender

Well in traditional Navision I would have combined them into a temp table. Make a temp table variable of sales order lines, copy all their open sales orders, copy all their posted shipments in an intelligent way into it. Probably better do this filling out at pressing a button (action), not automatically as it is performance intensive. This could still work, but...

Today, maybe it is possible even with a query? That would loo exciting!