0

Counting Orders with specific Item Category Codes

Jet Reports Historic Posts

January 31, 2009 17:30

None

Follow

I'd like to Count the Invoices that have multiple Item Category Codes.
We are using NAV 5.0 SP1. My current formula seems to return orders that have one of the Item Category Codes OR the other. Not ones that specifically have both.

Thoughts?

I've tried the value of value of $F6 as (from our Item Category Codes):
DISPLAY
HOME ACC
DISPLAY|HOME ACC
without the desired results :-(

=NL("Count","Sales Invoice Header",,"Posting Date",$G$2,"No.",NL("Filter","Sales Invoice Line","Document No.","Item Category Code",$F6,"Location Code",G$4))

Thanks!

• Facebook
• Twitter
• LinkedIn

1 comment

• 0
  
  Jet Reports Historic Posts January 31, 2009 22:56

  You could do it like this:
  - Filter all display invoices: NL("Filter"","Sales Invoice Line","Document No.","Item Category Code",CellRefForDisplay,"Location Code",G$4))
  - Filter all home acc invoices: NL("Filter"","Sales Invoice Line","Document No.","Item Category Code",CellRefForHomeacc,"Location Code",G$4))
  - Count all invoices: =NL("Count","Sales Invoice Header",,"Posting Date",$G$2,"No.",NP("Intersect",CellRefForDisplayInvoices, CellRefFroHomeaccInvoices))