I am using the Item table and want to filter to only show items where the Qty. on Sales order is greater than the Quantity on Hand. How do I filter > or < based on another field in the table?
I have this so far…which gives me all items that are on sales orders. But I want one more filter to only show items where Qty on Sales Order > Qty on Hand.
=NL("Rows=4","Item","No.","Qty. on Sales Order",">1")
Any help is greatly appreciated. Thanks!
Date
Votes
5 comments
-
Jet Reports Historic Posts NL("Rows=4","Item","No.","=Local(NF(,""Qty. on Sales order"")>NF(,""Quantity on Hand.""))",TRUE)
should do the trick -
Jet Reports Historic Posts Any other ideas? It doesn't give me any error messages, but it still gives me all items.
-
Jet Reports Historic Posts I tried the following formula on my system and it worked.
=NL("Rows","Item",,"=Local(NF(,""Inventory"")<NF(,""Qty. on Sales Order""))",TRUE)
I know that depending on the version and language of your Navision database that the "Qty on Hand" field is called "Inventory".
Also, I'm not sure that this formula would work correctly on Jet Report 7.
Anyone else not getting it to work correctly? -
Jet Reports Historic Posts I am using Jet Reports 7.1.2, so that is proably why it is not working for me. And my NAV is 5.0
-
Jet Reports Historic Posts I have had trouble with the 'Local()' statement.
As long as your report isn't in more than one language, you can skip that function.
HTH
rmw
Please sign in to leave a comment.