0

Customer Item Sales

Jet Reports Historic Posts

July 15, 2008 23:28

None

Follow

I've created a report that gives me annual sales by customer price group then by customer using:
=nl("Rows","Customer",,"Customer Price Group","@@"&$C$9)
and
=nf($D10,"Sales ($)","Date Filter",G$6)

I know need to have the same report but for item sales only. Is it possible to add a filter to my existing formula's to filter on the items field from the sales invoice line table? I've attached the report for further information.

Thanks in advance.

Theron
Silverware, Inc

• Cust Sales-Annual Sales2.xls

• Facebook
• Twitter
• LinkedIn

1 comment

• 0
  
  Jet Reports Historic Posts July 16, 2008 07:17

  You will need to have the sales lines then, which kinda complicates the report.
  
  However, you can obtain it with one formula, something in the likes of this:
  
  =NL("Sum";"Sales Invoice Line";"Amount";"Document No.";NL("Filter";"Sales Invoice Header";"No.";"Bill-to Customer No.";$C$3;"Posting Date";$C$4))
  Since you then have both the Lines and the Header, you can almost add every possible filter you can think of…
  
  Regards,
  
  Jan