0

Get a list of Customers without transactions

Jet Reports Historic Posts

February 25, 2014 12:53

None

Follow

I want to get a list of customers that have no entries in the Item Ledger Entry table

How do I do this?

Thanks

Joe

• Facebook
• Twitter
• LinkedIn

2 comments

• 0
  
  Jet Reports Historic Posts February 25, 2014 13:38

  Hi Joe,
  
  Try:
  
  =NL("Rows","Customer",,"=NL(""Count"",""Item Ledger Entry"",,""Source No."",NF(,""No.""),""Source Type"",""Customer"")","0")

• 0
  
  Jet Reports Historic Posts February 25, 2014 13:56

  Wonderful - thank you