Hello experts.
I'm trying to list all Sales Order Numbers, along with their order dates and locations that match specified criteria. So what I need to do is somehow combine the following:
nl("Rows", "Sales Header", {"No.", "Order Date", "Location Code"}, < criteria >)
and
nl("Rows", "Sales Shipment Header", {"Order No.", "Order Date", "Location Code"}, < criteria >)
Sales Order Numbers may exist in the Sales Header table only, the Sales Shipment Header only, or both tables simultaneously. To further complicate things, the field name is different. I need to get a unique list of Sales Order Numbers sorted by the Sales Order Number, so simply putting 1 nl("Rows"…) line after another won't do. I'm at a loss as to how to do this. Can someone shed some light on this?
Date
Votes
2 comments
-
Jet Reports Historic Posts Hmmm, this should be possible, but perhaps a little difficult. Try something like this (you may have to change the character used to combine these from | to something else if | is present in any of the numbers or location codes):
C2: =NL("Filter","Sales Header","=NF(,""No."")&""|""&NF(,""Order Date"")&""|""&NF(,""Location Code"")",<criteria>)
C3: =NL("Filter","Sales Shipment Header","=NF(,""Order No."")&""|""&NF(,""Order Date"")&""|""&NF(,""Location Code"")",<criteria>)
C4: =NL("Rows",NP("Union",$C$2,$C$3))
D4: =NL(1,NP("Split",C4,"|"))
E4: =NL(2,NP("Split",C4,"|"))
F4: =NL(3,NP("Split",C4,"|"))
Does that work for you?
Regards,
Hughes -
Jet Reports Historic Posts Interesting. I'll try to work off of that. Thanks again!
Please sign in to leave a comment.