Hello!
I am trying to filter my Item Ledger entries by the Replenishment System on the Item card. I can't seem to get any iteration to work, looking at other user's formulas. Can someone provide an example to me?
Date
Votes
1 comment
-
Harry Lewis Hello Amanda -
One way to do this would be to use the LINK= filter.
For example, if I wanted a list of my customer numbers where there was a record for that customer in the Cust. Ledger Entry table where the Salesperson Code was set to PS, I could use this:
=NL("Rows","Customer","No.","Link=","Cust. Ledger Entry","Customer No.","=No.","Salesperson Code","PS")More info can be found in the Using Link= article in this Help Center.
Please sign in to leave a comment.