0

How to show items that appear in multiple tables

Jet Reports Historic Posts

August 24, 2012 11:25

None

Follow

Hi,

I would like to show per month the items that appear on item ledger entries (by using the posting date) OR on sales lines (by using the shipment date). If an Item occurs on item ledger entries and on sales lines, it should only appear once within that month. Should look like that:

05/2012
Item IT005
Item IT020
06/2012
Item IT010

I have tried several things, but I find no working solution.
Thanks a lot for any help,
Steven Debruyne

• Facebook
• Twitter
• LinkedIn

2 comments

• 
  Jet Reports Historic Posts August 24, 2012 14:28 Official comment

  Hi Steven,
  
  In order to create a union of the item numbers from the Item Ledger Entry and Sales Line table, you must use the NP(Union) function combined with NL(Filter) functions like this:
  
  =NL("Rows",NP("Union",NL("Filter","Item Ledger Entry","Item No.",…..),NL("Filter","Sales Line","No.",…….)))
  Does this help?
  
  Regards,
  Hughes

• 0
  
  Jet Reports Historic Posts August 27, 2012 11:10

  Hi Hughes,
  
  This was what I needed! Many thanks.
  
  Regards,
  Steven