0

Filtering blank values

Jet Reports Historic Posts

July 07, 2010 01:09

None

Follow

Hi,

NAV: 2009sp1
JR: 9.2.10131.0
I want to filter all vendors from vendor ledger entry for given date range (document date) and external document number is not blank.
But still it contains vendors where external document number is blank.
Vendors:
=NL("Rows","Vendor Ledger Entry","Vendor No.","Vendor No.",$C$5,"Document Date",$C$6,"External Document No.","<>""")

External Document Number:
=NL("Rows","Vendor Ledger Entry","External Document No.","Vendor No.",$C$5,"Document Date",$C$6,"Vendor No.",$B9,"External Document No.","<>""",

So can anyone tell me why it is showing vendors where external document number is blank even though I filtered out the blank external document numbers?

Thanks

• Facebook
• Twitter
• LinkedIn

3 comments

• 0
  
  Jet Reports Historic Posts July 07, 2010 05:48

  To filter "unequal blank" you used "unequal symbol double quote". This needs to be "unequal symbol single quote single quote". Like this if you want to copy and paste it into your report:
  
  Vendors:
  =NL("Rows","Vendor Ledger Entry","Vendor No.","Vendor No.",$C$5,"Document Date",$C$6,"External Document No.","<>"''")

• 0
  
  Jet Reports Historic Posts September 18, 2015 16:14

  Hi I am new to Jet and I want to get data from my vendor ledger which has been posted without a document type. I cant see to find the filter that does this. I am using the below as a basis and I am trying to replace the "payments LCY" within a filter that bring back transactions where this was blank in the posting.
  
  NL(,"Vendor","Payments (LCY)","Search Name","@@"&$C5,"date filter",E$3)

• 0
  
  Jet Reports Historic Posts September 18, 2015 21:15

  Hello -
  
  Are you looking for something like this?
  
  =NL("Rows","25 Vendor Ledger Entry","6 Document No.","5 Document Type","@@")