Hi there,
I want to be able to filter by a field but the dimension code is 3 tables away…
e.g.
I want to see all PO with the reserved SO's Customer Posting Group is "Whatever"
In a traditional NAV report, I would get all PO, reference them on the reservation entry table, get the accompanying entry and using that to search for the SO and filter on the Customer Posting Group.
I want to know how I can do that in Jet?
I have tried nested Jet functions but it doesn't seem to like me and I can't figure out what else to try.
Help!
Michael
Date
Votes
4 comments
-
Jet Reports Historic Posts Hi all,
Is there no-one who can help with this issue?
Your help is very much appreciated and if I am barking up the wrong tree of using nested jet functions, please enlighten me with the right method.
Thanks again,
Michael -
Jet Reports Historic Posts Hi Michael,
You could potentially use nested NL(Filter) to accomplish this, although it would probably be faster to use Link=. Maybe you should post what you've already tried so we can tell what tables you're using and how you're trying to set up the relationships between those tables. Just saying "it doesn't seem to like me" isn't really quite enough to go on to figure out what you might be doing wrong. :)
Regards,
Hughes -
Jet Reports Historic Posts Hi Michael,
You could potentially use nested NL(Filter) to accomplish this, although it would probably be faster to use Link=. Maybe you should post what you've already tried so we can tell what tables you're using and how you're trying to set up the relationships between those tables. Just saying "it doesn't seem to like me" isn't really quite enough to go on to figure out what you might be doing wrong. :)
Regards,
Hughes
Hi Hughes,
That works perfectly! Thanks so much for your help!
Just to give an example of finding out what the (first) associated SO is to a PO line:
=NL("First","Sales Line","Document No.","Document No.",NL("Filter","Reservation Entry","Source ID","Entry No.",NL("Filter","Reservation Entry","Entry No.","Source Type",39,"Source ID",*PO NUMBER*)))
Hope this helps someone
michaellee -
Jet Reports Historic Posts Hi Michael,
Glad you figured it out and got it working! It looks to me like you could eliminate the 2nd NL(Filter) since you're going to the same table and linking on the primary key. Just as an example, you could change this to use Link= and eliminte the 2nd filter like the following:=NL("First","Sales Line","Document No.","Link=","Reservation Entry","Source ID","=Document No.","Source Type",39,"Source ID",*PO NUMBER*)
Does this work for you?
Regards,
Hughes
Please sign in to leave a comment.