I have created a formula that lists items in a filtered list of posted sales invoices but the formula is too long - 306 characters!
Is is possible to write a NL function to produce list of Sales Invoice Headers numbers as:
NL("AllUnique","Sales Invoice Header","No.","Posting Date",$D$3,"Sell-to Customer No.","@@"&"WG10831",,,,,,,,,,,,,,,0,"Faupel Home Furnishings")
into (say) cell J1 in a spreadsheet and then set a filter on Sales Invoice Line formula (say in cell D15) as:
FilterField1: "Document No."
This would reduce the number of characters to Excels allowable limits.
I have tried this but cannot get it to work.
Formula too long