This one may be a simple question but:
How do I use an Array filter in combination with a Link= ?
The specific case is as follows:
=NL("Rows","Production BoM Line",,"Link=","Sales Line", "Document No.", "=Production BoM No.","Document No.",NP("Difference",NL("Filter","Sales Line","Document No.","No.","MK-REQUIRED"),NL("Filter","Sales Line","Document No.","No.","MK-STAGED|MK-INTRANSIT|MK-RECEIVED")),"No.", "MK-REQUIRED")
The reason I'm using the Difference NP is that I need to find all Sales Orders where, in the Sales Line, the No. MK-REQUIRED is used but if that Sales Order also has MK-STAGED, MK-INTRANSIT or MK-RECEIVED, then I do not want that Sales Order No.
Those Sales Lines Document No. that match the array filter, then get passed to another Table (Production BoM Line) where I then do other stuff.
Any help is appreciated!
Date
Votes
1 comment
-
Jet Reports Historic Posts Hi,
You can try embedding the array in a join statement. There are some problem you may run into if the list is overly long though and may need to use the Split function or find a different way of pulling the data.
Attached is a sheet that shows the array being joined together. The report is a really bad example, but does show how this can be done.
Hope this helps.
Jason
Please sign in to leave a comment.