0

filter item where itemledger is 0

Hi,
I would like to filter my item list where sum for the item ledger entry is 0 for that item in one NL statement. Is it possible to do that?

Example of my NL is "=NL("Rows=4","Item",,"Company=",$D$3,"No.",$D$4)" where it will get the item list based on the filter of my company and item no.

I would like to add another filter for that particular item NL where in item ledger entry, the sum for the quantity for that item is 0.

possible to do that?

1 comment

Please sign in to leave a comment.