Hi,
First time posting I've seen a similar topic on here before but the solution does not seem to work for me. I'm trying to pull through only the items which are in stock in all the locations (defined by an option). First I use rows function to insert all locations, I then need to use rows function to identify all the items in that specific location which have stock.
The formula below:=nl("Rows","Item Ledger Entry","Item No.","=NL(""Sum"",""Item Ledger Entry"",""Quantity"",""Location Code"","""&$B3&""",""Item No."",NF(,""Item No.""))","NUMBER&>0")
Please help…
Thanks Alex
Date
Votes
2 comments
-
Jet Reports Historic Posts Hi Yakstar,
You mention that you need two "rows" functions but only list one below. My understanding is that you are looking to list out all of your items and then list each location with the quantity on hand grouped by item number.
If you do something like this for the first grouping:=NL("Rows=4","Item Ledger Entry","Item No.","Remaining Quantity","<>0","Location Code",$C$3)and something like this for the second grouping=NL("rows","Item Ledger Entry","Location Code","Location Code",$C$3,"Remaining Quantity","<>0","Item No.",$D8)I don't your database so there may be some differences but you should be able to adapt it or the concept. -
Jet Reports Historic Posts Thank you, I've managed to figure it out with your help!
Please sign in to leave a comment.