T-SQL UNION function using JFX

Hello Everyone,

If I wanted to create a report that will list Document No, Item No and Amount fields from Sales Invoice Line and Purch. Inv. Line tables in NAV, how do i properly do that? I wanted to emulate the UNION T-SQL function. I have tried the NP(Union) using 2 NP filters but so far I can only retrieve 1 field at a time for NP(filter).

Thanks in advance. :D


Please sign in to leave a comment.