0

NL table but using OR logic on 2 fields instead of AND

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)"

0 comments

Please sign in to leave a comment.