0

Filter

Jet Reports Historic Posts

November 17, 2014 16:53

None

Follow

Hi,

i don't really unsterstand that issue.
I think, an entry only can have one entry type.
Can you post the code you have?

regards
jetsetter

• Facebook
• Twitter
• LinkedIn

2 comments

• 0
  
  Jet Reports Historic Posts November 17, 2014 16:53

  I am trying to filter on the Item Ledger Entry Table. I want entry type = Output, but only want those records that have no Consumption (another Entry Type).
  All of my tests so far pull in those records that have both entries. Is there a simple way to do this?

• 0
  
  Jet Reports Historic Posts November 28, 2014 14:50

  The method I have used it to create two arrays for Consumption and Output and then compare the list of Order Numbers
  
  The resulting values are used to return a list of orders with output but not consumption
  
  See attached
  
  MJ

  • Production Entry Output with no Consumption.xlsx