0

Additional filter in a multiple filtered NL

I would like to also add a filter for Invoiced Qty <>0 first in addition to the current =0 for both remaining and invoiced.

I am not sure where to place this to behave correctly.

=NL("Rows","Purch. Rcpt. Header",,"-=Local(NL(""Sum"",""Item Ledger Entry"",""Remaining Quantity"",""Document No."",NF(,""No.""),""Entry Type"",""Purchase"")+NL(""Sum"",""Item Ledger Entry"",""Invoiced Quantity"",""Document No."",NF(,""No.""),""Entry Type"",""Purchase""))","=0")

Thank you for your help!

0 comments

Please sign in to leave a comment.