0

Last week sales and open orders

Jet Reports Historic Posts

April 17, 2013 12:17

None

Follow

Hi I was curious if any one could help me get this info.So far I was able to bring in the current sales from the customer table.I am stuck on how to make the data only show me last weeks number though.The second part of the report would be a list of all open orders possibly on the same report or a new tab worst case. :D

• Facebook
• Twitter
• LinkedIn

2 comments

• 0
  
  Jet Reports Historic Posts April 17, 2013 19:10

  ***Update***
  
  
  Ok so I think I am getting close to figuring this report out.I am stuck on the last week sales though.I thought maybe doing a date filter on "sales ($)" of a week would work,but no luck so far.Any tips would be greatly appreciated.

  • open sales orders and last week sales.xlsx
• 0
  
  Jet Reports Historic Posts April 18, 2013 18:52

  In order to get the sum of last week's sales for a customer, I think you could just sum the Sales (LCY) field from the Cust. Ledger Entry table. Would something like this work?
  
  =NL("Sum","Cust. Ledger Entry","Sales (LCY)","Posting Date",NP("DateFilter",TODAY()-7),"Customer No.",C9)
  This would give you a rolling 7-day week's worth of sales. Of course you could also use some Excel formulas to find last week's Monday or use a specific date instead. Does something like this help?
  
  Regards,
  Hughes