I thought I was fairly familiar with the use of LINK = to join to another table, but I am having an issue on the filter to evalute. Consider two functions and their results:
Query A: =-NL("Sum","Item Ledger Entry","Quantity","Entry Type","Sale","Posting Date",$D$7) = 5,264
Query B: =-NL("Sum","Item Ledger Entry","Quantity","Entry Type","Sale","Posting Date",$D$7,"Link=","Item","No.","=Item No.","No.","01301") = 5,264
You might point out I can pull the item number from the Item Ledger Entry table and thus don't need the join, however I have modified the function to make the difference obvious and simple specifically for this question. Query A does not specifiy an item number, while Query B does. What am I missing in this case that is apparently not evaluating the criteria in the Item table via the Link?
Date
Votes
2 comments
-
Jet Reports Historic Posts Official comment Not exactly sure if this is what your after, but I use the filter option like below. I need to pull item ledger data for products of a specific product group code. Because the product group code is not in the item ledger entry table, I have to cross ref the item table that does have the product group code.
=NL("rows","Item Ledger Entry","Item No.","Posting Date",$D$8,"Source No.",$D7,"Entry Type","Sale","Item No.",NL("filter","item","No.","No.",$D$10,"Product Group Code",$D$9)) -
Jet Reports Historic Posts Ah ha! Thank you for the suggestion. That does work, as well as my Link= formula above. I was expecting it to evaluate in Design mode but discovered I had to go to report mode for it ot work.
Please sign in to leave a comment.