I'm trying to create a data dump to give me back all items that don't have any sales in 2017 and I originally used this function: =NL("Rows","Item",,"DataSource=","MyDataSource","Item Category Code","<>Blocked","Company=",$C$6,"Link=","Item Ledger Entry","Item No.","=No.","Entry Type","<>Sale","Posting Date",) and it returned some items that had Sale within that posting date.
I also tried the NP difference although I'm not sure quite how to use it it also returned items that contained Sale
in cell F10=NL("filter","item ledger entry","item no.","DataSource=","MyDataSource","Entry Type","<>sale")
in cell F11=NL("filter","item","no.","DataSource=","MyDataSource","Inventory Posting Group",$C$3,"Item Category Code","<>Blocked,"Sales Location Code","*","Date Filter","1/1/17..12/31/17","Company=",$C$6)
in cell F12=NP("difference",$F$11,$F$10)
in cell F15=NL("rows","item",,"DataSource=","MyDataSource","no.",$F12)
Can anyone provide any suggestions on why the NP difference wouldn't work?
