0

Average Sales Order value

Jet Reports Historic Posts

April 27, 2015 15:12

None

Follow

I'm altering the report 'NAV081 - Essentials - Top Customer Sales Analysis' to show average sales order value.
I started by inserting a new column P
Then in P26 copied and changed M26 to =NF($E26,"7178 No. of Pstd. Invoices","55 Date Filter",P$6)
I then created the filter dates in P6
As much as I try I cant get the posted Invoices to use the filter even though the sales are using it.
I've also added "7178 No. of Pstd. Invoices" into The Function wizard for E26
All I get is the total number of invoices for the client. Does anyone know where I'm going wrong?

Chris

• Facebook
• Twitter
• LinkedIn

3 comments

• 0
  
  Jet Reports Historic Posts April 27, 2015 21:18

  Hi Chris,
  
  Is it possible that your custom field of "No Pstd. Invoices" isn't a flow field? You will probably need to count the number of invoices that posted in that date range that you want, possibly by going to the Sales Invoice Header table.

• 0
  
  Jet Reports Historic Posts April 28, 2015 11:47

  It is a flow field as far as I can tell.
  I just cant seem to get number of posted invoices by date to be available.

• 0
  
  Jet Reports Historic Posts April 28, 2015 12:59

  The "No. of Posted Invoices" field in the customer table is defined as a Count function only. There's no option to add any flow filter.
  
  The definition in Object Designer is: Count("Sales Invoice Header" WHERE (Sell-to Customer No.=FIELD(No.)))
  
  So, the best way to move on is to define your own NL("Count") on either the Sales Invoice Header table and apply any filters there (e.g. the Posting Date).