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

delaghetto
delaghetto Member Posts: 89
edited 2014-06-05 in NAV Three Tier
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

Comments

  • Miklos_Hollender
    Miklos_Hollender Member Posts: 1,598
    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!

Categories