0

NL Rows Filter by Count

Max Poche

May 30, 2019 14:15

None

Follow

Hello All,

I am attempting to run a report using the Value Entry table where I want to run a NL Rows looking at Item Ledger Entry Type "Purchase", Document Type "Purchase Receipt" and "Purchase Invoice", where the Count of the Item Ledger Entry No. is equal to 1 (i.e. there is a Purchase Receipt, but no Purchase Invoice yet).

 

Any help is appreciated.

Thanks

• Facebook
• Twitter
• LinkedIn

1 comment

• 0
  
  Harry Lewis May 30, 2019 15:35

  Hi Max.

  Something like this?

  =NL("Rows","Value Entry",,"Item Ledger Entry Type","Purchase","Document Type","Purchase Receipt|Purchase Invoice","=NL(""Count"",""Value Entry"",,""Item Ledger Entry No."",NF(,""Item Ledger Entry No.""))","1")