0

Sales by weekday

Jet Reports Historic Posts

January 27, 2009 23:14

None

Follow

Hi,

I am new to this community and been using Jet for over 2 years.

I've recently come across a rather complicated but at first looks easy to do requirement. Basically, I need to produce a sales figure for each day of the week for a given period / date range.

Any ideas will be much appreciated. Thank you.

• Facebook
• Twitter
• LinkedIn

2 comments

• 
  Jet Reports Historic Posts January 28, 2009 15:17 Official comment

  Hi Jerry,
  
  What database are you using (NAV, GP, etc). I have a simple Navision example report that uses the Navision Date table with the "Cust. Ledger Entry" table to get the sales by day of the week.
  
  This report uses =NL("Filter","Date","Period Start","Period Type","Date","Period Start",$E$4,"Period Name",F$8)to first get all the dates from the Date table that matches my criteria (ie Date Filter and Name of the weekday). Then we use an =NL("Sum","Cust. Ledger Entry","Amount","Posting Date",F$6,"Document Type","Invoice|Credit Memo") to get the sum of the customer ledger entries for the dates returned by the NL("Filter")
  
  Hopefully this will get you going and welcome to the community.
  
  SalesByDayOfWeek.xls
• 0
  
  Jet Reports Historic Posts August 12, 2009 01:21

  thanks for this sherman