Hi,
I'm trying to pull a list of Document No's in Purchase Line table where Amt. Rcd. Not Invoiced (LCY) <> 0 or Outstanding Amount (LCY) <> 0
When I add a filter to these it only pulls entries using AND logic.
Any suggestions please?
Currently using this "=NL("Table","Purchase Line",$E$11:$M$11,"Headers=",$E$10:$M$10,"TableName=","Purchase Line",,,"IncludeDuplicates=","True","Company=","Unified Purchase Ledger US","Venue Code",$D$5,"Sub-Company Account No.",$D$6,"Order Date",$D$7)"