0

Sales Invoice selections

Jet Reports Historic Posts

July 28, 2009 16:34

None

Follow

How do I select from the sales invoice header only those customers who have purchased certain items in the sales invoice line table?

If I want it listed by state, I don't want to see the customers who have not purchased the item.

• Facebook
• Twitter
• LinkedIn

1 comment

• 0
  
  Jet Reports Historic Posts July 29, 2009 01:42

  NL("Rows","Sales Invoice Header","No.",NL("Filter","Sales Invoice Line","Document No.","Item No.", Cell Reference , "Variant Code", Cell Reference),"+State","*")
  
  that will list the Invoice Header Numbers that have that item Against them. Sorted by State.
  
  -BRomy